3 using System
.Data
.SqlClient
;
9 /// Summary description for Class1.
14 public static void TestProviderFactory()
16 Console
.WriteLine("Configured Providers:");
17 foreach (Provider p
in ProviderFactory
.Providers
)
18 Console
.WriteLine(p
.Description
);
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");
25 IDbCommand cmd
=conn
.CreateCommand();
26 cmd
.CommandText
="select * from authors";
27 IDataReader reader
=cmd
.ExecuteReader();
29 Console
.WriteLine(reader
[0].ToString());
34 /// The main entry point for the application.
37 static void Main(string[] args
)
39 TestProviderFactory();