Mega Code Archive
GetFactoryClasses, GetFactory
<![CDATA[
using System;
using System.Data;
using System.Data.Common;
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.CommandType = CommandType.StoredProcedure;
com.CommandText = "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"]);
}
}
}
}
}
}
]]>