public void Migrate(DougContext db) { var lines = File.ReadLines("monsters.csv").Where(line => line[0] != ',').ToList(); lines.RemoveAt(0); var items = lines.Select(CreateEntity); foreach (var item in items) { if (!db.Monsters.Any(itm => itm.Id == item.Id)) { db.Monsters.Add(item); } else { db.Entry(db.Monsters.Find(item.Id)).CurrentValues.SetValues(item); } } db.SaveChanges(); }
public void Migrate(DougContext db, string path) { var lines = File.ReadLines(path).ToList(); lines.RemoveAt(0); var items = lines.Select(CreateEntity); foreach (var item in items) { if (!db.Items.Any(itm => itm.Id == item.Id)) { db.Items.Add(item); } else { db.Entry(db.Items.Find(item.Id)).CurrentValues.SetValues(item); } } db.SaveChanges(); }