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); }