using System;
using System.Data;
using Mono.Data;

namespace testclient
{
    /// <summary>
    /// Summary description for Class1.
    /// </summary>
    class Class1
    {

        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();
        }

        /// <summary>
        /// The main entry point for the application.
        /// </summary>
        [STAThread]
        static void Main(string[] args)
        {
            TestProviderFactory();

        }
    }
}