Dynamic use of Restriction Operator in a linq query
-
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 };I wanted to add a dynamic where clause before select,I would appreciate any early replies. Many thanks in advance. regards Sajid