static void Main(string[] args) { var sqlConnString = "Server=.;initial catalog=testdb;user id=test;password=123456;Connect Timeout=30"; var npgsqlConnString = "Server=192.168.1.10;Port=5432;Database=testdb;User Id=test;Password=123456;Pooling=true;"; var mysqlConnString = "Server=192.168.1.10;Database=testdb;Uid=test;Pwd=123456;Pooling=true;"; OrmProviderFactory.RegisterProvider(sqlConnString, new SqlServerProvider()); OrmProviderFactory.RegisterProvider(npgsqlConnString, new NpgsqlProvider()); OrmProviderFactory.RegisterProvider(mysqlConnString, new MySqlProvider()); TestHelper.Test(sqlConnString); TestHelper.Test(npgsqlConnString); //TestHelper.Test(mysqlConnString); Console.ReadLine(); }
static void Main(string[] args) { var sqlConnString = "Data Source=192.168.1.10;Initial Catalog=testdb;User Id=test;Password=123456;"; var npgsqlConnString = "Server=192.168.1.10;Port=5432;Database=testdb;User Id=test;Password=123456;Pooling=true;"; var mysqlConnString = "Server=192.168.1.10;Database=testdb;Uid=test;Pwd=123456;Pooling=true;"; OrmProviderFactory.RegisterProvider(sqlConnString, new SqlServerProvider()); OrmProviderFactory.RegisterProvider(npgsqlConnString, new NpgsqlProvider()); OrmProviderFactory.RegisterProvider(mysqlConnString, new MySqlProvider()); TestHelper.Test(sqlConnString); TestHelper.TestAsync(sqlConnString).Wait(); TestHelper.TestAsync(npgsqlConnString).Wait(); TestHelper.Test(mysqlConnString); Console.ReadLine(); }
static void Main(string[] args) { var sqlConnString = "Server=.;initial catalog=testdb;user id=test;password=123456;Connect Timeout=30"; var npgsqlConnString = "Server=192.168.1.10;Port=5432;Database=testdb;User Id=test;Password=123456;Pooling=true;"; var mysqlConnString = "Server=192.168.1.10;Database=testdb;Uid=test;Pwd=123456;Pooling=true;"; OrmProviderFactory.RegisterProvider(sqlConnString, new SqlServerProvider()); OrmProviderFactory.RegisterProvider(npgsqlConnString, new NpgsqlProvider()); OrmProviderFactory.RegisterProvider(mysqlConnString, new MySqlProvider()); string sql = @"SELECT DeptId FROM Coin_User WHERE Id=1;SELECT DeptName FROM Coin_Dept WHERE Id=1"; SqlConnection conn = new SqlConnection(sqlConnString); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess); do { if (reader.HasRows) { while (reader.Read()) { var name = reader.GetName(0); var value = reader.GetValue(0); Console.WriteLine(); } } } while (reader.NextResult()); conn.Close(); //TestHelper.Test(sqlConnString); TestHelper.TestAsync(sqlConnString).Wait(); //TestHelper.Test(npgsqlConnString); //TestHelper.Test(mysqlConnString); Console.ReadLine(); }