protected OracleSchemaProvider GetSchemaProvider()
{
var schemaProvider = new OracleSchemaProvider(GetConnectionProvider());
Tables = schemaProvider.GetTables().ToList();
return(schemaProvider);
}
public void TestGetPrimaryKeyColumns()
{
OracleSchemaProvider provider = new OracleSchemaProvider();
provider.ConnectionString = connectionString;
var table = provider.GetPrimaryKeyColumns(string.Empty, string.Empty, "tb_News");
}
protected OracleSchemaProvider GetSchemaProvider()
{
var connectionProvider = GetConnectionProvider();
var schemaProvider = new OracleSchemaProvider(connectionProvider, new DefaultSchemaConfiguration(connectionProvider));
Tables = schemaProvider.GetTables().ToList();
return(schemaProvider);
}
public void TestGetTable()
{
OracleSchemaProvider provider = new OracleSchemaProvider();
provider.ConnectionString = connectionString;
var table = provider.GetTable(string.Empty, string.Empty, "TB_ARTICLE");
Assert.AreEqual("Id", table.Columns[0].Name);
Assert.AreEqual(DbType.String, table.Columns[0].Type);
}
private ISchemaProvider GetProvider()
{
if (Environment.Is64BitOperatingSystem)
{
Assert.Inconclusive("Cannot run tests on a 64 bit OS.");
}
var provider = new OracleSchemaProvider();
provider.SetConnectionString("Data Source=XE;User Id=northwind;Password=northwind;");
provider.Connection.Open();
return(provider);
}
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());
}
public void SetUp()
{
databaseProviderStub = MockRepository.GenerateStub<IDatabaseProvider>();
oracleSchemaProvider = new OracleSchemaProvider(databaseProviderStub);
}
protected OracleSchemaProvider GetSchemaProvider()
{
var schemaProvider = new OracleSchemaProvider(GetConnectionProvider());
Tables = schemaProvider.GetTables().ToList();
return schemaProvider;
}
public void Given()
{
_sql = GetSchemaProvider();
}
public void Given()
{
_sql = GetSchemaProvider();
}
