public override DbConnection CreateConnection(string connString)
{
var factory = OrmProviderFactory.GetFactory("Npgsql.NpgsqlFactory, Npgsql, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7");
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
var factory = OrmProviderFactory.GetFactory("Microsoft.Data.Sqlite.SqliteFactory, Microsoft.Data.Sqlite, Culture=neutral, PublicKeyToken=adb9793829ddae60");
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
var assemblyQualifiedName = "MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Culture=neutral, PublicKeyToken=c5687fc88969c44d";
var factory = OrmProviderFactory.GetFactory(assemblyQualifiedName, "MySql.Data.dll");
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
//TODO:Oracle官方暂时还没有提供.NET Core版本驱动，无法实现跨平台
var factory = OrmProviderFactory.GetFactory("Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Culture=neutral, PublicKeyToken=89b483f429c47342");
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
//TODO:Oracle官方暂时还没有提供.NET Core版本驱动，无法实现跨平台
var factory = OrmProviderFactory.GetFactory("MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Culture=neutral, PublicKeyToken=c5687fc88969c44d");
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
var assemblyQualifiedName = "System.Data.SQLite.SQLiteFactory, System.Data.SqlClient, Culture=neutral, PublicKeyToken=db937bc2d44ff139";
var factory = OrmProviderFactory.GetFactory(assemblyQualifiedName, "System.Data.SqlClient.dll");
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
var factory =
#if COREFX
OrmProviderFactory.GetFactory("System.Data.SqlClient.SqlClientFactory, System.Data.SqlClient, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a");
#else
OrmProviderFactory.GetFactory("System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089");
#endif
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
public override DbConnection CreateConnection(string connString)
{
#if COREFX
var assemblyQualifiedName = "System.Data.SqlClient.SqlClientFactory, System.Data.SqlClient, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a";
var assemblyFile = "System.Data.SqlClient.dll";
#else
var assemblyQualifiedName = "System.Data.SqlClient.SqlClientFactory, System.Data, Culture=neutral, PublicKeyToken=b77a5c561934e089";
var assemblyFile = "System.Data.dll";
#endif
var factory = OrmProviderFactory.GetFactory(assemblyQualifiedName, assemblyFile);
var result = factory.CreateConnection();
result.ConnectionString = connString;
return(result);
}
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();
}
