# Configure the Project for SQL Server

Add the Microsoft.Data.SqlClient package to a C# project, write a connection string for your local SQL Server, and keep it in appsettings.json.

![Cheat sheet: Configure the Project for SQL Server](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/9449f2d2cb4f472cba7970ee51473470.webp)

- Category: C#
- Level: Journeyman
- Tags: appsettings.json, Connection String, c-sharp, NuGet, Package Reference, t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/configure-the-project-for-sql-server-cheat-sheet