Hi
I have below linq query & i want to get data from another table using below query linking the two on Department,ShiftDate,Location.
From second table i want to get NoOfDays column value
Department,ShiftDate values are to be taken from variables Dept,ShiftDate
var Result = from t in context.Masters
where t.Active == true
&& t.Deleted == false
&& (t.Department == Dept)
select new { t.ID,t.Department,t.LocationID,t.Location,t.MachineNumber,t.MachineName };
Thanks
Jignesh KumarPosted Nov 29, 2022, 9:50 AM
Hi Ramco,
You can use join in linq,
https://www.c-sharpcorner.com/UploadFile/33b051/joins-in-linq/
Aravind GovindarajPosted Nov 29, 2022, 9:02 AM
Hi Ramco, you have to use join operator . pleae find the reference for the same
https://www.tutorialsteacher.com/linq/linq-joining-operator-join