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