Access a table of a separate database using entity framework

Question

I have an MVC website with its own database and everything is working fine. Now I want to access a table of a database from a different MVC site. I added the connection string in the Web.config and named it OldMvcDB. Then I added a class to access this table:

public class OldSiteDB : DbContext
{
    public OldSiteDB() : base("name=OldMvcDB") { }

    public DbSet<OldTable> OldTables { get; set; }
}

When I try to access this table, I get the error: The model backing the 'OldSiteDB' context has changed since the database was created.

This is because the old database has a lot of other tables so the context doesn't match.

How can I access this one table without having to duplicate all the items in my new site?

I think you must disable code-first as explained here: stackoverflow.com/a/14663178/1942895 — Rafael Companhoni
– Rafael Companhoni, Commented Aug 28, 2015 at 16:56

Community · Accepted Answer · 2017-05-23 12:31:22Z

1

You should add the following to your class constructor:

Database.SetInitializer<OldSiteDB>(null);

From this SO answer.

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Aug 28, 2015 at 16:29

thepirat000

13.3k4 gold badges51 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Access a table of a separate database using entity framework

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related