it:ad:sql_server:howto:connect_to_localdb

IT:AD:sql server howto connect to localdb

I used to use a connection string that was specific to the version:

  <connectionStrings>
    <add name="AppDbContext" connectionString="data source=(LocalDb)\v11.0;initial catalog=App_SS_02;integrated security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>
  

But the following is better:

  <connectionStrings>
    <add name="AppDbContext" connectionString="data source=(localDB)\MSSQLLocalDB;initial catalog=App_SS_02;integrated security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>


  • /home/skysigal/public_html/data/pages/it/ad/sql_server/howto/connect_to_localdb.txt
  • Last modified: 2023/11/04 01:57
  • by 127.0.0.1