- Open cmd.exe
- Run sqllocaldb.exe info 查看当前用户的LocalDB实例列表
上面命令返回: MSSQLLocalDB - Run sqllocaldb.exe start MSSQLLocalDB 启动指定的实例
返回:LocalDB instance “MSSQLLocalDB” has been started. - Run sqllocaldb.exe info MSSQLLocalDB 查看详细信息
可以看到: 状态为:运行中 - 在Visual Studio2015 选TOOLS > Connect to Database…
- 配置
Data source: Microsoft SQL Server (SqlClient)
Server name: (localdb)\MSSQLLocalDB
Log on to the server: Use Windows Authentication
Select or enter a database name: 新建就输入要创建的数据库名,使用已有的就从下拉列表里面选
创建出来的数据库文件默认被放到了当前用户目录,比如:c:\user\USERNAME\
localdb连接字符串
<connectionStrings>
<add name="EFDbContext" connectionString="Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=SportsStore;Integrated Security=True" AttachDBFilename=E:\myDB.mdf" providerName="System.Data.SqlClient" />
</connectionStrings>