Creating a connection string and working with SQL Server LocalDB

Question

I have problem when I try to connect to LocalDB from Visual Studio 15. I have installed SQL Server Express 2016

I'm following this tutorial: http://www.asp.net/mvc/overview/getting-started/introduction/creating-a-connection-string

I create a model and context (MovieDBContext) class and try to setup a connection:

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-MvcMovie-20130603030321.mdf;Initial Catalog=aspnet-MvcMovie-20130603030321;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="MovieDBContext"    connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated Security=True" providerName="System.Data.SqlClient"
/>

When I try to access the page where I show all movies:

public ActionResult Index()
{
    return View(db.Movies.ToList());
}

I get this exception:

I tried to edit the connection strings like this, and this does not work either:

<connectionStrings>
  <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-MvcMovie-20130603030321.mdf;Initial Catalog=aspnet-MvcMovie-20130603030321;Integrated Security=True" providerName="System.Data.SqlClient" />
  <add name="MovieDBContext"   connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Movies.mdf;Integrated Security=True" providerName="System.Data.SqlClient"
/>  </connectionStrings>

I get this exception when I use (local)MSSQLLocalDB

What am I doing wrong?

In Visual Studio, on the Tools Menu, can you connect to the database? Your database should be appearing in the Server Explorer, where you can find the correct connectionString. — Henrique Forlani
– Henrique Forlani, Commented Aug 4, 2016 at 12:28
What is the name of the class that inherits from DbContext?Your "db" class? — Denys Wessels
– Denys Wessels, Commented Aug 4, 2016 at 12:33
If you open Sql Server Management Studio can you login to (LocalDb)\v11.0 — Denys Wessels
– Denys Wessels, Commented Aug 4, 2016 at 12:38
if you have a db already (.mdf file) your AttachDbFileName should be pointing to the right path — Henrique Forlani
– Henrique Forlani, Commented Aug 4, 2016 at 12:45
@Forlani there's nothing wrong with his connection string.He's using EF code first and if the .mdf file doesn't exist it will be created. — Denys Wessels
– Denys Wessels, Commented Aug 4, 2016 at 12:48

Ilya Chumakov · Accepted Answer · 2016-08-04 13:56:44Z

20

The initial Catalog is missing in MovieDBContext connection string. It needs to be as follows:

 <add name="MovieDBContext"   connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Movies.mdf;Initial Catalog=Movies;Integrated Security=True" providerName="System.Data.SqlClient"/>

edited Aug 4, 2016 at 13:56

Ilya Chumakov

25.4k10 gold badges99 silver badges124 bronze badges

answered Aug 4, 2016 at 12:53

Vinod Ghunake

3162 silver badges7 bronze badges

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

1 Comment

Ivan Over a year ago

Thanks this work and .mdb is created inside App_Data

Collectives™ on Stack Overflow

Creating a connection string and working with SQL Server LocalDB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related