C# .Net SqlConnection to LocalDB

Question

I feel silly for even having to ask this, but I must be missing something.

I am simply trying to open a new SqlConnection to my LocalDB instance on my development machine. Visual Studio 2013.

I can and am connected to LocalDB from SSMS and am not having any issues. In the solution I am working on, I can and have succesfully connected to LocalDB with Entity Framework.

In another project within the same solution I am attempting to connect to LocalDB with an old school SqlConnection object, and this is where I am just totally failing.

Here is the connection string I am trying to use,

SqlConnection SqlConn = new SqlConnection("Server=(LocalDb)\v11.0;Initial Catalog=DBNAME;Integrated Security=SSPI;Trusted_Connection=yes;");

When I call SqlConn.Open() I get an error message saying it can't find or connect to the database.

This doesn't really matter as the connection string will be changed when this gets merged to production, but I can't for the life of me figure out why I am unable to get this SqlConnection object to talk with LocalDB

Maybe? I almost never use LocalDB...Here is the connection string that I have set for Entity Framework to talk to LocalDB <add name="NHFolding" connectionString="Server=(LocalDb)\v11.0;Integrated Security=true;Initial Catalog=DBNAME" providerName="System.Data.SqlClient" /> — mituw16
– mituw16, Commented Dec 8, 2014 at 20:30
Is the project a web project or something that would be running as a different user? — D Stanley
– D Stanley, Commented Dec 8, 2014 at 20:32
Well now I really do feel like an idiot....I forgot to escape the backslash in the connection string in the C# Code....It's fixed now. Thank you @DStanley — mituw16
– mituw16, Commented Dec 8, 2014 at 20:32

Zind · Accepted Answer · 2014-12-08 20:32:01Z

9

It looks like you might need to escape the slash in your connection string.

Turn this: "Server=(LocalDb)\v11.0;Initial Catalog=DBNAME;Integrated Security=SSPI;Trusted_Connection=yes;"

Into this: "Server=(LocalDb)\\v11.0;Initial Catalog=DBNAME;Integrated Security=SSPI;Trusted_Connection=yes;"

answered Dec 8, 2014 at 20:32

Zind

7611 gold badge7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mituw16 Over a year ago

This was it. Thank you, Zind

Termato Over a year ago

@mituw16 Best way to show thank you is to mark answer as correct :). Good find Zind!

mituw16 Over a year ago

I plan on it, @Termato .. Have to wait 2 more minutes until it will let me accept the answer :)

Lord Darth Vader · Accepted Answer · 2018-06-04 10:06:40Z

0

I found this nuget package that wraps up working with SQLLocalDB.

ISqlLocalDbProvider provider = new SqlLocalDbProvider();
ISqlLocalDbInstance instance = provider.GetOrCreateInstance("MyInstance");

instance.Start();

using (SqlConnection connection = instance.CreateConnection())
{
    connection.Open();

    // Use the connection...
}

instance.Stop();

answered Jun 4, 2018 at 10:06

Lord Darth Vader

2,0251 gold badge19 silver badges27 bronze badges

Comments

askepott · Accepted Answer · 2019-03-11 16:37:56Z

0

In my case I was using app.config in a separate PCL which obviously wasn't being read when ConfigurationManager.ConnectionStrings is looking for ConnectionStrings entries in app.config file.

What solved this was editing (in my case creating as there wasn't any file) the main project's app.config file and it worked great.

answered Mar 11, 2019 at 16:37

askepott

2893 silver badges14 bronze badges

Collectives™ on Stack Overflow

C# .Net SqlConnection to LocalDB

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related