Get SqlConnection from DbConnection

Well, if both can share the same Connection String then I guess they’re both SqlConnection.

Try this instead:

var connection = rep.Database.Connection as SqlConnection;