public List <Employee> QueryInvolvingMultipleEntities()
{
#if NHIBERNATE
// need to figure out what to do here
//return new List<Employee>();
var dc0 = new NorthwindNHContext();
var dc = new NorthwindNHContext();
#elif CODEFIRST_PROVIDER
var dc0 = new NorthwindIBContext_CF();
var dc = new EFContextProvider <NorthwindIBContext_CF>();
#elif DATABASEFIRST_OLD
var dc0 = new NorthwindIBContext_EDMX();
var dc = new EFContextProvider <NorthwindIBContext_EDMX>();
#elif DATABASEFIRST_NEW
var dc0 = new NorthwindIBContext_EDMX_2012();
var dc = new EFContextProvider <NorthwindIBContext_EDMX_2012>();
#elif ORACLE_EDMX
var dc0 = new NorthwindIBContext_EDMX_Oracle();
var dc = new EFContextProvider <NorthwindIBContext_EDMX_Oracle>();
#endif
//the query executes using pure EF
var query0 = (from t1 in dc0.Employees
where (from t2 in dc0.Orders select t2.EmployeeID).Distinct().Contains(t1.EmployeeID)
select t1);
var result0 = query0.ToList();
//the same query fails if using EFContextProvider
dc0 = dc.Context;
var query = (from t1 in dc0.Employees
where (from t2 in dc0.Orders select t2.EmployeeID).Distinct().Contains(t1.EmployeeID)
select t1);
var result = query.ToList();
return(result);
}
public List <Employee> QueryInvolvingMultipleEntities()
{
//the query executes using pure EF
var dc0 = new NorthwindIBContext_EDMX_2012();
var query0 = (from t1 in dc0.Employees
where (from t2 in dc0.Orders select t2.EmployeeID).Distinct().Contains(t1.EmployeeID)
select t1);
var result0 = query0.ToList();
//the same query fails if using EFContextProvider
var dc = new EFContextProvider <NorthwindIBContext_EDMX_2012>();
var query = (from t1 in dc.Context.Employees
where (from t2 in dc.Context.Orders select t2.EmployeeID).Distinct().Contains(t1.EmployeeID)
select t1);
var result = query.ToList();
return(result);
}
public List <Employee> QueryInvolvingMultipleEntities()
{
#if NHIBERNATE
// need to figure out what to do here
return(new List <Employee>());
#else
//the query executes using pure EF
var dc0 = new NorthwindIBContext_EDMX_2012();
var query0 = (from t1 in dc0.Employees
where (from t2 in dc0.Orders select t2.EmployeeID).Distinct().Contains(t1.EmployeeID)
select t1);
var result0 = query0.ToList();
//the same query fails if using EFContextProvider
var dc = new EFContextProvider <NorthwindIBContext_EDMX_2012>();
dc0 = dc.Context;
var query = (from t1 in dc0.Employees
where (from t2 in dc0.Orders select t2.EmployeeID).Distinct().Contains(t1.EmployeeID)
select t1);
var result = query.ToList();
return(result);
#endif
}
