mcs/class/Mono.Data/test/test.cs

   1 using System;
   2 using System.Data;
   3 using System.Data.SqlClient;
   4 using Mono.Data;
   5
   6 namespace testclient
   7 {
   8         /// <summary>
   9         /// Summary description for Class1.
  10         /// </summary>
  11         class Class1
  12         {
  13
  14                 public static void TestProviderFactory()
  15                 {
  16                         Console.WriteLine("Configured Providers:");
  17                         foreach (Provider p in ProviderFactory.Providers)
  18                                 Console.WriteLine(p.Description);
  19                         Console.WriteLine();
  20                         Console.WriteLine("Connection Factory Test:");
  21                         Console.WriteLine("Get Connection using PubsConnStr in app.config");
  22                         IDbConnection conn=ProviderFactory.CreateConnectionFromConfig("PubsConnStr");
  23                         Console.WriteLine("Open Connection");
  24                         conn.Open();
  25                         IDbCommand cmd=conn.CreateCommand();
  26                         cmd.CommandText="select * from authors";
  27                         IDataReader reader=cmd.ExecuteReader();
  28                         reader.Read();
  29                         Console.WriteLine(reader[0].ToString());
  30                         Console.ReadLine();
  31                 }
  32
  33                 /// <summary>
  34                 /// The main entry point for the application.
  35                 /// </summary>
  36                 [STAThread]
  37                 static void Main(string[] args)
  38                 {
  39                         TestProviderFactory();
  40
  41                 }
  42         }
  43 }