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(" Connection Reset = " + sb1.ConnectionReset); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.ConnectionReset = true; Console.WriteLine(" " + sb2.ConnectionString); } }
Database ADO.net
LoadBalanceTimeout
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(" Lifetime = " + sb1.LoadBalanceTimeout); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.LoadBalanceTimeout = 600; Console.WriteLine(" " + sb2.ConnectionString); } }
MaxPoolSize
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(" Max Pool Size = " + sb1.MaxPoolSize); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.MaxPoolSize = 15; Console.WriteLine(" " + sb2.ConnectionString); } }
MinPoolSize
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(" Min Pool Size = " + sb1.MinPoolSize); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.MinPoolSize = 5; Console.WriteLine(" " + sb2.ConnectionString); } }
IntegratedSecurity
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(" Use Integrated Security = " + sb1.IntegratedSecurity); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.IntegratedSecurity = true; Console.WriteLine(" " + sb2.ConnectionString); } }
InitialCatalog
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(" Database = " + sb1.InitialCatalog); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.InitialCatalog = "Northwind"; Console.WriteLine(" " + sb2.ConnectionString); } }
new SqlConnectionStringBuilder(conString)
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(" " + sb1.ConnectionString); } }