rick graner dot com

developers! developers! developers!
musings of my creative and technical writing

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>