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