Create an SQL Database Connection

This C# program demonstrates how to create a SQL database connection for Microsoft SQL in C#.

Program.cs

using System;
using System.Data.SqlClient;

namespace Connection {
    class Program {
        static void Main(string[] args) {
            SqlConnection qConnection = new System.Data.SqlClient.SqlConnection(
            	@"Server=localhost\SQLEXPRESS01;Trusted_Connection=True;");

            Console.WriteLine(qConnection.ToString());
            qConnection.Open();
            Console.WriteLine("ConnectionString = " + qConnection.ConnectionString);
            Console.WriteLine("ConnectionTimeout = " + qConnection.ConnectionTimeout);
            Console.WriteLine("Container = " + qConnection.Container);
            Console.WriteLine("Database = " + qConnection.Database);
            Console.WriteLine("DataSource = " + qConnection.DataSource);
            Console.WriteLine("FireInfoMessageEventOnUserErrors = "
            	+ qConnection.FireInfoMessageEventOnUserErrors);
            Console.WriteLine("PacketSize = " + qConnection.PacketSize);
            Console.WriteLine("ServerVersion = " + qConnection.ServerVersion);
            Console.WriteLine("Site = " + qConnection.Site);
            Console.WriteLine("State = " + qConnection.State);
            Console.WriteLine("StatisticsEnabled = " + qConnection.StatisticsEnabled);
            Console.WriteLine("WorkstationId = " + qConnection.WorkstationId);
            qConnection.Close();
        }
    }
}

Output

System.Data.SqlClient.SqlConnection
ConnectionString = Server=localhost\SQLEXPRESS01;Trusted_Connection=True;
ConnectionTimeout = 15
Container =
Database = master
DataSource = localhost\SQLEXPRESS01
FireInfoMessageEventOnUserErrors = False
PacketSize = 8000
ServerVersion = 14.00.2014
Site =
State = Open
StatisticsEnabled = False
WorkstationId = LENOVO-MHALL
Press any key to continue . . .