Does Entity Framework support ApplicationIntent=ReadOnly in SQLClient connection string

Question

Does Entity Framework support ApplicationIntent=ReadOnly in SQLClient connection string? It is in reference to Read-Only access on an Availability Replica feature of AlwaysOn Availability Groups (SQL Server 2012).

Answer 1

The only way I've found so far would involve creating the context using the connection string directly, instead of using a connection string name. This way you could append the ApplicationIntent.

string connectionString = string.Format("{0}; ApplicationIntent=READONLY", ConfigurationManager.ConnectionStrings["AppContext"].ConnectionString);

using (AppContext context = new AppContext(connectionString))
{
    var q = from row in context.table
            select row.id;
}