SQL LocalDB Connection string

Under SQL 2012, connect LocalDB with the string:

Data source= (LocalDB) \v11.0;initial Catalog=d:\aa. Mdf;integrated Security=true

The LocalDB instance name in sql2014 is:(localdb) \mssqllocaldb

The simplest way to use LocalDB is by using the connection string "server= (LocalDB) \mssqllocaldb;integrated security=true" Connect to an automatic instance owned by the current user.

To connect to a specific database by using a file name, use a similar "server= (LocalDB) \mssqllocaldb; Integrated security=true; Attachdbfilename=d:\data\mydb1.mdf " connection string for the connection.

SQL LocalDB Connection string