Sql connection in c#

Hi,

https://www.c-sharpcorner.com/UploadFile/201fc1/sql-server-database-connection-in-csharp-using-adonet/

In C#, a SQL Server database connection is established using the ADO.NET library. The SqlConnection class is responsible for creating and managing the connection between the application and the SQL Server database.

The connection details such as server name, database name, and authentication credentials are stored in a connection string.

Example:

using Microsoft.Data.SqlClient;

string connectionString =
    "Server=localhost;Database=EmployeeDB;Trusted_Connection=True;";

using SqlConnection conn = new SqlConnection(connectionString);

try
{
    conn.Open();
    Console.WriteLine("Database connection established successfully.");

    // Execute queries or stored procedures here
}
catch (Exception ex)
{
    Console.WriteLine($"Connection failed: {ex.Message}");
}

Key Components

• SqlConnection: Establishes the connection to SQL Server.

• Connection String: Contains database server and authentication information.

• Open(): Opens the database connection.

• Close() / using statement: Ensures the connection is properly released.

• Exception Handling: Helps capture and troubleshoot connection failures.

Sql C# coonection done by using System.Data.SqlClient  package

using System.Data.SqlClient;

string connectionString = "Server=your_server_name;Database=your_database_name;User Id=your_username;Password=your_password;";

using (SqlConnection connection = new SqlConnection(connectionString))

{

    connection.Open();

    Console.WriteLine("Connection successful!");

    

    // You can now execute SQL commands here

}