protected virtual void CreateConnection(string providerName)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "System.Data.SqlClient";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, null, null);
_connection = fac.CreateConnection(); // new SqlConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
string collationString = null;
var collation = this.ExecuteScalar("SELECT DATABASEPROPERTYEX('" + _connection.Database + "', 'Collation')");
if (collation != null)
{
collationString = collation.ToString();
}
if (string.IsNullOrWhiteSpace(collationString))
{
collationString = "Latin1_General_CI_AS";
}
this.Dialect.RegisterProperty(ColumnProperty.CaseSensitive, "COLLATE " + collationString.Replace("_CI_", "_CS_"));
}
public IngresTransformationProvider(Dialect dialect, string connectionString, string scope, string providerName)
: base(dialect, connectionString, null, scope)
{
if (string.IsNullOrEmpty(providerName)) providerName = "Ingres.Client";
var fac = DbProviderFactoriesHelper.GetFactory(providerName, null, null);
_connection = fac.CreateConnection();
_connection.ConnectionString = _connectionString;
this._connection.Open();
}
protected virtual void CreateConnection(string providerName)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "System.Data.SQLite";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, "System.Data.SQLite", "System.Data.SQLite.SQLiteFactory");
_connection = fac.CreateConnection(); // new SQLiteConnection(_connectionString);
_connection.ConnectionString = _connectionString;
_connection.Open();
}
protected override void CreateConnection(string providerName)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "System.Data.OracleClient";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, null, null);
_connection = fac.CreateConnection(); // new OracleConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
}
protected virtual void CreateConnection(string providerName)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "Oracle.DataAccess.Client";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, null, null);
_connection = fac.CreateConnection(); // new OracleConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
}
public FirebirdTransformationProvider(Dialect dialect, string connectionString, string scope, string providerName)
: base(dialect, connectionString, null, scope)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "FirebirdSql.Data.FirebirdClient";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, "FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FirebirdClientFactory");
_connection = fac.CreateConnection();
_connection.ConnectionString = _connectionString;
this._connection.Open();
}
public PostgreSQLTransformationProvider(Dialect dialect, string connectionString, string defaultSchema, string scope, string providerName)
: base(dialect, connectionString, defaultSchema, scope)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "Npgsql";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, "Npgsql", "Npgsql.NpgsqlFactory");
_connection = fac.CreateConnection(); //new NpgsqlConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
}
public MySqlTransformationProvider(Dialect dialect, string connectionString, string scope, string providerName)
: base(dialect, connectionString, null, scope) // we ignore schemas for MySql (schema == database for MySql)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "MySql.Data.MySqlClient";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, "MySql.Data", "MySql.Data.MySqlClient.MySqlClientFactory");
_connection = fac.CreateConnection(); //new MySqlConnection(_connectionString) {ConnectionString = _connectionString};
_connection.ConnectionString = _connectionString;
_connection.Open();
}
public MariaDBTransformationProvider(Dialect dialect, string connectionString, string scope, string providerName)
: base(dialect, connectionString, scope, providerName)
{
if (string.IsNullOrEmpty(providerName))
{
providerName = "MySql.Data.MySqlClient";
}
var fac = DbProviderFactoriesHelper.GetFactory(providerName, "MySql.Data", "MySql.Data.MySqlClient.MySqlClientFactory");
_connection = fac.CreateConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
}