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();
}