Adding Multiple DB Contexts in your DotNet Project
Introduction In this article we will discuss adding multiple DB contexts to our DotNet projects, we will use EF core as our ORM to make a "Code First Database" approach. In this article example, we will use DotNet 7 connecting to SQL Server through EF Core 7, all of this will be in a web API project to see how to define those DB contexts as services in program.cs file. You can download the example source code from here . Why would we need multiple DB Contexts in our Solution? There are two situations where you need multiple DB Context in your project or Solution: We have a single database but need multiple schemas in our database, and each scheme will have a group of entities. We have Multiple databases and our project needs to connect them to do its operations. We will take the first situation as our code example. Creating Our models Let's assume we have a simple solution that manages the cust