Csharp/C Sharp/Database ADO.net/SqlCommandBuilder
Версия от 18:31, 26 мая 2010; (обсуждение)
Содержание
ConnectionReset
<source lang="csharp">
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); }
}
</source>
Generate SQL command automatically from SqlCommandBuilder and SqlDataAdapter
<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class Class1{
static void Main(string[] args){ SqlConnection thisConnection = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"); thisConnection.Open(); SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT ID from Employee", thisConnection); SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter); Console.WriteLine("SQL SELECT Command is:\n{0}\n", thisAdapter.SelectCommand.rumandText); SqlCommand updateCommand = thisBuilder.GetUpdateCommand(); Console.WriteLine("SQL UPDATE Command is:\n{0}\n", updateCommand.rumandText); SqlCommand insertCommand = thisBuilder.GetInsertCommand(); Console.WriteLine("SQL INSERT Command is:\n{0}\n", insertCommand.rumandText); SqlCommand deleteCommand = thisBuilder.GetDeleteCommand(); Console.WriteLine("SQL DELETE Command is:\n{0}", deleteCommand.rumandText); thisConnection.Close(); }
}
</source>
IntegratedSecurity
<source lang="csharp"> 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); }
}
</source>
LoadBalanceTimeout
<source lang="csharp"> 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); }
}
</source>
MaxPoolSize
<source lang="csharp"> 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); }
}
</source>
MinPoolSize
<source lang="csharp"> 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); }
}
</source>
new SqlConnectionStringBuilder(conString)
<source lang="csharp"> 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); }
}
</source>