If you delete the DB file, it still stays registered with SqlLocalDB. Sometimes it fixes it to delete the DB. You can do this from the command line. Open the “Developer Command Propmpt for VisualStudio” under your start/programs menu. Run the following commands: sqllocaldb.exe stop v11.0 sqllocaldb.exe delete v11.0
Requires .NET framework 4 updated to at least 4.0.2. If you have 4.0.2, then you should have HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319\SKUs.NETFramework,Version=v4.0.2 If you have installed latest VS 2012 chances are that you already have 4.0.2. Just verify first. Next you need to have an instance of LocalDb. By default you have an instance whose name is a single … Read more
In Visual Studio 2012 all I had to do was enter: (localdb)\v11.0 Visual Studio 2015 and Visual Studio 2017 changed to: (localdb)\MSSQLLocalDB as the server name when adding a Microsoft SQL Server Data source in: View/Server Explorer/(Right click) Data Connections/Add Connection and then the database names were populated. I didn’t need to do all the … Read more
You don’t need to install SQL Server Express to use LocalDB, as LocalDB is SQL Server Express, just easier to install. Once LocalDB is installed you can use AttachDbFileName property of the connection string to “open” an MDF file. Keep in mind that the same file can only be opened by a single LocalDB instance … Read more