Jon Joe

Jon Joe

  • 1.5k
  • 94
  • 7.5k

Convert LINQ query to CAML

Sep 13 2014 3:11 AM
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 to convert above LINQ code to CAML ?