CODEWITHSUNDEEP
c#sql-serverentity-framework
Scott Selby
Scott Selby

Reputation: 9570

use Entity Framework to connect to 2 dbs

My question is pretty simple, we are using Entity Framework 5 and use the standard setup. We are in the middle of moving servers around the country, and need a period where all db transactions ( insert, update ) to do the exact same thing to two different connection strings. Both databases will be identical and the purpose of this is to keep them identical.

Is there any way to set up Entity Framework's DbContext to connect to multiple connection strings?

Upvotes: 0

Views: 117

Answers (1)

Eric J.
Eric J.

Reputation: 150108

Is there any way to set up Entity Framework's DbContext to connect to multiple connection strings?

No, this is not possible.

Consider setting up replication between the two servers instead.

We are in the middle of moving servers around the country

Note that replication can catch up if one of the servers becomes available for some period of time.

Upvotes: 1

Related Questions