.NET 7 Web API & Entity Framework 🚀 Full Course (CRUD, Repository Pattern, DI, SQL Server & more)

[@VitaliChuzha]

One of the best videos I have seen on this topic. Simple, sequential presentation, clear from top to bottom. Thank you very much!

[@PatrickGod]

Thank you so much for your kind words! Means a lot to me. I'm really glad I could help.😊

[@piipaatirullaa]

Greetings from Finland. I shifted over from development to sales over 10 years ago and started to try out coding again , just for fun. The starting up again is a pain as nothing in the code makes sense. I found your tutorial super beneficial and clear. Thanks for this.

[@rdwok14]

I'm only 15 minutes into this video but i really, really like your style. I've done a few other tutorials and from what I've seen people either blow through things without explaining or they explain too main minor details without touching on the bigger picture of why things are done a certain way. I can say your tutorial is one of the best I've come across.

[@PatrickGod]

Awesome! I really appreciate that. Thank you so much!

[@rdwok14]

@@PatrickGod I finally got through the whole video and I have to say, you have taught this tutorial in a way such that one can watch the video and listen to your explanation, then go and recreate the app on their own without having to look at your code. Your process follows an understandable logic starting with building the model, testing a mock controller with a simple in-memory data structure, refactoring into a service with repository pattern, and then refactoring the interface implementation to use a SQL database which really demonstrates the repository pattern. Each refactor teaches a very fundamental pattern to .NET/OO web frameworks that I feel that I can recreate this in Java/Spring too. I've struggled with other tutorials because they just show the final step in code without building up each step and most jump right into interfaces everywhere and an EF migration before we even mock up an API. Very well done, you are the God of teaching .NET.

[@huywarrior]

The exercises are easy to understand from high to low and from overview to detail. Thanks for making it simple!

[@НазарійОлеговичФедун]

Goddamn!! There are all topics that I couldn't fully understand. Because of you, I've finally understood everything down to the smallest detail. Thank you so much!

[@PatrickGod]

Glad I could help! 😊

[@eddyelamin9015]

Thank you for such a great video! I have struggled to find a tutorial on Web API but thankfully i stumbled on your video.

[@PatrickGod]

Glad it was helpful!

[@mallninja12]

Dude you're awesome. I'm a DBA and I've been assigned with creating a web app using C#/NET, and months ago I found your channel.... through these API walkthroughs and other suggestions like MudBlazor/Blazor I've been able to make a pretty legit, fully functioning, low code and maintanable app despite not being a programmer that I'm proud of. Thanks for the videos. Recently did a year of skillshare and ill be checking you out there as well.

[@PatrickGod]

That's amazing! Thank you so much for sharing this with us. 😊 All the best!

[@RichardBerry-o5s]

This was Excellent - Thank you!! Followed along and an my API works perfectly. Your explantions are clear, flow makes pefect sense. Even the little mistakes here and there added value for me. Perhaps a touch on SQL Server DataTypes (tables ended up nvarchar(max) for the string fields, and what to do in case of a table with millions of rows where you perhaps return a subset of the rows and fields. But yeah, all in all a GREAT video!!

[@PatrickGod]

Wow, Richard, thank you for the fantastic feedback! I'm thrilled to hear that the tutorial worked well for you and that you found value even in the little mistakes-those are often the best learning moments! Your suggestion about diving deeper into SQL Server DataTypes and optimizing for larger data sets is an excellent one. Handling data efficiently is a crucial aspect of back-end development, especially as applications scale. I'll definitely consider creating a video to cover these topics in more detail. Again, thank you for your support and thoughtful comment. If you have more questions or topics you'd like to see covered, feel free to let me know. Happy coding! 🎉👨‍💻

[@mariomelendezpichoneau785]

Hello, greetings from the Dominican Republic. I have been following you for a month or so and I have been watching your videos and I have liked them and they have helped a lot, excellent explanation, 'many blessings' 😇🙏

[@PatrickGod]

Wow, thank you so much!

[@marciliojrr]

Amazing video! Thanks a lot for that. While you did with SuperHero model, I made with User model and works perfectly. Now, I'm trying creating another models and make the relationships. One more time, thanks for this tutorial!

[@PatrickGod]

Glad it helped! Thanks a lot for your feedback!

[@sergkapitan2578]

Thanks a lot! Can you one day explain for beginners what is what in more details...:)? And what is going on beside the curtain of ,NET and C# together:)

