LINQ_Morethan1.htm
Code " LINQ_Morethan1.txt
Objectives:
  • PostgreSQL
    SELECT * FROM emp WHERE SAL > 2500 order by ename
  • MySQL
    SELECT * FROM emp WHERE SAL > 2500 order by ename
  • LINQ : with var
    var elist = getEmp();
    IEnumerable<ObjectFacotry> edb =
    from e in elist where e.sal > 2500 select e ;
  • LINQ
    List<ObjectFacotry> empdb = getEmp();
    IEnumerable<ObjectFacotry> query1 =
    empdb.Where(emp => emp.sal > 2500).OrderBy(e=>e.ename)
 
LINQ :

MySQL: (Intranet: http://manas9/BareBone_MySQL/Mysqli_query_Tool.php )

PostgreSQL:(Intranet: http://manas9/BareBone_PostgreSQL/postgresql_doc/psql_php_query1/psql_php_query1.PHP)