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)
|
|
|
|