0

I know about LocalDbConnectionFactory but I'm interested why using SqlConnectionFactory with the string

"Data Source=(localdb)\v11.0;Integrated Security=True; MultipleActiveResultSets=True"

causes System.Data.Entity.Core.ProviderIncompatibleException to be thrown.

Pavel Voronin
  • 13,503
  • 7
  • 71
  • 137

1 Answers1

0

SqlConnectionFactory is probably geared towards SQL Express and can't deal with LocalDB, which is why they added the LocalDbConnectionFactory.

Is there some reason you can't just use the LocalDbConnectionFactory?

Mikee
  • 1,571
  • 2
  • 14
  • 24
  • No reason, just want to know why. I thought LocalDB is absolutely the same sql express. At least it's what I got from docs. – Pavel Voronin May 01 '14 at 05:54
  • They are not the same, from the SQL Server Express guys [blog](http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx) looks like Express will probably be going away in time. – Mikee May 01 '14 at 12:55