public static void TestProviderFactory()
{
Console.WriteLine("Configured Providers:");
foreach (Provider p in ProviderFactory.Providers)
{
Console.WriteLine(p.Description);
}
Console.WriteLine();
Console.WriteLine("Connection Factory Test:");
Console.WriteLine("Get Connection using PubsConnStr in app.config");
IDbConnection conn = ProviderFactory.CreateConnectionFromConfig("PubsConnStr");
Console.WriteLine("Open Connection");
conn.Open();
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from authors";
IDataReader reader = cmd.ExecuteReader();
reader.Read();
Console.WriteLine(reader[0].ToString());
Console.ReadLine();
}