Visual Studio

Visual Studio Community 2015 - MSSQL server info

Add MSSQL database to project

In Visual Studio Community 2015 project (main menu):

Project > Add New Item... > Data > SQL Server Database

Default name/type: Database1.mdf

Location: C:\Users\User\Documents\Visual Studio 2015\Projects\WebApp\WebbApp\App_Data\Database1.mdf

MSSQLLocalDB

Connection string parameters info:
Data Source=(LocalDb)\MSSQLLocalDB;

Path to the MSSQLLocalDB exe file:
C:\Program\Microsoft SQL Server\130\Tools\Binn\SQLLocalDB.exe

The MSSQLLocalDB instances are stored in this location:
C:\Users\User\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB

AttachDbFilename=|DataDirectory|\...

An ASP.NET application resolves |DataDirectory| to the "<application root>/app_data" folder.

More info

http://stackoverflow.com/questions/35145547/how-to-connect-to-database-created-in-vs2015-sql-server-data-tools
https://xpert360.wordpress.com/2015/08/11/visual-studio-2015-and-localdb-instance-for-lightswitch/
http://stackoverflow.com/questions/32830336/how-to-add-localdb-to-visual-studio-2015-communitys-sql-server-object-explorer
http://stackoverflow.com/questions/26977106/visual-studio-2013-does-not-create-sql-server-2014-localdb-database

https://msdn.microsoft.com/en-us/library/hh510202(v=sql.120).aspx
- SQL Server 2014 Express LocalDB

https://msdn.microsoft.com/en-us/library/ms143547.aspx
- File Locations for Default and Named Instances of SQL Server

https://msdn.microsoft.com/en-us/library/8s2t4x15.aspx
https://msdn.microsoft.com/library/8s2t4x15(v=VS.140).aspx
- Add new data sources (Visual Studio 2015)

http://sqlcetoolbox.codeplex.com/documentation
https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1?SRC=VSIDE
- SQL Server Compact/SQLite Toolbox

To top