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

entity-framework entity-framework-core

Question

I'm trying to use 2 contexts on the same database.
To create the database I'm using DbContext.Database.EnsureCreated()
The first EnsureCreated call works fine, the second EnsureCreated call does not work.

Some considerations

Profiling SQL Server I can see that EF Core checks for the existence of a table 

IF EXISTS (
        SELECT 
            * 
        FROM 
            INFORMATION_SCHEMA.TABLES 
        WHERE 
            TABLE_TYPE = 'BASE TABLE') 

    SELECT 1 
ELSE 
    SELECT 0

then it runs the create table statement.
If there is a user table on the DB nothing is done...

Is there a way to force table creations from entities scaffolding?

1
2
8/21/2017 10:14:58 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Actually I found only this way. 

RelationalDatabaseCreator databaseCreator = 
    (RelationalDatabaseCreator) context.Database.GetService<IDatabaseCreator>();
databaseCreator.CreateTables();
2
8/21/2017 11:26:48 AM

Popular Answer

In my case it was because I failed to run add-migration SecondContext_Initial -Context SecondContext so there was no migration to run. Both EnsureCreated() (returned false) and Migrate() (did nothing) failed to yield any clues to my neglect.

Dave T.

Related Questions

Entity Framework : The model backing the 'EFDbContext' context has changed since the database was created

You can turn on debugger, i would assume the exception will stop at one the dbcontext or dbset, and inspect the dbcontext or dbset variable, find its dbcontext object , and inspect base -> Database -> connectionstring property, then you should see which database it is complaining. Looks like you are deleting the wrong database.
asp.net-mvc c# dbcontext entity-framework entity-framework-6
asked by anIBMer

Entity Framework 6 Code First From Database context performs CREATE TABLE on existing an VIEW

Fixed when migrations are disabled:...System.Data.Entity.Database.SetInitializer<TestContext>(null);
database entity-framework entity-framework-6 oracle
asked by Tiele Declercq

How to detach entity from context when you no longer have a context reference

Retrieving the cached data with ...AsNoTracking... is the first step. But (apparently) the objects in the cache are created as proxies, so they are aware of having been created by another context....So make sure that no proxies, but just POCO's are cached, which you do by disabling proxy creation in the context that fetches the objects to the cache...
c# caching datacontext entity-framework entity-framework-6
asked by Gert Arnold

EF6 two contexts vs. single context with two awaits

As you found out, the DbContext is not thread safe, therefore the only option to really run the queries in parallel would be to create a new DbContext for each Thread/Task....The overhead of creating a new DbContext is pretty low. ...https://msdn.microsoft.com/en-us/library/cc853327.aspx...Since the object will come from different DbContexts and t...
c# entity-framework entity-framework-6 performance
asked by Chris

Entity framework Core with Identity and ASP.NET Core RC2 not creating user in database

Check the result of ..._userManager.createAsync.... ...var result = await _userManager.CreateAsync(user, "P@SSWORD"); if (!result.Succeeded) { // something went wrong, inspect the errors } ...You'll most likely find a required property on your ...IdentityUser... is missing or the password is not valid.
asp.net-core entity-framework-core
asked by Brad

Creating a database context using the database first approach with entityframework core.

If you are creating tests, do you need a backing Sql database? Would the In-memory provider not serve you better?...options.UseInMemoryDatabase("database-name"); ...For this reason, I'd ditch using the ...OnConfiguring... method, and rely on passing the ...DbContextOptions... to your constructor...Side note, you have to consider ...what... you are ...
asp.net-core dbcontext entity-framework-core
asked by Matthew Abbott

Entity Framework core navigation property between two contexts

Solved using database context inheritance. This way I can have separate migrations....public class SecondDbContext : FirstDbContext { public virtual DbSet<UserExt> ExtendedUsers { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("connectionString", options =>...
c# entity-framework entity-framework-core foreign-keys
asked by SzilardD

Entity Framework Core is not creating tables in my databases

I've tried deleting and creating a new database, deleting and creating new migrations, and can't get anything to work. ...First, I created a new database, then put the connection string in appsettings, and tried to run "update-database". All I got was this:...Executed DbCommand (178ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT...
asp.net-core-2.0 c# ef-migrations entity-framework-core sql-server
asked by Chris James

Entity Framework Core scaffold additional tables not context

From Microsoft documentation:...https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/existing-db...When trying to reverse engineer your models and dbcontext from an existing database, you can run a command like this:...Scaffold-DbContext "Server=myserver; Database=mydatabase; Integrated Security=True;" Microsoft.EntityFrameworkCore.SqlSe...
c# entity-framework-core
asked by JsonStatham

EntityFramework context across multiple projects or joining between two contexts

You could make your second context inherit the first....public class MyFirstContext : DbContext { public DbSet<User> Users { get; set; } } public class MySecondContext : MyFirstContext { public DbSet<UserBook> UserBooks { get; set; } } ...Of course, your second context could be in a different assembly. Now you only need ...MySecondContext....
c# entity-framework entity-framework-core
asked by Knelis

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow