Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Data Provider Factory

using System; using System.Collections.Generic; using System.Text; using System.Data.Common; using System.Configuration; using System.Data;   class Program   {     static void Main(string[] args)     {       string dp = "provider";       string cnStr ="YourProvider";       DbProviderFactory df = DbProviderFactories.GetFactory(dp);       DbConnection cn = df.CreateConnection();       Console.WriteLine(cn.GetType().FullName);       cn.ConnectionString = cnStr;       cn.Open();       DbCommand cmd = df.CreateCommand();       Console.WriteLine("Your command object is a: {0}", cmd.GetType().FullName);       cmd.Connection = cn;       cmd.CommandText = "Select * From Inventory";       DbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);       Console.WriteLine(dr.GetType().FullName);       while (dr.Read())         Console.WriteLine("-> Car #{0} is a {1}.",dr["CarID"], dr["Make"].ToString().Trim());       dr.Close();     }   }