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

➡️ Use code START2024 for 10% off!

Udemy Courses:

Table of Contents:
00:00:00 .NET 7 Web API & Entity Framework 7/EF7 🚀 Full Course
00:00:29 Create a Web API Project
00:03:22 Solution Overview
00:13:43 Start Building a Web API - Add a new Model
00:15:20 Add the Controller
00:17:16 Write the GET method
00:20:45 Test the GET Method with Swagger
00:22:57 GET a Single Hero
00:27:42 Add a Hero with POST
00:32:25 Update a Character with PUT
00:38:15 DELETE a Hero
00:40:12 Use the Repository Pattern by creating a Service
00:47:48 Make use of Dependency Injection
00:48:39 Refactor all CRUD Operations (using the Service)
00:57:16 Test all CRUD Operations after adding the SuperHeroService
00:58:34 Add Entity Framework 7
00:59:11 Install EF Tools & NuGet Packages
01:01:41 Install SQL Server Express & SQL Server Management Studio
01:02:57 Implement the DataContext/DbContext
01:06:17 Add the ConnectionString
01:07:28 Add the DbSet
01:08:43 Register the DataContext
01:09:25 Run Code-First Migrations
01:12:01 Check the Migrations in SQL Server Management Studio
01:12:30 Add a Hero in the Database manually
01:12:46 Use Entity Framework in the SuperHeroService
01:20:03 Final Tests & Fixes

🙏MANY THANKS TO THESE LOVELY PEOPLE:
Nathan Waterman
Rakesh Bridgraj
Joaquim
Ralf Kürbitz
@jacoviza
Thomas McMeekin
Ameet Jayawant
JesperNielsen
Paul
@Alaffer
Alvin Majid
Slava Ukrayini
Piotr Franczak
Jan Trichter
Tom
H. Ali
Ashley Gahl
Daniel Viveros
Mehmet Ali Ege
Winther
harry j
@Alaffer
Sam Catlow
Jim
Brian Williams
Gonzo
Jonas
Ariel Sartor
Andy Benson
@stevelikespies
Raphael Lukas
James Goforth
@williamdevine
Doug Nelson
Arif Hasanov
@kohji1712
@dlb78dlb
Thomas Korsgaard
FastTrak
Jeff Sager
Dan Moyer
AlgoMarket
Mennskr
Simon
Michael Mel
Hermann Rösch
Jim McNeal
Kieron
@mgrainger231
Gerrit Esmeijer
Axel
Kareem Skinner
Joaquim
Alain Legrand
Per Rieland
@prodrigu75
Greg
Brendan Maunder
Stageoner
Andrew Campbell
pascalditzfeld
PovilasSimanskas
jenö
Marco Otilli
Mark
l33ter
alibux
Luke Vincent
mrcl
Alain Legrand
Thomas Werner
István Csibor
Grant Burdon
@gianluigiconti
Gerrit Esmeijer
Illia
Németh-Pók István
Michael Mel
Marko Zdilar
GerryB
@DADA_universe
Domen Hren
@heroesch
Carey
Peter De Tender
Baris Keskin
@Big_Bear_27390
Mathias
walter e watkins
Günther Dassel
Axel
Josh
Daniel Huber
Fredric Adell
Juan Carlos
Manolis
Pajani
P.
Jonas Granlund
Bobby
Kristina
@xamarin007

#DotNet #NET7 #PatrickGod

[VitaliChuzha]

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

[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.

[huywarrior]

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

[eddyelamin]

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

[anze]

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!

[bttekeb]

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!

[RSWDev]

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.

[mallninja]

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.

[imsdkl]

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

[kfbflov]

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!!

[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!

[kbolton]

Brilliant, Simply Brilliant, Very much appreciated !!!

[mariomelendezpichoneau]

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' 😇🙏

[sarikakalokhe]

Wow such simple and great explaination kudos

[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!

[rahmanchaudhary]

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

[derekkc]

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

[kiransai]

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

[jairocontreras]

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.