в 15:31, 26 мая 2010

2010-05-26T15:31:53Z

Admin: 1 версия

2010-05-26T12:19:05Z

1 версия

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

==Build a connection string from component parameters and display it==

<source lang="csharp">using System;
using System.Data.SqlClient;
class MainClass
{
public static void Main(string[] args)
{

SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder();
sb2.DataSource = @".\sqlexpress";
sb2.InitialCatalog = "Northwind";
sb2.IntegratedSecurity = true;
sb2.MinPoolSize = 5;
sb2.MinPoolSize = 15;
sb2.LoadBalanceTimeout = 600;
sb2.ConnectionReset = true;
Console.WriteLine("Constructed connection string:");
Console.WriteLine(" " + sb2.ConnectionString);
}
}</source>
<pre class=codeResult>Constructed connection string:
Data Source=.\sqlexpress;Initial Catalog=Northwind;Integrated Security=True;Min Pool Size=15;Conne
ction Reset=True;Load Balance Timeout=600</pre>

==BuildConnectionString solution==

<source lang="csharp">using System;
using System.Data.SqlClient;
class Program
{
static void Main(string[] args)
{
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder( );
csb.DataSource = "(local)";
csb.Add("Initial Catalog", "AdventureWorks");
csb["Integrated Security"] = true;
Console.WriteLine("Connection string:\n{0}", csb.ConnectionString);
SqlConnection connection = new SqlConnection(csb.ConnectionString);
connection.Open( );
Console.WriteLine("\nConnectionState = {0}", connection.State);
connection.Close( );
Console.WriteLine("ConnectionState = {0}", connection.State);

}
}</source>

==Build SqlConnectionStringBuilder from connection string==

<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("Parsed SQL Connection String Parameters:");
Console.WriteLine(" Database Source = " + sb1.DataSource);
Console.WriteLine(" Database = " + sb1.InitialCatalog);
Console.WriteLine(" Use Integrated Security = " + sb1.IntegratedSecurity);
Console.WriteLine(" Min Pool Size = " + sb1.MinPoolSize);
Console.WriteLine(" Max Pool Size = " + sb1.MinPoolSize);
Console.WriteLine(" Lifetime = " + sb1.LoadBalanceTimeout);
Console.WriteLine(" Connection Reset = " + sb1.ConnectionReset);
}
}</source>
<pre class=codeResult>Parsed SQL Connection String Parameters:
Database Source = .\sqlexpress
Database = Northwind
Use Integrated Security = True
Min Pool Size = 5
Max Pool Size = 5
Lifetime = 600
Connection Reset = True</pre>

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

Csharp/CSharp Tutorial/ADO.Net/SqlConnectionStringBuilder - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия