private static void UpdateIdentityContext(SeriesContext context, string name) { context.Database.OpenConnection(); try { context.Database.ExecuteSqlCommand(string.Format("SET IDENTITY_INSERT dbo.{0} ON", name)); context.SaveChanges(); context.Database.ExecuteSqlCommand(string.Format("SET IDENTITY_INSERT dbo.{0} OFF", name)); } finally { context.Database.CloseConnection(); } }
private static void FillDatabase(SeriesContext context) { try { context.Series.AddRange(GetJson <Serie>(@"Data\series.json")); UpdateIdentityContext(context, "Series"); context.Actors.AddRange(GetJson <Actor>(@"Data\actors.json")); UpdateIdentityContext(context, "Actors"); context.SerieActor.AddRange(GetJson <SerieActor>(@"Data\seriesActors.json")); context.SaveChanges(); } catch (Exception ex) { var mensaje = ex.Message; throw ex; } }