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);
}
}