Guest User

Untitled

a guest
Jan 18th, 2019
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. Teachers Students StudentTeacherRelations
  2. ******** ******** ***********************
  3. TeacherId StudentId TeacherId
  4. FirstName FirstName StudentId
  5. etc... etc...
  6.  
  7. public class Student
  8. {
  9. public int StudentId { get; set; }
  10. public string FirstName { get; set; }
  11. // etc
  12. public IEnumerable<Teacher> Teachers { get; }
  13. }
  14.  
  15. HomeworkAssignments Questions Answers
  16. ******************* ********* *******
  17. HomeworkAssignmentId (pk) QuestionId (pk) AnswerId (pk)
  18. ... HomeworkAssignmentId (fk) QuestionId (fk)
  19. ... StudentId (fk)
  20. ...
  21.  
  22. StudentHomeworkAssignmentRelations TeacherHomeworkAssignmentRelations
  23. ********************************** **********************************
  24. StudentId (fk) Teacherid (fk)
  25. HomeworkAssignmentId (fk) HomeworkAssignmentId (fk)
  26.  
  27. var answersToTheLastExam = context.Students
  28. .SelectMany(s => s.HomeworkAssignments)
  29. .OrderBy(ha => ha.Date) // this might need modifying to get the last one first
  30. .First(ha => ha.Questions.Count() > 0)
  31. .SelectMany(ha => ha.Questions)
  32. .SelectMany(q => q.Answers)
  33. .Where(a => a.StudentId == myId)
  34.  
  35. var result = (from orr in _context.ObjectRoleRoles
  36. inner join r in _context.Roles on orr.RolesId equals r.Id
  37. inner join or in _context.ObjectRoles on orr.ObjectRolesId equals or.Id
  38. where orr.RolesId equals 1
  39. select r).ToList();
Add Comment
Please, Sign In to add comment