public void CanInsertAStudentIntoDatabase() { using (var dbContext = new StudentManagementDemoTestDbContext()) { //dbContext.Database.EnsureDeleted(); dbContext.Database.EnsureCreated(); var studentId = Guid.NewGuid(); dbContext.Students.Add( new Student { Id = studentId, Name = "Black Mamba", Email = "*****@*****.**", IsDeleted = 0 }); dbContext.SaveChanges(); var student = dbContext.Students.Where(s => s.Id == studentId).FirstOrDefault(); Assert.Equal(studentId, student.Id); } }
public void CanDeleteAStudentInDatabase() { using (var dbContext = new StudentManagementDemoTestDbContext()) { dbContext.Database.EnsureCreated(); var student = dbContext.Students.Where(s => s.Name.Contains("Mamba")).FirstOrDefault(); student.IsDeleted = 1; dbContext.Students.Update(student); dbContext.SaveChanges(); var updatedStudent = dbContext.Students.Where(s => s.Id == student.Id).FirstOrDefault(); Assert.Equal(1, student.IsDeleted); } }
public void CanUpdateAStudentInDatabase() { using (var dbContext = new StudentManagementDemoTestDbContext()) { dbContext.Database.EnsureCreated(); var student = dbContext.Students.Where(s => s.Name.Contains("Mamba")).FirstOrDefault(); var originalEmail = student.Email; var emailToUpdate = "*****@*****.**"; student.Email = emailToUpdate; dbContext.Students.Update(student); dbContext.SaveChanges(); var updatedStudent = dbContext.Students.Where(s => s.Id == student.Id).FirstOrDefault(); Assert.Equal(emailToUpdate, updatedStudent.Email); } }