Using Dynamic predicates (Linq)
-
Hi, This is my linq query, I wanted this query to dynamilcally fetch the fields mentioned after select{----------------------}; var res1 = from tbltrans in ctx.tblTransferDatas join tblemp in ctx.tblEmployees on tbltrans.EmployeeID equals tblemp.EmployeeID join tbldpt in ctx.tblDepts on tblemp.DeptID equals tbldpt.DeptID join tbldiv in ctx.tblDivisions on tbldpt.DivisionID equals tbldiv.DivisionID join tblreg in ctx.tblRegions on tbldiv.RegionID equals tblreg.RegionID join sites in ctx.tblSites on tbltrans.Site_No equals sites.Site_No join ters in ctx.tblTerminals on tbltrans.Ter_No equals ters.TerNo select new { tbltrans.TransferData_ID, tbltrans.ActionDate, tbltrans.CardSnr, tbltrans.Updated_to_Card_By_CP, tbltrans.Updated_to_Card_By_Ter, tbltrans.Deleted_By_CP, tbltrans.SiteTer_Type, tbltrans.Site_No, tbltrans.Ter_No, tblemp.BadgeNo, tblemp.FullName , tbldpt.DeptID, Dept = tblreg.RegionName + "/" + tbldiv.DivisionName + "/" + tbldpt.DeptName, sites.Site_Name, ters.Terminal_Name }; How to write and add predicates to the main query. I wanted to add a dynamic predicate before select,I would appreciate any early replies. Many thanks in advance. regards Sajid