private async Task UpdateCourse() { using (ViaDBContext dbContext = new ViaDBContext()) { IQueryable <Course> result = dbContext.Courses.Where(c => c.Id.Equals("DNP1")); Course dnp = await dbContext.Courses.FirstAsync(c => c.Id.Equals("DNP1")); Programme softwareProgramme = await dbContext.Programmes. Include(p => p.Courses). FirstAsync(p => p.ShortName.Equals("Software")); softwareProgramme.Courses.Add(dnp); dbContext.Update(softwareProgramme); await dbContext.SaveChangesAsync(); } }
private async Task InsertCourse() { Course dnp1 = new Course { Id = "DNP1", Name = "Internet Technologies, C# and .NET", Semester = 3, IsElective = false, ECTS = 5 }; using (ViaDBContext dbContext = new ViaDBContext()) { await dbContext.Courses.AddAsync(dnp1); await dbContext.SaveChangesAsync(); } }
private async Task InsertProgramme() { Course SDJ2 = new Course { Id = "SDJ2", Name = "Software Development with Java and UML 2", Semester = 2, IsElective = false, ECTS = 10 }; Course GMD = new Course { Id = "GMD1", Name = "Game Development", Semester = 6, IsElective = true, ECTS = 5 }; List <Course> courses = new List <Course> { GMD, SDJ2 }; Programme software = new Programme { Location = "Horsens", Name = "Software Technology Engineering", ShortName = "Software", HeadOfDepartment = "AHM", Courses = courses }; using (ViaDBContext dbContext = new ViaDBContext()) { await dbContext.Programmes.AddAsync(software); await dbContext.SaveChangesAsync(); } }