public BaseRepository(string connectionString, string schema)
{
_connectionString = connectionString;
_schema = schema;
if (string.IsNullOrEmpty(OracleConfiguration.TnsAdmin))
{
OracleConfiguration.TnsAdmin = @"E:\app\client\jcarlos\product\12.2.0\client_1\Network\Admin";
OracleConfiguration.WalletLocation = @"E:\app\client\jcarlos\product\12.2.0\client_1\Network\Admin";
}
DapperExt.SetSchemaName(_schema);
}
/// <summary>
/// Usar esse construtor quando a leitura da string de conexao não usuar o App.Config
/// </summary>
/// <param name="connectionStringName"></param>
/// <param name="schema"></param>
/// <param name="dataBaseDialect"></param>
/// <param name="dataBaseProvider"></param>
public DbContext(string connectionString, string schema = "Admin", string dataBaseDialect = "Oracle", string dataBaseProvider = "Oracle.ManagedDataAccess.Client") //"Npgsql"
{
_connectionFactory = DbProviderFactories.GetFactory(dataBaseProvider);
_connectionString = connectionString;
_dataBaseProvider = dataBaseProvider;
_schema = schema;
var dialeto = dataBaseDialect;
switch (dialeto)
{
case "PostgreSQL":
DapperExt.SetDialect(Dialect.PostgreSQL);
break;
case "SQLite":
DapperExt.SetDialect(Dialect.SQLite);
break;
case "MySQL":
DapperExt.SetDialect(Dialect.MySQL);
break;
case "Oracle":
DapperExt.SetDialect(Dialect.Oracle);
break;
case "SQLServer":
DapperExt.SetDialect(Dialect.SQLServer);
break;
default:
DapperExt.SetDialect(Dialect.PostgreSQL);
break;
}
DapperExt.SetSchemaName(_schema);
}