public void Execute() { Console.WriteLine("EntityClient"); Console.WriteLine(""); var context = new EntityContext(ConfigurationManager.ConnectionStrings[1].ConnectionString); foreach (var student in context.Students.Include(x => x.Courses)) { Console.WriteLine("{0} - {1} {2}", student.Id, student.FirstName, student.LastName); foreach (var course in student.Courses) { Console.WriteLine(" " + course.Name); } } Console.WriteLine(); foreach (var course in context.Courses.Include(x => x.Students)) { Console.WriteLine("{0} - {1}", course.Id, course.Name); foreach (var student in course.Students) { Console.WriteLine(" " + student.FirstName + " " + student.LastName); } } Console.ReadLine(); }
public void Execute() { Console.WriteLine("EntityClient"); Console.WriteLine(""); var context = new EntityContext(ConfigurationManager.ConnectionStrings[1].ConnectionString); foreach (var student in context.Students.Include(x => x.Courses)) { Console.WriteLine("{0} - {1} {2}", student.Id, student.FirstName, student.LastName); foreach (var course in student.Courses) { Console.WriteLine(" " + course.Name); } } Console.WriteLine(); foreach (var course in context.Courses.Include(x => x.Students)) { Console.WriteLine("{0} - {1}", course.Id, course.Name); foreach (var student in course.Students) { Console.WriteLine(" " + student.FirstName + " " + student.LastName); } } var studentCourses = from student in context.Students from course in student.Courses select new { FullStudentName = student.LastName + ", " + student.FirstName, CourseName = course.Name }; var castStudentCourses = studentCourses.Select(x => new Gemini(x) as dynamic); Console.WriteLine(); foreach (var studentCourse in studentCourses) { Console.WriteLine(studentCourse.FullStudentName + " - " + studentCourse.CourseName); } Console.ReadLine(); }