sql - Entity Framework 6 with Azure DB secondary connection -


i'm facing problem ef against azure db secondary connection. here problem:

  • i'm using ef 6 code first
  • i setup primary azure db 2 active geo-replicated secondary database (have difference server , db name login account)
  • i use ef6 manipulate primary azure db. case if primary db down (by reason) , want switch active secondary dbs select statements @ runtime. how can achieved that?

notes: example, have code snippet below:

using (appcontext context = new appcontext()) // appcontext derived dbcontext , using primary connection string {      var users = await context.users.tolistasync(); // if line of code failed primary connection string }  

i want auto-switch dynamically secondary db if line var users... failed @ runtime. recommendation?

thanks help!


Comments

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -