public void GetTableData()
{
OraDataContext ContextOra = new OraDataContext(new OraEntities("ECA"), "Gibbonsbr");
List <ALL_TABLES> lstAllTables = ContextOra.ALL_TABLESRepository.FindBy(x => x.OWNER == "ODM").ToList();
Assert.IsTrue(lstAllTables.Count() > 0);
}
public void GetTableColumn()
{
OraDataContext ContextOra = new OraDataContext(new OraEntities("ECA"), "Gibbonsbr");
List <ALL_TAB_COLS> lstTabCols = ContextOra.ALL_TAB_COLSRepository
.FindBy(x => x.OWNER == "STU").Where(x => x.TABLE_NAME == "COURSE").ToList();
Assert.IsTrue(lstTabCols.Count() > 0);
}
private void LoadDBAGridData()
{
if (this.rmccDatabase.EditorControl.CurrentRow.Cells["colDatabaseID"] != null)
{
string strDatabaseID = rmccDatabase.EditorControl.CurrentRow.Cells["colDatabaseID"].Value.ToString();
String strDatabaseName = this.rmccDatabase.EditorControl.CurrentRow.Cells["colDatabaseName"].Value.ToString();
ContextOra = new OraDataContext(new OraEntities(strDatabaseName), Utility.UserName);
List <OracleDataMoverOraEF.EF.DBA_DataPump_Jobs> lstDBAJobs = ContextOra.GetDBADataPumpJobs();
rgvDBAJobs.DataSource = lstDBAJobs;
}
}
public void CheckConstraints()
{
OraDataContext ContextOra = new OraDataContext(new OraEntities("ECA"), "Gibbonsbr");
List <ALL_CONSTRAINTS> lstConstraints = ContextOra.ALL_CONSTRAINTSRepository
.FindBy(x => x.OWNER == "ABRENNER").ToList();
List <ALL_CONS_COLUMNS> lstAllConsCols = ContextOra.ALL_CONS_COLUMNSRepository
.FindBy(x => x.OWNER == "ABRENNER").ToList();
var query = from c in lstConstraints
join o in lstAllConsCols on c.CONSTRAINT_NAME equals o.CONSTRAINT_NAME
select new { c.CONSTRAINT_NAME, c.CONSTRAINT_TYPE, c.TABLE_NAME, o.COLUMN_NAME };
foreach (var group in query)
{
Console.WriteLine("{0} bought {1}", group.CONSTRAINT_NAME, group.COLUMN_NAME);
}
}
public ALL_TAB_COLSRepository(OraDataContext context)
: base(context)
{
}
public ALL_CONSTRAINTSRepository(OraDataContext context)
: base(context)
{
}
public ALL_CONS_COLUMNSRepository(OraDataContext context)
: base(context)
{
}
public ALL_USERSRepository(OraDataContext context)
: base(context)
{
}
