I have an Extension method on
DbContext where I want to do a
SqlBulkCopy. Therefore I need a
SqlConnection. The connection from the DbContext is from the type
Among a few other things I tried this:
var connection = new SqlConnection( dbContext.Database.Connection.ConnectionString);
Problem is that the password is missing (probably for security reasons).
Another thing that I tried is upcasting:
var bulk_copy = new SqlBulkCopy( (SqlConnection)dbContext.Database.Connection );
That actually presumes the DbConnection is a SqlConnection. In this very specific case it already goes wrong. I'm using the MVC MiniProfiler that wraps the connection into an
EFProfiledDbConnection. EFProfiledDbConnection does not inherit from SqlConnection.
Any other ideas? Thanks in advance!
Well, if both can share the same
Connection String then I guess they're both
Try this instead:
var connection = rep.Database.Connection as SqlConnection;