Change your connection string to use your local database

I always find myself changing the connection string in my web.config file when spinning up a new project with ASP.NET MVC.

The reason I change it is because I like to download the free SQL Server Express and use the Microsoft SQL Server Management Studio to manage all of my databases locally.

I always find myself changing the connection string in my web.config file when spinning up a new project with ASP.NET MVC.

The reason I change it is because I like to download the free SQL Server Express and use the Microsoft SQL Server Management Studio to manage all of my databases locally.

<connectionStrings>
	<add name="DefaultConnection"
			connectionString="Data Source=(local);Initial Catalog=YOUR_DATABASE_NAME_GOES_HERE;Integrated Security=True"
			providerName="System.Data.SqlClient" />
</connectionStrings>

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.