Csharp/C Sharp by API/System.Data.Common/DbProviderFactory — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 18:31, 26 мая 2010
DbProviderFactory.CreateConnection
<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 = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;"; using (IDbCommand com = con.CreateCommand()) { com.rumandType = CommandType.Text; com.rumandText = "SELECT ID, FirstName FROM Employee"; con.Open(); using (IDataReader reader = com.ExecuteReader()) { while (reader.Read()) { // Display the product details. Console.WriteLine(" {0} = {1}", reader["ID"], reader["FirstName"]); } } } } }
}
</source>