Create a Database Connection String Programmatically - CSharp Database

CSharp examples for Database:Connection

  1. HOME
  2. CSharp
  3. Database
  4. Connection

Description

Create a Database Connection String Programmatically

Demo Code


using System;//www.  j  a  v  a  2s.  c  o  m
using System.Data.SqlClient;

class MainClass
    {
        public static void Main(string[] args)
        {
            string conString = @"Data Source=.\sqlexpress;" +
                "Database=Northwind;Integrated Security=SSPI;" +
                "Min Pool Size=5;Max Pool Size=15;Connection Reset=True;" +
                "Connection Lifetime=600;";

            SqlConnectionStringBuilder sb1 = new SqlConnectionStringBuilder(conString);

            Console.WriteLine("Parsed SQL Connection String Parameters:");
            Console.WriteLine("  Database Source = " + sb1.DataSource);
            Console.WriteLine("  Database = " + sb1.InitialCatalog);
            Console.WriteLine("  Use Integrated Security = "
                + sb1.IntegratedSecurity);
            Console.WriteLine("  Min Pool Size = " + sb1.MinPoolSize);
            Console.WriteLine("  Max Pool Size = " + sb1.MaxPoolSize);
            Console.WriteLine("  Lifetime = " + sb1.LoadBalanceTimeout);

            // Build a connection string from component parameters and display it.
            SqlConnectionStringBuilder sb2 =
                new SqlConnectionStringBuilder(conString);

            sb2.DataSource = @".\sqlexpress";
            sb2.InitialCatalog = "Northwind";
            sb2.IntegratedSecurity = true;
            sb2.MinPoolSize = 5;
            sb2.MinPoolSize = 15;
            sb2.LoadBalanceTimeout = 600;

            Console.WriteLine(sb2.ConnectionString);

        }
    }

Result


Related Tutorials