C#

Question

select distinct InvoiceId,Id.ProjectCode,(select top 1 ClientRefNo from tblOrderDetail where ProjectCode = projectcode) as ClientRefNo,dbo.fnGetCustomerNameWithCode(Customer) as CustomerName,Isnull(SI.Status,'Open') as Status,CS3Invoice,Id.InvoiceDate,

(select CreatedDate from Tt_UploadDocuments where OrderNo = od.OrderNo and UploadDocumentTypeID=44) as PODUploadDate,(select CreatedDate from Tt_UploadDocuments where OrderNo = od.OrderNo and UploadDocumentTypeID=45) as HaulierInvoiceUploadDate,od.OrderNo,PODApprovedDate,Id.FinReconDatePaid as DatePaid

from dbo.InvoiceDetail Id Left join tblOrderDetail od on Id.ProjectCode = od.ProjectCode

inner join TrackingSystemTest.dbo.tblUser U on U.intUserId=OD.CreatedBy

left join Mt_SupplierInvoiceStatus SI on Id.FinReconSupplierInvoiceStatusId = SI.SupplierInvoiceStatusId

Where U.AreaId='ARE159' AND Id.ProjectCode IS NOT NULL AND OD.BaseOrder='B' AND Id.IsSupplierInvoice = 1

Order by Id.InvoiceDate DESC

 

 

I want the above query in LinQ format. Could you please help me?