Mega Code Archive
Build SqlConnectionStringBuilder from connection string
<![CDATA[
using System;
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.MinPoolSize);
Console.WriteLine(" Lifetime = " + sb1.LoadBalanceTimeout);
Console.WriteLine(" Connection Reset = " + sb1.ConnectionReset);
}
}
Parsed SQL Connection String Parameters:
Database Source = .\sqlexpress
Database = Northwind
Use Integrated Security = True
Min Pool Size = 5
Max Pool Size = 5
Lifetime = 600
Connection Reset = True
]]>