public static void InsertHouseModel(HouseModel model) { using (var db = new SystemDBContext()) { db.Houses.Add(model); db.SaveChanges(); } }
public static void UpdateDatabase(string csv_file_path) { var data = getCSVContent(csv_file_path); var houseModel = GetHouseModel(data); using (var db = new SystemDBContext()) { if (!CheckTableExists()) return; var dbHouses = db.Houses.Select(x => x.Hash).ToList(); foreach (var house in houseModel.Where(house => !dbHouses.Contains(house.Hash))) { db.Houses.Add(house); } db.SaveChanges(); } }