Search code examples
sql-serverentity-frameworklocaldb

My code against LocalDB works but I can't see the database anywhere

I have a simple website that uses EF Code First and LocalDB. This is in my web.config:

<connectionStrings>
  <add name="MyContext" providerName="System.Data.SqlClient" connectionString="Server=(localdb)\v11.0;Integrated Security=true;"/>
</connectionStrings>

My website works fine, PowerShell commands like Update-Database and Add-Migration work fine, however, I cannot see the database anywhere inside Visual Studio. Not in SQL Server Object Explorer, not in Server Explorer (when I try to connect to "MyContext" database on the (localdb)\v11 server, the dialog tells me that there is no such db there).

MyContext misssing

I am confused. Where is my database?

Solution

  • There is one property define - Initial Catalog

    Data Source=(localdb)\v11.0;Initial Catalog=YourDbName;Integrated Security=True;