Create an EF Core Model from Database First (Scaffold DB Context)

How do you create an Entity Framework model from an existing SQL database (database first?) In this video I’ll show you how to use the Scaffold DB Context tool available with EF Core to do just that and save tonnes of time.
☕️ Support us with a coffee! (Or.. beer 🍺)
www.buymeacoff...
📧 📫 Join us on our developer journey! Sign up to our email newsletter:
robertsdevtalk...
🐦 Follow us on Twitter:
/ robertsdevtalk
🎶 Music by Epidemic Sound:
www.epidemicso...
Icons in this video kindly provided by FlatIcon from Freepik
www.freepik.com
www.flaticon.com
Disclaimer - some of our links are affiliate links, which means that we receive a small commission for any sales made via those links, at no extra cost to you - so a great way to support our channel! Thank you so much for your support 😊

[@duyoanuc5966]

Perfect. This is what I have been looking for. Thank you for saving us !

[@АнтонКоншин-й7э]

I'm leaving a like under this video not because it's relevant to me, but because the author saved my valuable time with an introduction to the topic of the video. Thank you so much.

[@ravs234]

Absolutely precise and very simply explained. Thank you :)

[@RDT]

So kind of you 🙏

[@hosseinrostami7708]

Complete and right to the point. Works like a charm. thanks.

[@RDT]

Glad to hear it helped 😎

[@chairmakerPete]

Really helpful - thank you!

[@berthold9582]

Très facile
Merci sir

[@thangamanieraniyan4923]

Thankyou, this is exactly what i am looking for. scaffold... is it is... :)

[@meowaves]

It works. Just make sure you open the Nuget Package Manager console and not the Developer Powershell which got me into limbo.

[@meowaves]

Also, if you are working with multiple repository and would want to move the models to specific project then you add -Project "YourProjectName" command as below :
Scaffold-DbContext -Connection "ConnectionStrings" -Provider Microsoft.EntityFrameworkCore.SqlServer -Project "YourProjectName" -OutputDir Models -Context ProjectDbContext

[@vallmi4370]

Thx a lot!

[@RDT]

Welcome!

[@EnriqueMartinezInter]

Glad to see you back!

[@RDT]

Thanks Enrique! Hope to get back into it this year… thanks for sticking with us 😎

[@simonroyjonesuk]

Absolutely perfect. Exactly what I wanted. Thanks

[@RDT]

Glad it helped 🙂

[@NickFletcher-gb9ne]

Thanks very much, that was a great help.

[@RDT]

Glad it helped

[@yasincnar166]

Thanks a lot

[@RDT]

Happy to help

[@rogeriolima8152]

Nice video, thanks. A real world project idea using EF with tricks
would be nice. I am learning how to use it. DB First... Code First probably I will never use.

[@ibrarhussain1425]

Works like a charm. thanks!

[@abhishekrandhir3922]

Helpful for me. Thank you

[@abugsbunny]

Thanks for tutorial. From Latvia

[@cogivuioay9283]

Thanks Roberts

[@RDT]

You are very welcone

[@viniciusvilela6695]

Thank you so much for this content, very clear and usefull

[@RDT]

Glad it was helpful 🙏

[@albertokalman1991]

Good, thanks

[@RDT]

Thank you too!

[@l.piekha100]

this is way more effective than using fluent API in my experience, less bugs and better consistency.

[@berthold9582]

Sir, do you have a video on transactions in C#?

[@eleojoadegbe]

Thank you

[@bojdeep]

Nice, How to update the model classes if there is any changes in Database column changes

[@TiOnGY]

After we got the model we can use it to migrate the tables to another table?

[@yasirirfan5262]

thank you.

[@komrondeveloper]

Thanks

[@KevinMullarkey]

What if you only want to build from certain tables and not ALL tables & views?

[@dev2devops]

After doing scaffolding from the existing database if we make further changes in database objects then how we can update models again?

[@spencersedano]

I have the same question, did you get the answer?

[@jesusospino7897]

I am using Docker to have the SQL Server, when I run the command line to generate lps models with scafffold this gives me errors with the user or sometimes with the certificate

[@godfather7695]

Thnks!!👍👍

[@sherlockholmes1121]

Nice !

[@RDT]

Thanks!

[@soyponchoc]

I have a question, how can I do to map the stored procedures as the previous version of EF

[@tobiogunsanya9142]

Nice. Did you create the CompanyDbContext before running the command?

[@RDT]

No, it is all created by the command. Basically a blank project to start with.

[@Theo-sf8qn]

FLACO VOS SOS EL SOL

[@robertocarlosgalicialopez3011]

donde están los scripts para solo copiar y modificar ?

[@Kennerdoll]

im getting "Build Failed'

[@_its_ak_3839]

did you solved that issue ? if so please explain am facing the same issue

[@Kennerdoll]

@@_its_ak_3839 no i didnt and i stoped from there

[@puletshehla4305]

I'm facing timeout issues

[@jingsun7604]

Same here. Did you find a solution for the timeout issues?

[@sashamaksyutenko7169]

hi. How can I use it on Mac?

[@berthold9582]

Très facile
Merci sir

[@ruslanzorkin784]

Thanks a lot!

[@RDT]

Welcome!