public void InsertCars(IList <Car> cars) { using (var db = new CarsContext()) { db.Cars.AddRange(cars); db.SaveChanges(); } }
public void InsertNotificationsLog(IList <NotificationLog> notifications) { using (var db = new CarsContext()) { db.NotificationsLog.AddRange(notifications); db.SaveChanges(); } }
public void UpdateCarImagePath(Car car, string path) { using (var db = new CarsContext()) { car.LocalPicturePath = path; db.Attach(car); db.Entry(car).Property(x => x.LocalPicturePath).IsModified = true; db.SaveChanges(); } }
/// <summary> /// Inserts cars to database and returns their ids. /// </summary> /// <returns>A list of car id's</returns> public IList <int> InsertCars(IList <Car> cars) { using (var db = new CarsContext()) { db.Cars.AddRange(cars); db.SaveChanges(); } return(cars.Select(c => c.Id).ToList()); }
/// <summary> /// Inserts only missing urls into database. /// </summary> /// <param name="urls"></param> public void MergeUrls(IList <string> urls) { using (var db = new CarsContext()) { var dbUrls = db.Urls.Select(x => x.Address); var missingUrls = urls.Except(dbUrls).Select(x => new Url { Address = x }); db.Urls.AddRange(missingUrls); db.SaveChanges(); } }