EF Core 7 🚀 Multiple Databases, DbContexts & Relationships (Entity Framework 7)

[@davidarayacadiz7675]

I'm from Chile, I found your channel about 3 days ago and currently, I'm developing a .NET 7 web API for college and your videos were so helpful! Thank you so much.

[@PatrickGod]

Thanks a lot for your feedback, David! Really glad I could help! 😊

[@mtranchi]

5:58 You can specify the output directories with a "-o" parameter. It doesn't even have to be in the Migrations folder.

[@PatrickGod]

Hey there! You're absolutely right. Thanks for pointing that out. 😊

[@The-Z-Zone]

Great tutorial. Most EF examples that I have seen have always been a 1:1 between app and database so this was nice to see in operation.

[@cyrmee]

I was searching for this topic in the past few months. Thanks!

[@PatrickGod]

Welcome! Glad I could help! 😊

[@JtendraShahani]

I was searching for a video on this topic. Thank you so much.

[@PatrickGod]

Glad I could help! 😊

[@mehretabhailegebriel]

@@PatrickGod Can you show us how we can manage JWT, like revoking and refreshing, in a web API app?

[@clyntneikorupinta5760]

Thanks a lot always for the video!. It would be great if you can make a topic about ef core with multithreading

[@raggardy]

Cheers Patrick! Great job

[@PatrickGod]

Thank you so much, Darren! 😀

[@jeanmas4197]

You can specify the folder where the migration goes. I find that handy to keep everything well organized

[@joaogabrielv.m328]

Thanks a lot for the video, God. Keep up

[@user-um4sp8gf4p]

Patrick good tutorial you can make the relation between the user table and character table in view model table rather the in the actual user model

[@TheYassha]

Thanks that was really helpful.

[@alexmadnix]

Thanks God!!

[@PatrickGod]

You're welcome! 😊

[@abhinavsrivastava2128]

nice video... For anyone thinking about writes to multiple dbs - Saga

[@nderrickharris]

It would be great if your next topic would be 2 DBContexts (Config, AppData) where the connection string for the second one(AppData) is stored in the first Database(Config). For a sharded multi-tenant example.

[@zoiobnu]

I never see a good multi-tenant tutorial for free

[@asdasdaa7063]

Is this still the case in .net 8? meaning you have to do it manually?

[@releyshic]

What for we will need few contexts?

[@10Totti]

Migrations is possible now also with Visual Studio UI.

[@broadshare]

It would be better showing multi-tenancy application where users/customers have each their own dbcontext using same app. Think of something like quickbooks. It's not realistic to have diff dbs in this case videos games

[@axelbryancasauran5159]

can we use this for switching of database? for example --user1 registered in DB1, user2 registered in DB2 --when they login they will be connecting automatically in their registered DB.. is it possible here?

[@hero1v1]

How to add a Generic Repository pattern on top of this?

[@SrabanNadimulIslamBhuyan]

is it possible to use multiple dbcontext in entity framework core that can share some tables such as Tenant, User, etc. in both context, but want to create table only from first context's migration, btw: I have one database, and I want to use different scheema. such as shared.tableName, sales.tableName, etc. actually I want to make moduler monolith application.

[@user-gq8hg7xt1s]

Hey there! Thank you for the video! Is it worth creating multiple DbContexts at all, and is it worth separating IdentityDbContext into a separate database? Does anyone actually do this in real projects?

[@pablotruffa588]

Yes, it is worth because authentication and authorization are abstracted from business logic. But in this case scenario i would create a "UserTableInfo" in the characters dbcontext. Imagine if you want to get all the characters and their users, in this example you ll have to foreach loop all characters asking for theirs users. Multiple database queries. So whenever a user gets registered in one database you can add some userinfo in the characters userinfo table (other database), such as name,email, etc no sensitive info like passwords, etc so you can map faster with a simple Join

[@luisfernandodeolazabalsche3317]

😃😃😃😃😃