how to write linq query of the below sql query

Hi,

you can write linq query as per below

int vDeptId = 0; // Set your desired department id here
var result = from order in tblHoOrder
             where order.DeptId == (vDeptId == 0 ? order.Id : vDeptId)
             select new 
             {
                 order.Id,
                 OrderDate = order.OrderDate.ToString("dd/MM/yyyy"),
                 order.OrderNo,
                 order.OrderValue
             };

Hello Sandip,

Assuming you have a corresponding entity class for the "tblHoOrder" table, you can write a LINQ query equivalent to the provided SQL query as follows:

int vDeptId = 0; // replace with the actual value of the @vDeptId variable

var result = from order in db.tblHoOrder
             where vDeptId == 0 || order.DeptId == vDeptId
             select new 
             {
                 order.Id,
                 OrderDate = order.OrderDate.ToString("dd/MM/yyyy"),
                 order.OrderNo,
                 order.OrderValue
             };

Thanks

Naimish Makwana