LINQ_Where_OrderBy1.htm
Code : LINQ_Where_OrderBy1.txt
Objective : where and Order by operations in SQL and LINQ
  • MySQL
    SELECT * FROM emp WHERE JOB = 'CLERK' order by ename
  • PostgreSQL:
    SELECT * FROM emp WHERE JOB = 'CLERK' order by ename      
  • LINQ
     IEnumerable<ObjectFacotry> query1 = empdb.Where(emp => emp.job.Contains("CLERK")).OrderBy(e=>e.ename);
CSharp-LINQ Visual studio:

Note the query syntax :

In the first query output, the result displayed as an unordered list, and in the second query the result was printed as an ordered list.

With command windows;

 
Where and Order by operations with MySQL and PostgreSQL
Screenshot: MySQL

PostgreSQL