How do you establish a connection to a database in your project?

In C#, the SqlConnection class from the System.Data.SqlClient namespace is typically used to establish a connection to a database.

Example of a simple connection to a SQL Server database:

using System.Data.SqlClient;

string connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    // Perform database operations
}

In more complex projects, ORMs like Entity Framework are often used, which manage connections and simplify data handling through objects.

It is also important to use connection pooling, which is enabled by default in SqlConnection, to improve performance and reduce database load.