[@PatrickGod]

🚀 Join the .NET Web Academy with a 20% discount - closing soon! 🚀 www.dotnetwebacademy.com/bundles/net-web-academy?coupon=dnwa2024yt

[@felixpatric4056]

Hello Patric. Thanks for another wonderful informative piece. I would like to ask, what makes your content different from the rest on youtube? Many have produced web api with crud using entity framework and they just stop from there, they don't elaborate on what's next after building the API(how to consume them in an application such as mvc, razor pages, blazor and even dotnet maui or react), others come with DDD backed in and all stops at crud functionalities and from a beginners point of view we struggle to understand what API's are and their use case scenarios and why we should build them. If you're going to differentiate yourself from the rest of the pack (those who whetted our appetite on web api and left us with crud functionalities using swagger and or postman and stop from there), count me in.I bumped into your website when the enrollment period is closed.😥

[@binoymathew440]

@@felixpatric4056 Very good points here - how do we consume the api? We know for sure, this is not the way we are going to use web api in our work environment

[@kbolton1373]

Brilliant, Simply Brilliant, Very much appreciated !!!

[@PatrickGod]

Glad it helped! Thanks a lot for your feedback! 😊

[@derekkc7299]

I like the design of this version using service and interface to implement dependency injection.

[@abrahamrussom255]

50:00 "Why did you not tell me" 😅 ... I told you but you didn't listen. Very nice video good explanation

[@PatrickGod]

😂 Haha, nice. Thanks!

[@lecole_joy_code28]

Haha i put the video on stop to look for this comment , i knew that someone payed attention to that lol , amazing tutorial

[@anze2455]

Thank you for such a clear and simplistic tutorial to grasp some knowledge on the new 7 version. You gained a new subscriber :) Great guy!

[@PatrickGod]

Thank you so much! Really appreciate it. 😊

[@rahmanchaudhary5961]

Excellent work @Patrick God , please keep it up and there should be video of real life project example ( user registration, employee registration or a sales invoice ) from creating Table , Strored Procedures, Web Api and Angular

[@imsdkl]

Thanks bro! Learned a lot from this short tutorial video! )

[@kiransai7616]

Good work sir 👍 , on your next vlog please show us how to work on Dbfirst with Indentity and multi relational database

[@divyanair1911]

Great Explanation ,Thanks a lot for this Amazing tutorial !!

[@PatrickGod]

Glad it was helpful! Thanks a lot for your feedback!

[@levankakhidze8150]

You are the first Hero bro!

[@Quebster]

Thank you for the awesome vid! My only request to make things more clear for us new devs, is could you leave your solution explorer open on the side? I know ultimately I can see where you are based on the tab names, but the solution explorer is more clear. I also did not have all those crazy issues on the latest VS build at time of writing this comment (17.4.3). However I get stuff like that a lot when working on my MAUI projects. I do lots of clean/rebuilds and restarting VS to clear the crazy stuff.

[@softwaretestinglearninghub]

Great explanation, thank you Patrick!

[@PatrickGod]

My pleasure!😊

[@idekfai]

thank you for the updated tutorial!

[@PatrickGod]

My pleasure!

[@temmytory4309]

Hello, thank you for the tutorial. I was wondering if you are planning to do videos on different authentication methods with users accessing our API?

[@appu689]

Although video is very useful for beginners as well as for an experienced. If any video available where you have implemented same crud operation using automapper in different layers??

[@Jonatas_Arruda]

