I am trying to research how to get Entity Framework connection string that supports failover.
With TNSNAMES.ora and the Unmanaged client, failover could be configured to a single DataSource name.
I have read through some of the documentation about attaching a failover event, but isn't that after the event has happened? I need to know when it happens and how to point it at another server/database.
Shouldn't the connection string have some information about the failover server? IE: Sql Server and Failover partner.
Thanks, any direction provided would be a big help.
Peter