Csharp/C Sharp by API/System.Data.Common/DbProviderFactory

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>