public void UpdateIsOK() { var context = new CarContext(); var testContext = new EFRepository<Car,int>(context); var all = context.Car.ToList(); all.ForEach(r => testContext.Delete(r)); testContext.Save(); var car = new Car() { CarName = "Ford", CarPrice = 100000 }; testContext.Insert(car); testContext.Save(); car.CarName = "Ford1"; car.CarPrice = 100000 - 1; testContext.Update(car); testContext.Save(); var cars = context.Car.ToList(); Assert.AreEqual(cars.Count, 1); Assert.AreEqual(cars.FirstOrDefault().CarName, "Ford1"); Assert.AreEqual(cars.FirstOrDefault().CarPrice, 100000 - 1); }
public void TestUpdate() { using (CarContext context = new CarContext()) { var testContext = new EFRepository<Car, int>(context); var car = context.Car.AsNoTracking().AsQueryable().ToList(); //context.Car.Where(x => x.ID == 1).Update(x => new Car { CarPrice = 12 }); //testContext.Update(x => x.ID == 1, x => new Car { CarPrice = 12 }); context.SaveChanges(); } }
public void TestMethod1() { try { var context = new CarContext(); var testContext = new EFRepository<Car, int>(context); var all = context.Car.ToList(); var cart = testContext.Get(all.First().ID); } catch { } }
public void ContextIsOK() { var context = new CarContext(); var all = context.Car.ToList(); all.ForEach(r => context.Car.Remove(r)); context.SaveChanges(); context.Car.Add(new Car() { CarName = "Ford", CarPrice = 100000 }); context.SaveChanges(); var cars = context.Car.ToList(); Assert.AreEqual(cars.Count, 1); Assert.AreEqual(cars.FirstOrDefault().CarName, "Ford"); Assert.AreEqual(cars.FirstOrDefault().CarPrice, 100000); }
public void GetCountDeleteIsOK() { var context = new CarContext(); var testContext = new EFRepository<Car,int>(context); var all = context.Car.ToList(); all.ForEach(r => testContext.Delete(r)); testContext.Save(); Assert.AreEqual(context.Car.ToList().Count, 0); context.Car.Add(new Car() { CarName = "Ford", CarPrice = 100000 }); testContext.Save(); var cars = context.Car.ToList(); Assert.AreEqual(testContext.Count(), 1); Assert.AreEqual(testContext.Get(r => r.CarPrice == 100000).CarName, "Ford"); }
public void MyTestMethod() { var context = new CarContext(); var testContext = new EFRepository<Car, int>(context); context.Car.ToList().ForEach(r => testContext.Delete(r)); testContext.Save(); var car = new Car() { CarName = "Ford", CarPrice = 100000 }; var car1 = new Car() { CarName = "Toyota", CarPrice = 100000 }; testContext.Insert(car); testContext.Insert(car1); testContext.Save(); //var cars = testContext.GetList(); //Assert.AreEqual(cars.Count, 1); //Assert.AreEqual(cars.FirstOrDefault().CarName, "Ford"); //Assert.AreEqual(cars.FirstOrDefault().CarPrice, 100000); }
public void GetAllOrderByIsOK() { var context = new CarContext(); var testContext = new EFRepository<Car,int>(context); context.Car.ToList().ForEach(r => testContext.Delete(r)); testContext.Save(); var car = new Car() { CarName = "Ford", CarPrice = 100000 }; var car1 = new Car() { CarName = "Toyota", CarPrice = 99999 }; testContext.Insert(car); testContext.Insert(car1); testContext.Save(); var cars = testContext.GetList(r => r.CarPrice == 100000, null, "").ToList(); Assert.AreEqual(cars.Count, 1); Assert.AreEqual(cars.FirstOrDefault().CarName, "Ford"); Assert.AreEqual(cars.FirstOrDefault().CarPrice, 100000); }
public void Delete1IsOK() { var context = new CarContext(); var testContext = new EFRepository<Car,int>(context); var all = context.Car.ToList(); all.ForEach(r => testContext.Delete(r)); testContext.Save(); var car = new Car() { CarName = "Ford", CarPrice = 100000 }; testContext.Insert(car); testContext.Save(); testContext.Delete(r => r.ID == car.ID); testContext.Save(); var cars = context.Car.ToList(); Assert.AreEqual(cars.Count, 0); }
public void Update1IsOK() { var context = new CarContext(); var testContext = new EFRepository<Car,int>(context); var all = context.Car.ToList(); all.ForEach(r => testContext.Delete(r)); testContext.Save(); var car = new Car() { CarName = "Ford", CarPrice = 100000 }; testContext.Insert(car); testContext.Save(); car.CarPrice = 99999; car.CarName = "Ford1"; testContext.Update(car, x => new { x.CarPrice }); testContext.Save(); var cars = testContext.GetDbSet().AsNoTracking().ToList();//OK var cars1 = testContext.GetDbSet().ToList();//error Assert.AreEqual(cars.Count, 1); Assert.AreEqual(cars.FirstOrDefault().CarName, "Ford"); Assert.AreEqual(cars.FirstOrDefault().CarPrice, 100000 - 1); }