The reload is not a bug, you have the option o rebuild on save marked, thats why it keeps building

[@mahdiattar7830]

Hey Patrick! would you make a video on how to add data access layer to the project? Thanks

[@kwameedu-ansah4059]

Greetings! You surely have some of the best tutorials in the game! I wanted to know how I would alter the program to use Cosmos DB. I have tried it on my own but seem to run into many issues. Thanks

[@core_Info]

It was Amazing ❤

[@nitamto]

I've tried several online courses throughout my Web Developer career. Your videos are the best of used. EXCELLENT

[@PatrickGod]

Thank you so much! Means a lot! 😊

[@orlandoubilla7055]

Good Content, this save me, thanks!!

[@ahmo4781]

vielen lieben dank, deine videos sind spitze!

[@PatrickGod]

Das freut mich sehr! Danke dir vielmals für dein Feedback! 😊

[@alejandrogomeznieto]

I love batcam comics!

[@nakashilearn6048]

hi patrick thanks for all God bless you , plz how we can add two tables concurrent linked by foreign key with Web API

[@sarikakalokhe9410]

Wow such simple and great explaination kudos

[@Sunstriderko]

I am API and DI noob. Can someone explain what is the process of creating the SuperHeroController? So with every HttpRequest, new SuperHeroController is created and according to the type (Scoped,Transient, Singleton) of service, new or existing service object is provided to the controller?

[@jason-ph6zm]

have a quation, if you publish on iis, will the DB connet string still the same? cause in my situation, keep showing can't loging the SQL Server

[@mattlongname]

Excellent tutorial. Thank you!

[@patrickmugiraneza4627]

thanks a lot patrick

[@jayandrapatil]

Super duper video

[@faziolifairmont8125]

Can you please make a video about CORS?

[@R3s0n4te]

new List doesn't work, it says "The type ot namespace name 'SuperHero' could not be found (are you missing a directive or assembly reference?)

[@thieptrantrung]

Good😍. You can do about Identity to the ASP.NET Core Project?

[@10Totti]

Thanks!

[@PatrickGod]

Most welcome! 😊

[@binoymathew440]

Sorry can someone explain, why is await and async method used everywhere? Whats the benefit? Also what is the repository pattern? I dont see that explained

[@Gauravkumar-jm4ve]

thanks subscribed

[@andy_top6676]

I did not understand a little why it works correctly if you specified "AddScoped"? ... When I taught dependency injection, I read that when we do "AddScoped", new service objects are created with each request. And since we have our data created inside the class along with the creation of the object, shouldn't all our changes be reset ... I thought it would be, and did "AddSingleton". But it still works for you, I don't understand...

[@ouzhizus]

That's AWESOME!Thank you Also wanted to ask about your course on Udemy(.NET 7 Web API & Entity Framework Jumpstart),do I have to learn basics of Razor pages before watching it,or I'll be fine without Razor?

[@zangibarx]

Thanks for the video!👏🙏

[@PatrickGod]

You're welcome! 😊

[@jiahaokok-bl5jk]

im still using the fat controller design.... is that ok ?(well.. i will do the service and interface next time..)

[@jairocontreras8467]

Hola Patrick, mil y un millon de gracias!, tengo una pregunta:, Si quiero conectarme a mas de una base de datos que tienen la misma estructura, como lo haría?, teniendo en cuenta que el DbContext solo muestra la conexion a una base de datos.

[@stefanmostert704]

You are amazing!

[@PatrickGod]

Thank you very much! 😊

[@CheeseBae]

Are there any issues with using multiple awaits in the same method, such as them getting out of sync?

[@vikram5010]

What are the differences between Web API project using EF and Microservices project using EF? If I have code for the project, how can I find out if it is a Web API project or Microservices project?

[@uzmazubair4288]

Thank you so much, very helpful.

[@sarafotros4914]

Great tutorial, but can you consider Mac users for the database part?

[@alirezajeditehrani879]

Thanks! That was great!

[@Acesteef]

