static void Main(string[] args) { DatabaseFactory.AddProviderFactory(System.Data.SqlClient.SqlClientFactory.Instance, DatabaseType.SqlServer); Dictionary <string, GetHandler> cached = new Dictionary <string, GetHandler>(); //using (var db = DatabaseFactory.Create("ZDATA")) //{ // for (int i = 0; i < 1000000; i++) // { // db.CreateCommand("insert into ") // } //} var item = new Item { Id = 1, Name = "abc", Age = 10 }; using (var db = DatabaseFactory.Create("test")) { var commd = db.CreateCommand("select * from Item where id=@id", new { id = 1 }); } //create insert sql }
static DatabaseTest() { DatabaseFactory.AddProviderFactory(System.Data.SqlClient.SqlClientFactory.Instance, DatabaseType.SqlServer); }