private async Task UpdateCourse()
{
using (var 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 InsertCourseAsync()
{
var dnp1 = new Course
{
Id = "DNP1",
Name = "Internet Technologies, C# and .NET",
Semester = 3,
IsElective = false
};
using (var dbContext = new ViaDbContext())
{
await dbContext.Courses.AddAsync(dnp1);
await dbContext.SaveChangesAsync();
}
}
private async Task InsertProgrammeAsync()
{
var SDJ2 = new Course()
{
Id = "SDJ2",
Name = "Software Development with Java and UML 2",
Semester = 2,
IsElective = false,
};
var GMD = new Course()
{
Id = "GMD1",
Name = "Game Development",
Semester = 6,
IsElective = true
};
var courses = new List <Course> {
GMD, SDJ2
};
var software = new Programme()
{
Location = "Horsens",
Name = "Software Technology Engineering",
ShortName = "Software",
HeadOfDepartment = "AHM",
Courses = courses
};
using (var dbContext = new ViaDbContext())
{
await dbContext.Programmes.AddAsync(software);
await dbContext.SaveChangesAsync();
}
}
