C#. ADO.Net. Connection

Example shows connection with MSSQLServer

-connection with try/finally

-connection with using

-connection with async / await

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data.SqlClient;

namespace sqlServer
{
    class Program
    {
        static void Main(string[] args)
        {
            //string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";
            // получаем строку подключения
            //string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
            //Console.WriteLine(connectionString);

            //ConnectTryFinally();
            //ConnectWithUsing();
            //AsyncConnection();
            ConnInfo();
            Console.Read();
        }



        private static void ConnInfo()
        {
            string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Подключение открыто");

                // Вывод информации о подключении
                Console.WriteLine("Свойства подключения:");
                Console.WriteLine("\tСтрока подключения: {0}", connection.ConnectionString);
                Console.WriteLine("\tБаза данных: {0}", connection.Database);
                Console.WriteLine("\tСервер: {0}", connection.DataSource);
                Console.WriteLine("\tВерсия сервера: {0}", connection.ServerVersion);
                Console.WriteLine("\tСостояние: {0}", connection.State);
                Console.WriteLine("\tWorkstationld: {0}", connection.WorkstationId);
            }

            Console.WriteLine("Подключение закрыто...");
        }



        private static void AsyncConnection()
        {

            ConnectWithDB().GetAwaiter();

        }

        private static async Task ConnectWithDB()
        {
            string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                await connection.OpenAsync();
                Console.WriteLine("Подключение открыто");
            }
            Console.WriteLine("Подключение закрыто...");
        }


        private static void ConnectWithUsing()
        {

            //string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";
            string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Подключение открыто");
            }
            Console.WriteLine("Подключение закрыто...");

        }

        private static void ConnectTryFinally()
        {
            //string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";
            string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

            // Создание подключения
            SqlConnection connection = new SqlConnection(connectionString);
            try
            {
                // Открываем подключение
                connection.Open();
                Console.WriteLine("Подключение открыто");
            }
            catch (SqlException ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                // закрываем подключение
                connection.Close();
                Console.WriteLine("Подключение закрыто...");
            }

        }


    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Configuration;

using System.Data.SqlClient;

namespace sqlServer

{

class Program

{

static void Main(string[] args)

{

//string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";

// получаем строку подключения

//string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

//Console.WriteLine(connectionString);

//ConnectTryFinally();

//ConnectWithUsing();

//AsyncConnection();

ConnInfo();

Console.Read();

}

private static void ConnInfo()

{

string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";

using (SqlConnection connection = new SqlConnection(connectionString))

{

connection.Open();

Console.WriteLine("Подключение открыто");

// Вывод информации о подключении

Console.WriteLine("Свойства подключения:");

Console.WriteLine("\tСтрока подключения: {0}", connection.ConnectionString);

Console.WriteLine("\tБаза данных: {0}", connection.Database);

Console.WriteLine("\tСервер: {0}", connection.DataSource);

Console.WriteLine("\tВерсия сервера: {0}", connection.ServerVersion);

Console.WriteLine("\tСостояние: {0}", connection.State);

Console.WriteLine("\tWorkstationld: {0}", connection.WorkstationId);

}

Console.WriteLine("Подключение закрыто...");

}

private static void AsyncConnection()

{

ConnectWithDB().GetAwaiter();

}

private static async Task ConnectWithDB()

{

string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True";

using (SqlConnection connection = new SqlConnection(connectionString))

{

await connection.OpenAsync();

Console.WriteLine("Подключение открыто");

}

Console.WriteLine("Подключение закрыто...");

}

private static void ConnectWithUsing()

{

//string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";

string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

using (SqlConnection connection = new SqlConnection(connectionString))

{

connection.Open();

Console.WriteLine("Подключение открыто");

}

Console.WriteLine("Подключение закрыто...");

}

private static void ConnectTryFinally()

{

//string connectionString = @"Data Source=.\SQLEXPRESS01;Initial Catalog=usersdb;Integrated Security=True";

string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

// Создание подключения

SqlConnection connection = new SqlConnection(connectionString);

try

{

// Открываем подключение

connection.Open();

Console.WriteLine("Подключение открыто");

}

catch (SqlException ex)

{

Console.WriteLine(ex.Message);

}

finally

{

// закрываем подключение

connection.Close();

Console.WriteLine("Подключение закрыто...");

}

MY PROJECTS

Recent Posts

Categories