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

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?

bubi · Accepted Answer · 2017-08-21 11:26:48Z

3

Actually I found only this way.

RelationalDatabaseCreator databaseCreator = 
    (RelationalDatabaseCreator) context.Database.GetService<IDatabaseCreator>();
databaseCreator.CreateTables();

answered Aug 21, 2017 at 11:26

bubi

6,5013 gold badges32 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Imran Qadir Baksh - Baloch Over a year ago

What about InMemoryDatabaseCreator?

Aleks Vujic Over a year ago

What if you have multiple DbContexts, each for its separate database schema AND there are cross-schema references between tables with foreign keys? You would have to call CreateTables() on both DbContexts, but because there are cross-schema references between them, it would try to create the same table two times which results in an exception.

Sora Teichman Over a year ago

@samcarlson, did you find a solution to that issue?

Aleks Vujic Over a year ago

@SoraTeichman Take a look at this GitHub issue: github.com/dotnet/efcore/issues/30844#issuecomment-1539946766

Dave T. · Accepted Answer · 2017-09-10 22:13:22Z

1

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.

answered Sep 10, 2017 at 22:13

Dave T.

1,4081 gold badge13 silver badges17 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related