samedi 16 mai 2015

Join 3 tables and select 1 coloum using linq

I have three tables Student, TimeSheet and TimeRecord.

*Talbe columns:**

  • Student : StudentId, FirstName, LastName

  • TimeSheet: TimeSheetId,StudentId, IsActive

  • TimeRecord: TimeRecordId,TimeSheetId, AddId

Table relationship:

  • Student 1:N TimeSheet (FK StudentId)
  • TimeSheet 1:N TimeRecord (FK TimeSheetId)

Student sample data:

StudentId, FirstName, LastName

  • 10 , Macro , John
  • 11 , Hiro , Edge
  • 12 , Sarah , Lemon

TimeSheet sample data:

TimeSheetId, StudentId, IsActive

  • 187 , 10 , True
  • 196 , 11 , True
  • 195 , 12 , True
  • 199, 10 , False
  • 200 , 12 , False

TimeRecord sample data:

TimeRecordId, TimeSheetId, Addid

  • 1 , 187 , 1
  • 2 , 196 , 2

  • 3 , 187 , 3

  • 4 , 187 , 4

  • 5 , 196 , 5

  • 6 , 196 , 6

  • 7 , 195 , 7

  • 8 , 199, 8

How to write linq Query to get count of the aadid for the student with id=10.

Aucun commentaire:

Enregistrer un commentaire