Ramco Ramco

Ramco Ramco

  • 442
  • 3.4k
  • 517.2k

Linq Query with 2 tables

Nov 29 2022 8:14 AM

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


Answers (2)