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: http://stackoverflow.com/a/14663178/1942895 — Rafael Companhoni, Aug 28 '15 at 16:56

score 1 · Accepted Answer · edited May 23 '17 at 12:31

1

You should add the following to your class constructor:

Database.SetInitializer<OldSiteDB>(null);

From this SO answer.

edited May 23 '17 at 12:31

Community

1
1

answered Aug 28 '15 at 16:29

thepirat000

12,362
4
46
72

Access a table of a separate database using entity framework

1 Answers1