Intro to Blazor Server Side - Includes SQL Data Access and Best Practices
Blazor Server Side is an ASP.NET Core application type that uses SignalR to connect the client to the server. This allows for a rich, client-side interactivity with just C# code (no JavaScript needed). In this video, we will walk through what Blazor Server Side is, how it compares to Blazor Client Side, how to set it up and use it, and even how to connect it to SQL to create a real page that inserts data into the database and displays information from the database.
Mailing List: signup.iamtimcorey.com/
Source Code: leadmagnets.app/?Resource=Bla...
Courses: IAmTimCorey.com/courses
0:00 - Intro
1:22 - Creating new Blazor Server App
4:46 - Balzor Server App overview
11:08 - Counter page explained
18:15 - Counter Page Network traffic
25:00 - Fetch Data page explained
32:24 - Data Access
32:55 - Data Access: Standard Class Library with Dapper
46:59 - Data Access: Blazor App configuration and database connection string
49:02 - Data Access: New Razor Component page and display Data from database
59:30 - Data Access: Save data with data validation
1:03:52 - Data Access: Blazor UI from
1:08:25 - Data Access: Save data from form
1:13:36 - Summary and concluding remarks
Thanks to Ralfs HBK for the chapters breakdown
Пікірлер: 845
Tim, thank you so much for this, your tutorial is so clear and concise. I haven't programmed in about 5 years and just getting back into it and coming from a VB desktop application background it was a bit daunting. This tutorial and your c# to SQL tutorial made things so easy to understand. Easily the best tutorials around. Cheers.
@IAmTimCorey
4 жыл бұрын
Excellent! I am glad it was so helpful.
Great introduction to Blazor Server-Side and one of the best "how-to" programming tutorials I've watched - clear, understandable and to the point.
@IAmTimCorey
4 жыл бұрын
Thank you!
Thanks Tim. I've been messing with Blazor for a while (back in the preview versions) and never had very good experiences with it partly because lots of stuff changed from each preview release. This video was awesome and I learned a LOT! I've been using C# for about 10 years and still watch some of your fundamental videos and still learn stuff. Keep up the good work. I plan on subscribing to your Patreon.
@IAmTimCorey
4 жыл бұрын
I'm glad my content has been so helpful.
this guy is a fantastic teacher - subscribed! - I had ran up the demo project and thought I had it figured Tim showed many great tricks and explanations - Thanks Tim!
Awesome introduction to Blazor. I must also admit that this is one of the few video tutorials I've been fully engage with all of the way through. Thank you.
@IAmTimCorey
4 жыл бұрын
Great to hear!
Phenomenal tutorial! Learned a ton watching this. Thanks for the great upload!
@IAmTimCorey
4 жыл бұрын
Thank you!
I've done half a dozen of these Blazor CRUD tutorials, and this is the first one that was clearly explained and "just enough" to get me through these early stages of learning. Thank you so much!
@IAmTimCorey
Жыл бұрын
You are welcome.
@PeterMisovicProfile
Жыл бұрын
Exactly!
I am new to Blazor and using SQL and man, I have to say, you NAILED this video! Thank you for such great content!!!! Very well done!
@IAmTimCorey
3 жыл бұрын
Awesome! Thank you!
I keep coming back to this tutorial. You are an excelent teacher! Thank you so much!
@IAmTimCorey
4 жыл бұрын
I am glad it was helpful!
Thanks a lot, Tim! That was EXACTLY what I was looking for to get started with an app. I wish you all the best and, of course, you have another pupil for a long time. :) Thanks again.
@IAmTimCorey
2 жыл бұрын
Glad it was helpful!
@Tim Thanks for pointing out the path vs. blazor component 'disconnect' (at the 50 minute mark of the video for others)! That disconnect is exactly what gets people confused in the real world. So cheers and please keep up the great work.
@IAmTimCorey
4 жыл бұрын
You are most welcome.
You sir help this world become a better place. I appreciate your effort. Thank you for this lesson, and for helping us!
@IAmTimCorey
4 жыл бұрын
You are welcome.
I love the idea of making this kind of web apps without the need for JavaScript 🤩. There’re some topics that i find complicated and wrap my head around but you have a way to explain things that makes it like it’s simple, to me that’s a Great Teacher as always... thanks Tim, you are the best !
@tomthelestaff-iamtimcorey7597
3 жыл бұрын
Thank you for sharing.
Ima wathing thes for second time - a lot of good structured information, well done!
@IAmTimCorey
4 жыл бұрын
Thank you!
I am haven't coding since ASP Classic and I was huge into building applications back then. This is the best video I found so far for working with Dbs. Thank you. I have a long road ahead.
@IAmTimCorey
Жыл бұрын
You are welcome.
This was the best intro on Blazor. I loved it. Thanks Tim.
@IAmTimCorey
4 жыл бұрын
You're welcome!
nice video Tim, I never believe you can do a great Intro in 1 hour and 20 mins. Thanks Tim.
@IAmTimCorey
2 жыл бұрын
Thanks!
TIM! Thank you! THIS IS HOW CLASSES ARE SUPPOSED TO BE TAUGHT! You have explained WHAT, WHY, and HOW. Most courses only explain what to do. Standing ovation. You are an EDUCATOR. You've got yourself a new subscriber. I also very much appreciate the throwback to the "under construction" GIF of the 90s, at 27:25. Ah, those were the days, hacking out HTML between college classes so I don't completely starve to death.
@IAmTimCorey
Жыл бұрын
I'm glad you enjoyed it.
@AthelstanEngland
Жыл бұрын
@@IAmTimCorey agreed excellent video again. Tim, is this still relevant as a good foundation for someone just getting ready for first Blazor app, or should we be looking at another/extra video. Thanks.
Tim this is just awesome. I watched this did the code then I watched it again and created notes on all steps and suggestions you have. The other blazor videos are now in my watch later. Thanks again.
@IAmTimCorey
3 жыл бұрын
Excellent! That’s a great way to learn.
This is by far the best 'real-world' Blazor tutorial I have seen. Great work Tim. Will you be doing a client-side video as we get closer to launch ?
@IAmTimCorey
4 жыл бұрын
Thanks! And yes, I will.
The Video is great, and i really like your comment at the end, telling us to choose things on purpose. thx a million. I stardted learning blazor yesterday with your videos, and now i have my firts project running correctly. grazie
@IAmTimCorey
3 жыл бұрын
Glad it was helpful!
I'm pretty sure you saved my neck, Tim Corey. EF Core just wasn't clicking with my application needs and I thought I was gonna get canned for sticking my neck out so far for Blazor. Turns out I just needed the right tool for the job! I can't thank you enough man.
@IAmTimCorey
2 жыл бұрын
Excellent!
since I started as "Junior Developer" ,you're my Great Teacher ,Many Thanks Tim 🙂
@IAmTimCorey
11 ай бұрын
You are welcome.
Great demo Tim. Wrapping my head around it. Thanks again.
@IAmTimCorey
4 жыл бұрын
You are welcome.
@mscotthowell1
4 жыл бұрын
I love using dapper. I have watched this video many times and after numerous retries I have built a blazor app using the sakila database on mysql using vscode/vim and dotnet command line running on Fedora Core 31. So far it's working great. Again, thanks.
After 10 Years I have resumed my work... Your tutorials helped me a lot to get all through again... Thank You Soo Much.. God Bless You .. :-)
@tomthelestaff-iamtimcorey7597
2 жыл бұрын
Thanks for looking to Tim when you needed the help.
Thank you so much Tim. Great introduction to Blazor server side.
@IAmTimCorey
4 жыл бұрын
You are welcome.
Your C# videos have been immensely helpful, thank you!
@IAmTimCorey
2 жыл бұрын
You are welcome.
Thanks for this, it's great. Im starting out the long path of rewriting a .NET web forms app i wrote years ago. Im not a trained programmer, Infrastructure mainly, but we never get access to our devs to do internal IT apps, so I try and learn some stuff myself to do some internal work. Coming from the fairly simple .aspx and .cs world it's quite daunting jumping into these very different (for me) frameworks. You have made it just that little less daunting. This has been a great help. Thankyou.
@IAmTimCorey
3 жыл бұрын
Glad it was helpful!
THANK YOU SO MUCH!! I was able to code along with you in a project that I am working on. Incredibly helpful!!
@IAmTimCorey
4 жыл бұрын
Fantastic!
Happy birthday Tim. Thanks for all you do
@IAmTimCorey
2 жыл бұрын
Thank you!
Overall your content is brilliant. Definitely a must for all newcomers to the technologies you discuss.👍🏾
@IAmTimCorey
2 жыл бұрын
Thanks!
I haven't built web applications in a while and the world moved - wow!. It may have been 3 years since you recorded this, but this is EXACLTY what I needed to get back into this arena. Thank you.
@IAmTimCorey
10 ай бұрын
That's great!
@pjn2001
10 ай бұрын
@@IAmTimCorey Hi Tim. Thanks for all your excellent content that you put out. I was curious to know if this video is still relevant in regards to .net 7/8 or should I be looking at other more recent videos?
@IAmTimCorey
10 ай бұрын
Yep, it mostly is. The biggest thing will be that Program.cs and Startup.cs have been collapsed into just Program.cs. I have a video covering the differences. Other than that, the rest is almost entirely still relevant.
@pjn2001
10 ай бұрын
@@IAmTimCoreyGreat stuff. Seems like nothing major then. I will definitely check out that video as well. Thank you so much for taking the time to respond sir, it is much appreciated.
Very Awesome! Thank you very much for the article, and wish you a happy new year.
@IAmTimCorey
4 жыл бұрын
You are welcome.
This is the most valuable content I had found during my searching journey. من أفضل الفيديوهات التعليمية في هذا الفرع
@IAmTimCorey
Жыл бұрын
I am glad it was so helpful.
Great demo today. Just what I needed. Been trying to find a good blazor server side demo that wasn't completely EF centric.
@IAmTimCorey
4 жыл бұрын
I am glad you found it valuable.
Following along with this video taught me a lot! It took me quite a while as I had to figure out how to do everything from Visual Studio Code on Linux, but in the end it worked perfectly. I ended up using a postgres docker container instead of sqlserver, but the other things work just as well if not quicker in vscode with the terminal.
@IAmTimCorey
4 жыл бұрын
Great!
Great work again Tim. Excellent tutorial. Now looking to start a Blazor project.
@IAmTimCorey
4 жыл бұрын
Thank you! Best wishes on your project.
Thanks Tim, great as always. For anyone who is interested, I did a Blazor / Dapper playlist. I won't post the URL because last time I did this message didn't show. But if you search Google for Blazor Dapper CRUD you should find it under Alan Simpson. Not saying it's as good as what Tim does, he's my mentor too. But it may be worth a peek if you're interested in Dapper.
@IAmTimCorey
4 жыл бұрын
Thanks for sharing.
Really sir, very good structural info you describe in this video :)
@IAmTimCorey
4 жыл бұрын
Thank you!
Hi Tim. Absolutely fantastic course, especially the details and the steps that you follow are great.
@IAmTimCorey
5 ай бұрын
Thank you!
Thank you so much for this video, I was stuck so badly and it just resolved my problem. It might have been risky for my job. It really helped me. thank you from bottom of my heart. Love from India.
@IAmTimCorey
2 жыл бұрын
Awesome! I’m glad it was helpful.
Great breakdown of Blazor's structure ! Thanks
@IAmTimCorey
4 жыл бұрын
You are welcome.
My first blazor video. Wonderful, thanks a lot.
@IAmTimCorey
4 жыл бұрын
You're very welcome!
Great, as usual, Tim. Finally I know Blazor. Thanks!
@IAmTimCorey
4 жыл бұрын
My pleasure!
It's a ton of information wrapped in a 1-hour video, but I have learned a lot. Need to watch it again and code along to really learn.
@IAmTimCorey
3 жыл бұрын
Glad it was helpful!
A great new year gift to us. Thanks million !
@IAmTimCorey
4 жыл бұрын
You are welcome.
Super tutorial, Tim! Very easy and I'm a fan of yours now 😊😊
@IAmTimCorey
3 жыл бұрын
Happy to hear that!
Very nice indeed! Refused to watch any other tutorial on Blazor unless it was you or Kudenvat (you are first). Thanks Tim!
@IAmTimCorey
4 жыл бұрын
You are welcome.
Great tutorial video. one of the best tutorials I've watched...it is so easy to understand.
@IAmTimCorey
4 жыл бұрын
I am glad you found it useful.
The potential of Blazor (server side and client side) in dot net Core, is the main reason I decided to return to Microsoft after many years. This is an excellent lesson, thank you sir!
@IAmTimCorey
4 жыл бұрын
Awesome!
Great tutorial Tim. Thanks a lot. That was my first Blazor tutorial and there will be a lot more before I will be able to upgrade my Winform ERP system to Blazor but it gives me a lot of ideas.
@IAmTimCorey
Жыл бұрын
You are welcome.
Blazor gets me seriously excited at the possibilities for us .NET developers. Thanks for the great introduction and I look forward to future videos exploring Blazor. P.S. that Razor confusion is almost too hard to believe... You couldn't make that up. 😂
@IAmTimCorey
4 жыл бұрын
Yeah, it really is exciting.
Please do more Blazor videos! The two you have done so far is great.....but i want more :-)
@IAmTimCorey
4 жыл бұрын
They are coming, including a start to finish course that uses them.
Tim you gave me a great idea for my reporting project by using Blazor
@IAmTimCorey
4 жыл бұрын
Awesome!
Very thankful for these videos!
@IAmTimCorey
4 жыл бұрын
I am glad they are helpful.
This is excellent! Thank you Tim!
@IAmTimCorey
3 жыл бұрын
You're very welcome!
Your tutorials are actually amazing, you explain everything so in-depth. Subbed :)
@IAmTimCorey
4 жыл бұрын
Thank you!
Excelente. Mi inglés es muy malo, pero la tonalidad, claridad y simplicidad del lenguaje usado, hacen que logre entender todo. Y el contenido insuperable. Felicitaciones
@IAmTimCorey
2 жыл бұрын
Awesome! I am glad my content is clear and helpful.
You are as good as they come! Thank you for what you do.
@IAmTimCorey
2 жыл бұрын
You are welcome.
You have great teaching skills! Thank you!
@IAmTimCorey
3 жыл бұрын
You're very welcome!
I love this tutorial. Thank you for that. I just noticed Blazor Server in some of your other videos and I really liked it instead of MVC
@IAmTimCorey
3 жыл бұрын
Glad I could help!
@S3Kglitches
3 жыл бұрын
@@IAmTimCorey maybe you could do a short video of Blazor Server vs WebForms comparison? I noticed that WebForms is somehow similar
This is an awesome introduction to Blazor. Thank you for the pet talk at the end. This is really a game-changer for me because I'm better at C# than JavaScript. My pet peeve is that MS name the extension .razor. Why not blazor to avoid confusion?
@IAmTimCorey
4 жыл бұрын
I think they reused items but I agree.
Great tutorial !!! Thanks for uploading this video. Thank You
@IAmTimCorey
3 жыл бұрын
You are welcome!
Love it, so simple. The course paid off.
@tomthelestaff-iamtimcorey7597
3 жыл бұрын
Thanks for watching!
A great tutorial to get started with Blazor. I am new to this and I got interested into learning Blazor rather than other web stack, the reason being, I have experience of C# and I want to build on top of my foundation rather than building a new foundation somewhere else.
@IAmTimCorey
11 ай бұрын
That's a good plan.
Thank you so much! Awesome tutorial!
@IAmTimCorey
2 жыл бұрын
You are welcome.
great video, I got little lost with the nitty gritty details toward the end, but it covered so much goodness. I watched the whole thing in one go. I can't even do that with TVs that I like.
@IAmTimCorey
2 жыл бұрын
I'm glad you liked it.
Thanks, Tim, for amazing tutorials. I am waiting for a video about blazor globalization(localization) in client and server-side included data annotations. I hope you will do it.
@IAmTimCorey
4 жыл бұрын
I will add it to the list. Thanks for the suggestion.
@DLVideo94
4 жыл бұрын
@@IAmTimCorey I will love that too. A video about blazor globalization(localization)
Have only just loaded the video so this may be mentioned at some point, but there isn't enough Blazor stuff out there right now, so thanks. Hope there are more to come from you.
@IAmTimCorey
4 жыл бұрын
There is, including a whole course.
@pingu2k4
4 жыл бұрын
@@IAmTimCorey Hey :) Thats awesome. Is there an ETA on the course? Looking at doing stuff right away, and have done some of the basic stuff already out there and have a handle on sections of stuff already, but looking to get more advanced, and also get more rounded with my knowledge. :)
Thank you so much! I've learned many things from you, sir Tim.
@tomthelestaff-iamtimcorey7597
2 жыл бұрын
Thanks for trusting Tim when you need training.
Great tutorial. Thanks, Tim
@IAmTimCorey
4 жыл бұрын
You are welcome.
You can separate code from page. Clean and clear tutorial tnx!
@IAmTimCorey
4 жыл бұрын
You are welcome.
Good starter tutorial. Thank you. I have a lot to learn. :)
@IAmTimCorey
8 ай бұрын
You are welcome.
Long time developer tying to catch up and move ahead after some years of disability, this is great.
@IAmTimCorey
3 жыл бұрын
Thank you
Simply amazing as usual.
@IAmTimCorey
4 жыл бұрын
Thank you!
Awesome, loved it & subbed!
@IAmTimCorey
4 жыл бұрын
Excellent!
best channel ever thank you sir
@IAmTimCorey
4 жыл бұрын
You are welcome.
As always another fine tutorial you can actually follow manually, (ok, maybe for the actual database itself not, but that was easily created through VS).
@tomthelestaff-iamtimcorey7597
3 жыл бұрын
Thanks for building your skills with Tim
Wonderful. Very helpful. Thank you.
@IAmTimCorey
2 жыл бұрын
You are welcome.
Thanks, Pure Gold!
@IAmTimCorey
4 жыл бұрын
You are welcome.
Great video. Helped to introduce me more to Blazor and to help reinforce some SQL Server info from your fundamentals course. Could not get the source code downloaded. Was able to, on the fly, create a quick sql db for use with it. Did it without too much "peaking". lol
@IAmTimCorey
4 жыл бұрын
If you can't get the source code, you can always email me at tim@iamtimcorey.com and I can send it to you.
@mikey803
4 жыл бұрын
I'm sorry. The source code worked fine. it was the sql server part that was not working right. Sql server is a new way of thinking for me. The last database manager I used was dBase 3, which sadly shows my age. lol
0:00 - Intro 1:22 - Creating new Blazor Server App 4:46 - Balzor Server App overview 11:08 - Counter page explained 18:15 - Counter Page Network traffic 25:00 - Fetch Data page explained 32:24 - Data Access 32:55 - Data Access: Standard Class Library with Dapper 46:59 - Data Access: Blazor App configuration and database connection string 49:02 - Data Access: New Razor Component page and display Data from database 59:30 - Data Access: Save data with data validation 1:03:52 - Data Access: Blazor UI from 1:08:25 - Data Access: Save data from form 1:13:36 - Summary and concluding remarks
@IAmTimCorey
3 жыл бұрын
Thank you kind sir!
@tmhchacham
Жыл бұрын
@@IAmTimCorey typo: Balzor
Great content tim
@IAmTimCorey
3 жыл бұрын
Thanks!
Great intro to Blazor.
@IAmTimCorey
4 жыл бұрын
Thank you!
I just loved it. A very good video to start and kept me really engaged for the whole session. Would like to have some info on how did you pass parameters in your SQL if you have to.
@IAmTimCorey
2 жыл бұрын
I did that in the video. For instance, the spUser_Get query takes in an Id. When I created the C# code to call that stored procedure, we passed in an anonymous object with the Id. That's all you have to do to pass data in through a parameter.
@mohdsaleemnavalur8873
2 жыл бұрын
@@IAmTimCorey Hey, I did not find this "spUser_Get" in the code. I even checked from your source code. What am I missing?
Thank you for brilliant tutorials. English is not my native, but i understand you explanations like it is)
@IAmTimCorey
Жыл бұрын
Glad to hear that!
Thank you Tim for the very, very helpful video. There is no such good tutorial in the Russian c# youtube community for me.
@IAmTimCorey
4 жыл бұрын
I am glad this was helpful.
Great video - thank you!
@tomthelestaff-iamtimcorey7597
3 жыл бұрын
Thank you for watching and supporting Tim
Thanks for the tutorial!
@IAmTimCorey
4 жыл бұрын
You are welcome.
Great video! Thanks!
@IAmTimCorey
Жыл бұрын
You are welcome.
Very helpful and valuable as always. As Blazor is using signalr, it would be great if you can explain how to do realtime notifications. Say you receive a notification when a customer makes a new order, or a manager receives a notification that he has a pending job according to a certain workflow.
@IAmTimCorey
4 жыл бұрын
I will add it to the list. Thanks for the suggestion.
Hello Tim, I have tried to follow you on this video, and it is quite amazing. I would love to take one of your courses. You may have probably written many books, however, I think you should write a book on the server side technology. Meanwhile, I plan to take one of your courses. I will definitely check your link. Thanks for your lessons. You are definitely going to make this world a better place by your lessons.
@IAmTimCorey
3 жыл бұрын
Thanks for the suggestion.
Great tutorial. Thank you so much.
@IAmTimCorey
3 жыл бұрын
You are most welcome. Thanks for watching.
One of the reasons i always shied away from .NET and C# is how hard it was to find good resources on it especially if you compare it to React for example. This is the first channel i come across that is actually making me feel excited about .NET
@IAmTimCorey
4 жыл бұрын
Awesome! I'm glad.
Cory, you just got me interested in web development with c#. Learning angular n react felt like a pain but this is cool
@IAmTimCorey
3 жыл бұрын
Awesome!
Thank you so much Tim.
@IAmTimCorey
4 жыл бұрын
You are welcome.
Awesome video as always - I was going to dive into react but after watching this I am going to stick with Blazor based on the comments at the very end about spreading your brain too thin (paraphrase). I do embedded and also lots of data science stuff so am already packed pretty full. Thank you sir, for the video.
@IAmTimCorey
Жыл бұрын
You are welcome.
Thanks for the class
@IAmTimCorey
3 жыл бұрын
You are welcome.
Great tutorial, Thanks a lot
@IAmTimCorey
Жыл бұрын
You are welcome!
Very nice video. Thank you!
@IAmTimCorey
3 жыл бұрын
You are welcome.