protected OracleSchemaProvider GetSchemaProvider()
{
var schemaProvider = new OracleSchemaProvider(GetConnectionProvider());
Tables = schemaProvider.GetTables().ToList();
return(schemaProvider);
}
protected OracleSchemaProvider GetSchemaProvider()
{
var connectionProvider = GetConnectionProvider();
var schemaProvider = new OracleSchemaProvider(connectionProvider, new DefaultSchemaConfiguration(connectionProvider));
Tables = schemaProvider.GetTables().ToList();
return(schemaProvider);
}
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 OracleSchemaProvider GetSchemaProvider()
{
var schemaProvider = new OracleSchemaProvider(GetConnectionProvider());
Tables = schemaProvider.GetTables().ToList();
return schemaProvider;
}
