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