This is strange as I'm able to connect to localDB through SSMS 2008R2 with the same connection string ("Data Source=(LocalDB)\v11.0;Integrated Security=true
")
Only C#
code is unable to connect, I have tried increasing login time with Connect Timeout=60
but no luck.
I have also tried specifying the database Initial Catalog=<databasename>
where the <databasename> is the one I have created on localdb via ssms.
Any pointers as to why is this not connecting?
LocalDB is absolutely supported in production. From the performance point of view it is identical to SQL Server Express, as they share the same database engine.
Any chance it is because you forgot to double-escape the backslash? Did you try this:
"Data Source=(LocalDB)\\v11.0;Integrated Security=true"
Or even better, you could just use the @
mark to disable character escaping for the entire connection string:
@"Data Source=(LocalDB)\v11.0;Integrated Security=true"
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With