protected void Page_Load(object sender, EventArgs e) { InitializeValues(); using (var ctx = new Context()) { var listOfAllEmployees = from s in ctx.Employees select s.Name; listOfAllEmployees = listOfAllEmployees.Distinct(); var listOfLatestCourses = from s in ctx.Education select s; listOfLatestCourses = listOfLatestCourses.Take(10); var employeeId = Guid.NewGuid(); var listOfLatestCoursesForEmployee = ctx.Education.Where(s => s.EmployeeId == employeeId); } }
private void InitializeValues() { using (var ctx = new Context()) { IList<Employee> listOfEmployees = new List<Employee>(); listOfEmployees.Add(new Employee() { EmployeeId = Guid.NewGuid(), Name = "Vasya Pupkin", DateOfBith = new DateTime(1991, 12, 12) }); listOfEmployees.Add(new Employee() { EmployeeId = Guid.NewGuid(), Name = "Petya Vasechkin", DateOfBith = new DateTime(1992, 03, 23) }); listOfEmployees.Add(new Employee() { EmployeeId = Guid.NewGuid(), Name = "Kolya Petrov", DateOfBith = new DateTime(1993, 04, 04) }); foreach (Employee std in listOfEmployees) { ctx.Employees.Add(std); } IList<Training> listOfTrainings = new List<Training>(); listOfTrainings.Add(new Training() {TrainingId = Guid.NewGuid(), Name = "Math", Description = "101"}); listOfTrainings.Add(new Training() {TrainingId = Guid.NewGuid(), Name = "Physics", Description = "101"}); listOfTrainings.Add(new Training() {TrainingId = Guid.NewGuid(), Name = "Stats", Description = "102"}); foreach (Training std in listOfTrainings) { ctx.Trainings.Add(std); } IList<Education> listOfEducations = new List<Education>(); var EmployeeId = (ctx.Employees.Where (c => c.Name == "Vasya Pupkin").Select(c => c.EmployeeId)).FirstOrDefault(); var TrainingId = (ctx.Trainings.Where(c => c.Name == "Math").Select(c => c.TrainingId)).FirstOrDefault(); listOfEducations.Add(new Education() { EducationGuid = Guid.NewGuid(),EmployeeId = EmployeeId ,TrainingId = TrainingId}); EmployeeId = (ctx.Employees.Where (c => c.Name == "Kolya Petrov").Select(c => c.EmployeeId)).FirstOrDefault(); TrainingId = (ctx.Trainings.Where(c => c.Name == "Stats").Select(c => c.TrainingId)).FirstOrDefault(); listOfEducations.Add(new Education() { EducationGuid = Guid.NewGuid(), EmployeeId = EmployeeId, TrainingId = TrainingId }); listOfEducations.Add(new Education() { EducationGuid = Guid.NewGuid(), EmployeeId = EmployeeId, TrainingId = TrainingId }); EmployeeId = (ctx.Employees.Where (c => c.Name == "Petya Vasechkin").Select(c => c.EmployeeId)).FirstOrDefault(); TrainingId = (ctx.Trainings.Where(c => c.Name == "Physics").Select(c => c.TrainingId)).FirstOrDefault(); listOfEducations.Add(new Education() { EducationGuid = Guid.NewGuid(), EmployeeId = EmployeeId, TrainingId = TrainingId }); foreach (Education std in listOfEducations) { ctx.Education.Add(std); } ctx.SaveChanges(); } }