Can I use EF4 EntityConnection in SqlConnection?

Question

For instance:

SqlConnection connection = new SqlConnection(efContext.Connection...?)
connection.Open();

etc..

Answer 1

Not directly, no, but you can get the Sql connection string from it and create a new connection using the property StoreConnection:

SalesSyncEntities ctx = new SalesSyncEntities();
    EntityConnection ec = (EntityConnection)ctx.Connection;
    SqlConnection sc = (SqlConnection)ec.StoreConnection;
    string adoConnStr = sc.ConnectionString;
    return adoConnStr;

Found here .

Answer 2

No, the Entity Framework connection strings indicate the model files, as well as the main storage store; This is not a format that SQL Server understands.