God is always there when i need him the most 🙏

[@therav2007]

please do a cutdown version of this which focuses on things that are different with .NET7

[@olexiy93]

Great course!

[@PatrickGod]

Thank you so much! 😊

[@houba1263]

hello thank you for your tutorial , i have a question how can i execute custom sql queris?

[@EzequielRegaldo]

So the service is instanciated everytime you get a request ? hmm is it something good ?

[@HussainAl-ahmdi]

thanks man

[@aikidoshi007]

Brilliant! Thanks muchly!

[@PatrickGod]

Thank you very much for your feedback! Glad it helped! 😊

[@mmokzlrsn]

what about dto models and doing reverse engineering instead of code first aproacH?

[@mahendranath2504]

Thank you so much for the amazing content video , subscribed and liked 👋👍👏🎉🫡🎊🙏🏻🥳🤝👌🫰🏻🤗😎

[@PatrickGod]

Thank you so much 👍

[@kwstaslalaounis3212]

You are Perfect thank you...

[@RealCoders_07]

Sir I will say one thing, I can't understand the example of SuperHero. was this the only example you had to show

[@mesanjyaa3616]

Love from India we are not getting your video in playlist can check on that❤️😍🥺

[@xxspiros]

thank you!

[@lleorox]

excelente

[@derhustlerderhustler2589]

After migration and update the database i cant edit the first 200 rows because the microsoft sql server management studio doesnt show anything but a white blank screen after click on button edit first 200 rows can you help me ?

[@johnsoto7112]

I had the same issue, you need to download the latest version

[@derhustlerderhustler2589]

@@johnsoto7112 can you Tell me what latest Version? The latest Version of SQL ?

[@Poeisible]

It seems not too much different with NET 6, right?

[@MathewsJosh]

Someone can help me? I am having this error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 25 - Connection string is not valid)"

[@swapnilchauhan3241]

If you're using remote Database, then it may be because of VPN. Ensure You're database doesn't require VPN for connection, or the VPN is enabled.

[@Gojam12]

I started the blazing shop app. I used that and every search term imaginable yet now it's nowhere to be found. Did you remove it. I was 30 minutes into it now I just cannot find

[@PatrickGod]

Hey James, here's the Blazing Shop Playlist: kzbin.info/www/bejne/f4XOY4CKe9Wcd5Y&ab_channel=PatrickGod

[@Gojam12]

@@PatrickGod thanks so much

[@azadansari2692]

how to store file in database?

[@bahibrahim101]

you rushed headfirst budd but still a decent walkthrough gj

[@mthithers]

Next Halloween I'm going as Batcam. 🙂

[@PatrickGod]

😂 Would love to see that costume!

[@MdImran-jz1mw]

Please provide github link for todays lecture

[@sandanuwan4441]

GitHub URL is not working to download codes. Could you please check again. Thanks !!!

[@PatrickGod]

Should work now! Thanks for reaching out!

[@sindersinder6457]

so why don't use autofac?

[@bosch5053]

GOD

[@lantisdylan]

Good day can u make tutorial for .net maui...

[@PatrickGod]

Noted! It's definitely on my list. Stay tuned! 😊

[@lantisdylan]

@@PatrickGod thank you sir ☺️

[@nghipham959]

I thought Dr.Strange erased everyone mind about Spider Man was Peter Parker

[@rba1aji216]

dotnet 7 is stable?

[@robrouwer]

Yes

[@ahmetkeskin2462]

21.50

[@alfonsoprofox]

All the CRUDs are with superheroes, isn't it time to change the subject?

[@PatrickGod]

What do you suggest? 😉

[@ToTheMoonParty]

seriously your last name is God? are you jesus?

[@clarkflavor]

[@vittoriomorellini1939]

The efcore7 does not work for scaffold, it works for connection maybe but scaffold does not work the 7.0.0 efcore

[@jogibear9988]

You should use 7.0.1 now cause of a Bug in Reflection, see my issue ##78218