public void ParseAndStore(int year)
{
using (var db = new Context())
{
var lines = Read(year);
foreach (var line in lines)
{
db.BudgetLines.Add(line);
}
Console.WriteLine("Submitting {0}...", year);
db.SaveChanges();
}
}
public void ParseAndStoreAll()
{
var lines = Enumerable.Range(2003, 11).SelectMany(x => Read(x));
var context = new Context();
try
{
context.Configuration.AutoDetectChangesEnabled = false;
foreach (var line in lines)
{
context.BudgetLines.Add(line);
}
context.SaveChanges();
}
finally
{
context.Configuration.AutoDetectChangesEnabled = true;
}
}
