LINQ_NotEqual_Intersect1.htm
Code: LINQ_NotEqual_Intersect1.txt
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
 
PostgreSQL: