public static List <string> GetStudentTutors()
{
var context = new Ef6JoinExperimentEntities();
context.Database.Log = s => Debug.WriteLine(s);
var result = context.Students
.Where(s => s.TutorId != null)
.Select(s => string.Concat(s.FirstName, " is tutored by ", s.Tutor.FirstName))
.ToList();
return(result);
}
public static string GetStudentSeatLabel()
{
var context = new Ef6JoinExperimentEntities();
context.Database.Log = s => Debug.WriteLine(s);
var result = context.Students
.Where(s => s.FirstName == "Joe" && s.LastName == "Smith")
.Select(s => s.Seat.SeatLabel).First();
return(result);
}
public static List <string> GetStudentsWithNationallyCertifiedTutor()
{
var context = new Ef6JoinExperimentEntities();
context.Database.Log = s => Debug.WriteLine(s);
var result = context.Students
.Where(s => s.Tutor.AssociationMemberships
.Any(am => am.TutorAssociation.Name
== "National Tutor Association"))
.Select(s => s.FirstName)
.ToList();
return(result);
}
public static List <string> GetClassroomSeats()
{
var context = new Ef6JoinExperimentEntities();
context.Database.Log = s => Debug.WriteLine(s);
var result = context.Classrooms
.FirstOrDefault(c => c.RoomNumber == 100)
.ClassroomSeats
.Select(cs => cs.Seat.SeatLabel)
.ToList();
result = context.ClassroomSeats
.Where(cs => cs.Classroom.RoomNumber == 100)
.Select(cs => cs.Seat.SeatLabel)
.ToList();
return(result);
}