private static void Method4(ContosoUniversityEntities db, int instructorId) { var departments = db.Department.Where(x => x.InstructorID == instructorId); foreach (var item in departments) { WriteDepart(item); } }
private static void Method3(ContosoUniversityEntities db) { var persons = db.Person.Where(person => person.Enrollment.Any(enrol => enrol.Grade == 1)); foreach (var item in persons) { WritePerson(item); } }
private static void Method5(ContosoUniversityEntities db, String name) { var xs = db.Person.Where(x => x.FirstName.Contains(name) || x.LastName.Contains(name)); foreach (var item in xs) { WritePerson(item); } }
private static void Method6(ContosoUniversityEntities db) { var instructors = db.Person.Where(discri => discri.Discriminator.Equals("Instructor")); foreach (var instructor in instructors) { WriteInstructor(instructor); } }
static void Main() { using (var db = new ContosoUniversityEntities()) { Method7(db); //db.Person.Where(per => per.HireDate.HasValue == true && per.HireDate.Value.Month == 7).ForEachAsync(WritePerson); } Thread.Sleep(Timeout.Infinite); }
private static void Method1(ContosoUniversityEntities db) { Person[] list = db.Person.ToArray(); foreach (var item in list) { if (item.Discriminator == "Instructor") { WritePerson(item); } } }
private static void Method2(ContosoUniversityEntities db) { //int[] vals = new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; //var pares = vals.Where(val => val % 2 == 0); //var paresList = pares.ToList(); var instructors = from person in db.Person where person.Discriminator == "Instructor" select person; var instructors2 = db.Person.Where(person => person.Discriminator == "Instructor"); foreach (var item in instructors2) { WritePerson(item); } }
private static void Method7(ContosoUniversityEntities db) { //var instructors = db.Person // .Include(person => person.OfficeAssignment) // .Where(person => person.Discriminator.Equals("Instructor")) // .Where(person => person.OfficeAssignment != null); var instructorsIds = db.OfficeAssignment.Select(off => off.InstructorID).Distinct().ToArray(); var instructors = db.Person .Where(person => instructorsIds.Contains(person.ID)); foreach (var instructor in instructors) { WriteInstructor(instructor); } }