1
Answer

Convert LINQ Query to CAML

Jon Joe

Jon Joe

9y
638
1
var objPendingRequest = from reqHeader in objResourceAllocation.RequestHeader.ScopeToFolder("", true).ToList()  join reqDetail in objResourceAllocation.RequestDetails.ScopeToFolder("", true) on reqHeader.Request_Header_ID equals reqDetail.Request_Header_ID into outer //Outer Join Code                                          from oreqDetail in outer.DefaultIfEmpty()  join reqSubHeader in objResourceAllocation.RoleRequestSubHeader.ScopeToFolder("", true) on reqHeader.Request_Header_ID equals reqSubHeader.Request_Header_ID into outer1 //Outer Join Code from oreqSubHeader in outer1.DefaultIfEmpty() where reqHeader.Request_Status == "Management approval/rejection pending" || reqHeader.Request_Status == "Resource Allocation manager Approval/Rejection Pending"  select new EMPDashBoardRequestItem { RequestNumber = (int)reqHeader.Request_Header_ID, };

Can anybody help me to convert above LINQ to CAML.

Please suggest .


Answers (1)