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