protected OracleConnectionProvider GetConnectionProvider()
{
var p = new OracleConnectionProvider();
p.SetConnectionString(_connectionString);
return(p);
}
public void Basic_retrival_of_tables()
{
var connectionString = ConfigurationManager.ConnectionStrings[ConnectionName].ConnectionString;
var provider = new OracleConnectionProvider();
provider.SetConnectionString(connectionString);
var connectionProvider = provider;
var schemaProvider = new OracleSchemaProvider(connectionProvider, new CustomSchemaConfiguration());
var tables = schemaProvider.GetTables().ToList();
Assert.Contains("REGIONS", tables.Select(t => t.ActualName).ToList());
Assert.Contains("DEPARTMENTS", tables.Select(t => t.ActualName).ToList());
Assert.Contains("EMPLOYEES", tables.Select(t => t.ActualName).ToList());
Assert.Contains("JOB_HISTORY", tables.Select(t => t.ActualName).ToList());
Assert.Contains("JOBS", tables.Select(t => t.ActualName).ToList());
Assert.Contains("LOCATIONS", tables.Select(t => t.ActualName).ToList());
}
protected OracleConnectionProvider GetConnectionProvider()
{
var p = new OracleConnectionProvider();
p.SetConnectionString(_connectionString);
return p;
}
