в 15:31, 26 мая 2010

2010-05-26T15:31:19Z

Admin: 1 версия

2010-05-26T11:42:29Z

1 версия

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

==Create Connection==

<source lang="csharp">

using System;
using System.Data;
using System.Data.rumon;
class MainClass {
public static void Main(string[] args) {
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
using (IDbConnection con = factory.CreateConnection()) {
con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";
using (IDbCommand com = con.CreateCommand()) {
com.rumandType = CommandType.StoredProcedure;
com.rumandText = "Ten Most Expensive Products";
con.Open();
using (IDataReader reader = com.ExecuteReader()) {
Console.WriteLine(Environment.NewLine);
Console.WriteLine("Price of the Ten Most Expensive Products.");
while (reader.Read()) {
Console.WriteLine(" {0} = {1}", reader["TenMostExpensiveProducts"], reader["UnitPrice"]);
}
}
}
}
}
}
</source>

==GetFactoryClasses, GetFactory==

<source lang="csharp">

using System;
using System.Data;
using System.Data.rumon;
class MainClass {
public static void Main(string[] args) {
using (DataTable providers = DbProviderFactories.GetFactoryClasses()) {
foreach (DataRow prov in providers.Rows) {
Console.WriteLine(" Name:{0}", prov["Name"]);
Console.WriteLine(" Description:{0}", prov["Description"]);
Console.WriteLine(" Invariant Name:{0}",prov["InvariantName"]);
}
}
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
using (IDbConnection con = factory.CreateConnection()) {
con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";
using (IDbCommand com = con.CreateCommand()) {
com.rumandType = CommandType.StoredProcedure;
com.rumandText = "Ten Most Expensive Products";
con.Open();
using (IDataReader reader = com.ExecuteReader()) {
Console.WriteLine(Environment.NewLine);
Console.WriteLine("Price of the Ten Most Expensive Products.");
while (reader.Read()) {
Console.WriteLine(" {0} = {1}", reader["TenMostExpensiveProducts"], reader["UnitPrice"]);
}
}
}
}
}
}
</source>

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

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

в 15:31, 26 мая 2010

Admin: 1 версия