DDD - Consistency of Entity Across Bounded Context & Different Schemas in Database

Entity Framework and Migration with multiple schemas in a single Context

I am developing a multi-tenant application with Entity Framework Code First. Each tenant will have a different schema in the database, but the application will have a single Context and model for all tenants. ...The Entity Framwork 6 is able to use multiple schemas with multiple contexts in the same database, but I didn’t find a way to use mult...

Entity Framework -- caching an object in memory across multiple contexts

would it make more sense to cache a non-change-tracking, non-entity perspective of the data. It seems like the tenant record is a "pointer" to foreign key relationships....logic to me is as follows:...do I have cached tenant info? nope.. go get it and cache it...now I need something related to the tenant ...used the cached key relations to go do e...

Entity Framework : Sharing entities across different DbContexts

When you add the Booking entity, don't use the ...DbSet.Add()... method. Instead use the ...DbSet.Attach()... method and set the ...DbContext.Entry(Entity).State... property for the Booking to ...EntityState.Added... and make sure the ...DbContext.Entry(Entity).State... for User stays ...EntityState.Unchanged.......So for example instead of doing t...

Create a database relationship between 2 entities in different Entity Framework DbContexts

I have two Objects (UserProfile and Login) that resides in different assemblies and I have to create a relationship between them in SQL Server (I don't care about the DbContext relationship, but I'd like to assure the database referential integrity between the their respective tables)....The easiest way is to update the database (I am using code fi...

Entity Framework Core - 2 Contexts in the same database - Second context tables are not created

Actually I found only this way. ...RelationalDatabaseCreator databaseCreator = (RelationalDatabaseCreator) context.Database.GetService<IDatabaseCreator>(); databaseCreator.CreateTables();

Run different database types in different environments in dotnet core 2

I want to run a SQLite database in development and a SQLServer Express database in production....We are using code first with database migrations....How do I inject a different dbcontext in each environment?...How do I run migrations against a specific database. E.g. In development I'll want to run migrations against the SQLite database.

In Entity Framework, how to generate entities from different Oracle schemas in VS2017

I am currently attempting to generate code from tables from an existing Oracle 12 database from within Entity Framework 6. The problem I am having is that while it is able to see the schema that I own when I log into the environment, Entity Framework can't seem to see any other schemas that I have access to....How can I change it so that I can see ...

Entity Framework inserting entity twice in two different contexts

I'm using Entity Framework Core to store an object graph in a database. At various times while I'm building the graph, I create an entity, store it to the database, and the release the context. However, I'm running into an issue where EFC is trying to insert an entity that has already been inserted when it is connected to a new entity. This is b...

EntityFramework context across multiple projects or joining between two contexts

I have a class library project containing an EF Core db context. This is part of a framework....I want to extend this context but without making changes to the framework project. The second context would use the same database....I created another db context in a different class library (something similar to ...this...). This works ok, I can make qu...

Fetch users list from 165 databases with 30 different DB schema using .NET CORE and EF

I am building an API that will ...fetch users list from 165 databases with 30 different DB schema.......Some tables might have different names, like table ...User..., it could be named ...User..., ...Users..., ...AspNetUsers..., ...ApplicationUser.......Fields from certain tables might have different name even though they contain same information. ...