Objective :
- LINQ
var elist = getEmp();
IEnumerable<ObjectFacotry> edb1 = from e in elist where e.job
!="SALESMAN" select e ;
IEnumerable<ObjectFacotry> edb2 = from e in elist where e.job !=
"CLERK" select e;
var edb3 = edb1.Intersect(edb2);
- LINQ
List<ObjectFacotry> empdb = getEmp();
IEnumerable<ObjectFacotry> query1 = empdb.Where(emp => emp.job !=
"PRESIDENT");
IEnumerable<ObjectFacotry> query2 = empdb.Where(emp => emp.job !=
"MANAGER ");
var query3 = query1.Intersect(query2);
- SQL
select * from emp where empno > 7600 INTERSECT
select * from emp where empno > 7800
|