.NET 6 🚀 EF Core & SQLite with Code First Migrations

preview_player
Показать описание
---

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
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
Рекомендации по теме
Комментарии
Автор

You truly saved me from countless hours of wasted time!! Thank you, man!:)

uplnk.vd
Автор

Vielen Dank für das Video :-) und erhol dich gut :-)

raphaellukas
Автор

The sound is pretty good. I have no issues with the quality!

robdevoer
Автор

YES! That comes pretty close to what I asked for! Thank you for this helpful video :)

byte
Автор

My goodness Patrick! Your place looks so cool! I like your style my dude!👍

angelotolentino
Автор

It's not every day you get a meaningful lesson in how to code from God.

jonaskromwell
Автор

This is what I needed. Also I want a DB first approach. Thanks a lot.

chizuru
Автор

Thank you. It was useful and nice work.

MehmetAliEGE
Автор

Insane explanation!! Thanks a lot, from Brazil!

Palmutip
Автор

Thank you man, fantastic stuff and very helpful.

alextiger
Автор

thx so much i was a little lost trying to do an implementation like this, im so newbie xd

Danielspss
Автор

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.

Nashmar
Автор

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.

tommcmeekin
Автор

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.

musaabaz
Автор

You are awesome brother. Last week I bought course on Udemy from you and cant wait to start it. Keep on going! 😃

TroloveCro
Автор

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

AbdulAziz-xilo
Автор

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?

iosaroj
Автор

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?

jephrennaicker
Автор

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?

gabor
Автор

Patrick how can i add a stored procedure in entity framework web api with sql server

angelcasanchez