в 15:31, 26 мая 2010

2010-05-26T15:31:19Z

Admin: 1 версия

2010-05-26T11:42:42Z

1 версия

Новая страница

==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>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Csharp/C Sharp/Database ADO.net/SqlCommandBuilder - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия