Showing posts with label Visual Studio. Show all posts
Showing posts with label Visual Studio. Show all posts

09 March, 2024

Local database(localdb) not seen in SQL Server Explorer via Visual Studio

To establish a connection to a localdb in Visual Studio, such as "Server=(localdb)\mssqllocaldb; Database=IdentityDB," follow these steps:

  1. Go to Server Explorer > right-click on Data Connections > select Add Connection... 




  2. Manually input the server name as (localdb)\mssqllocaldb (with only one slash) > The newly created database with the name IdentityDB will be automatically populated. 



    Result: