.NET 6 🚀 EF Core & SQLite with Code First Migrations
HTML-код
- Опубликовано: 27 июл 2024
- 🚀 .NET Jumpstart Course: www.udemy.com/course/net-core...
📧 Newsletter: newsletter.patrickgod.com/
❤️ Ko-fi: ko-fi.com/patrickgod
☕ Coffee: www.buymeacoffee.com/patrickgod
💻 GitHub: github.com/patrickgod/EF6SQLi...
🐦 Twitter: / _patrickgod
📓 Articles: / patrickgod
🎥 Skillshare: www.skillshare.com/r/user/pat...
🔥 Blazor E-Commerce Course: www.udemy.com/course/blazor-e...
🔥 Blazor Bootcamp: www.udemy.com/course/blazor-w...
💡 Online Course Lab: www.kristinagod.com/online-co...
Table of Contents:
00:00 .NET 6 🚀 EF Core & SQLite with Code First Migrations
01:59 Create a new Web API Project
02:55 Install Entity Framework Core Tools & NuGet Packages
07:19 Add the Connection String for SQLite
08:28 Create a New Entity
09:57 Implement the DataContext
12:52 Register the DataContext
14:15 Utilize Code First Migrations
16:24 Fixing the Connection String
17:48 Use the DB Browser for SQLite
18:45 Add a Controller with GET & POST Methods
24:10 Test Everything
🙏MANY THANKS TO THESE LOVELY PEOPLE:
@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
g.dassel
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 #EfCore #PatrickGod
YES! That comes pretty close to what I asked for! Thank you for this helpful video :)
Insane explanation!! Thanks a lot, from Brazil!
My goodness Patrick! Your place looks so cool! I like your style my dude!👍
Thank you. It was useful and nice work.
This is what I needed. Also I want a DB first approach. Thanks a lot.
Vielen Dank für das Video :-) und erhol dich gut :-)
Vielen Dank! Die Erholung lässt noch etwas auf sich warten... 😅
The sound is pretty good. I have no issues with the quality!
Thanks a lot for your feedback! I tried to fix it in post-production. Still got lots of echo in the room, but it will get better. 😊
Thank you man, fantastic stuff and very helpful.
Glad I could help! 😊
Çok müthiş insansın Patrick
Very nice toturial
thx so much i was a little lost trying to do an implementation like this, im so newbie xd
Obrigado mano
Good tutorial
You are awesome brother. Last week I bought course on Udemy from you and cant wait to start it. Keep on going! 😃
Awesome! Thank you so much!
Hey in 10:35 you are creating a new DataContext. When you are declaring DbContext inheritance, Visual Studio suggests you with it. And when you pick DbContext, it adds using reference to EF Core as well. Is this feature somehow possible to set in Visual Studio ? Because when I am using Visual Studio myself and declaring something that has no reference in current class I am not getting any inteli sense suggestion as you did.
How do I get the NuGet package manager console for Visual Studio Mac 2022?
I'm not able to use any Entity framwork tools to generate the database for my app.
It's not every day you get a meaningful lesson in how to code from God.
But what ist the way when my Programm is done and i want to give someone the .exe file. how does the Migration work there?
Is is correct to put the db file in the root folder?If I am deploying this to azure, will the db file not get overwritten on subsequent deployments? How to avoid this?
Awesome as always Patrick. 😀 Do you have a road map we can see? I would love to know what you are working on so that I could save my cash and buy any future courses from you.
Hey Tom, Thanks for reaching out. Well, I am working on a bigger .NET Web Development Bootcamp where we go deep into the backend and frontend of a .NET Web Application, together with some Git and DevOps stuff. If you want to be the first to know when this course is available, I suggest you subscribe to my newsletter. 😉 Take care, Patrick
@@PatrickGod I am already Patrick. If it includes azure/SQLdb/api then that sounds exactly what I'm looking for now. Would love it to include containers but I may be looking for too much. 😉
I made web api same as you did both EF And dapper are working fine with blazor web but 404 for blazor MAUI windows and android as well kindly use sql server instead of sqlite
Can you make a video about httpcontext pleasee
Great Stuff! ,I have a silly question can we not call GetAllCharacters() in the return of the AddCharacter() Method if so How can i do so? also the update and delete method anyone?
Patrick how can i add a stored procedure in entity framework web api with sql server
There you go: ruclips.net/video/nHv9jCPtwT0/видео.html
@@PatrickGod Thank you very much patick you have served me as a source of motivation to continue learning to program. You're the best
Thank you very much... I learned a lot from you.
Could you please create a tutorial for .NET 6 EF Core with GraphQL??
Machst du auch deutsche Videos mal?
Eher nicht. Aber danke für deine Frage. 😊
Why all your projects are "Web" !!
What about winform or wpf ?!
Assume You're try to explain "ef core"
I think the best project to explain most of the technologies is Console app
So we can focus on the implementation of er core instead of the headache of web technology
Thanks for your feedback! Let me think about that! 😊