Csharp/C Sharp/Database ADO.net/SqlCommandBuilder

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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>