public void LikeTest() { using (var context = new ObjectOrientedDbContext()) { var stds = context.Students.Where(i => EF.Functions.Like(i.StudentSubjects.Single().Student.FirstName, "%" + i.FirstName + "%")).ToList(); } }
public void GetStudentWithNavigationPro() { using (var context = new ObjectOrientedDbContext()) { var st = context.Students .Include(i => i.StudentSubjects.Where(i => i.SubjectId == 1)) .ThenInclude(i => i.Subject); var str = st.ToQueryString(); var l = st.ToList(); } }
public void Update() { using (var context = new ObjectOrientedDbContext()) { var st = context.Students.Single(i => i.Id == 1); st.SetFirstName("Mofaggol123"); context.SaveChanges(); var st2 = context.Students.Single(i => i.Id == 1); } }
public void Insert() { using (var context = new ObjectOrientedDbContext()) { var st = new Student(firstName: "Matthias-1", lastName: "Stahl", department: "GroupWare", university: "Quipu"); context.Students.Add(st); context.SaveChanges(); var st2 = context.Students.Single(i => i.FirstName == "Matthias-1"); } }
public void Update2() { using (var context = new ObjectOrientedDbContext()) { var st = context.Students //.AsNoTracking() .Single(i => i.Id == 1); st.SetFirstName("Mofaggol123"); context.Students.Attach(st); context.Entry(st).Property(i => i.LastName).IsModified = true; context.SaveChanges(); var st1 = context.Students.Single(i => i.Id == 1); } }