internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException ex)
{
//Thrown when there is a concurrency error
//for now, just rethrow the exception
throw;
}
catch (RetryLimitExceededException ex)
{
//Thrown when max retries have been hit
//Examine the inner exception(s) for additional details
//for now, just rethrow the exception
throw;
}
catch (DbUpdateException ex)
{
//Thrown when database update fails
//Examine the inner exception(s) for additional
//details and affected objects
//for now, just rethrow the exception
throw;
}
catch (Exception ex)
{
//some other exception happened and should be handled
throw;
}
}
internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException ex)
{
//Генерируется, когда возникла ошибка, связанная с параллелизмом.
//Пока что просто сгенерировать исключение повторно
throw;
}
catch (RetryLimitExceededException ex)
{
//Генерируется, когда достигнуто максимальное количество попыток.
//Дополнительные детали можно найти во внутреннем исключении (исключениях).
//Пока что просто сгенерировать исключение повторно.
throw;
}
catch (DbUpdateException ex)
{
//Генерируется, когда обновление базы данных потерпело неудачу.
//Доп. детали и затронутые объекты можно найти во внутреннем исключении.
//Пока что просто сгенерировать исключение повторно
throw;
}
catch (Exception ex)
{
//Возникло какое-то другое исключение, которое должно быть обработано.
throw;
}
}
private int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException ex)
{
throw;
}
catch (DbUpdateException ex)
{
throw;
}
catch (Exception ex)
{
throw;
}
}
internal int SaveChages()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException ex)
{
throw;
}
catch (RetryLimitExceededException ex)
{
throw;
}
catch (DbUpdateException ex)
{
throw;
}
catch (Exception ex)
{
throw;
}
}
internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException e)
{
Console.WriteLine(e);
throw;
}
catch (RetryLimitExceededException)
{
throw;
}
catch (DbUpdateException)
{
throw;
}
catch (Exception ex)
{
throw;
}
}
internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException ex)
{
//Thrown when there is a concurrency error
throw;
}
catch (RetryLimitExceededException ex)
{
throw;
}
catch (DbUpdateException ex)
{
throw;
}
catch (Exception ex)
{
throw;
}
}
public static void InitializeData(AutoLotContext context)
{
var customers = new List <Customer>
{
new Customer {
FirstName = "Dave", LastName = "Brenner"
},
new Customer {
FirstName = "Matt", LastName = "Walton"
},
new Customer {
FirstName = "Steve", LastName = "Hagen"
},
new Customer {
FirstName = "Pat", LastName = "Walton"
},
new Customer {
FirstName = "Bad", LastName = "Customer"
}
};
customers.ForEach(x => context.Customers.Add(x));
context.SaveChanges();
var cars = new List <Inventory>
{
new Inventory {
Make = "VW", Color = "Black", PetName = "Zippy"
},
new Inventory {
Make = "Ford", Color = "Rust", PetName = "Rusty"
},
new Inventory {
Make = "Saab", Color = "Black", PetName = "Mel"
},
new Inventory {
Make = "Yugo", Color = "Yellow", PetName = "Clunker"
},
new Inventory {
Make = "BMW", Color = "Black", PetName = "Bimmer"
},
new Inventory {
Make = "BMW", Color = "Green", PetName = "Hank"
},
new Inventory {
Make = "BMW", Color = "Pink", PetName = "Pinky"
},
new Inventory {
Make = "PInto", Color = "Black", PetName = "Pete"
},
new Inventory {
Make = "Yugo", Color = "Brown", PetName = "Brownie"
},
};
context.Cars.AddRange(cars);
context.SaveChanges();
var orders = new List <Order>
{
new Order {
Car = cars[0], Customer = customers[0]
},
new Order {
Car = cars[1], Customer = customers[1]
},
new Order {
Car = cars[2], Customer = customers[2]
},
new Order {
Car = cars[3], Customer = customers[3]
},
};
orders.ForEach(x => context.Orders.Add(x));
context.SaveChanges();
context.CreditRisks.Add(
new CreditRisk
{
Id = customers[4].Id,
FirstName = customers[4].FirstName,
LastName = customers[4].LastName
});
context.Database.OpenConnection();
try
{
var tableName = context.GetTableName(typeof(CreditRisk));
var rawSqlString = $"SET IDENTITY_INSERT dbo.{tableName} ON;";
context.Database.ExecuteSqlCommand(rawSqlString);
context.SaveChanges();
rawSqlString = $"SET IDENTITY_INSERT dbo.{tableName} OFF";
context.Database.ExecuteSqlCommand(rawSqlString);
}
finally
{
context.Database.CloseConnection();
}
}
public static void InitializeData(AutoLotContext context)
{
var customers = new List <Customer>
{
new Customer {
FirstName = "Dave", LastName = "Brener"
},
new Customer {
FirstName = "Matt", LastName = "Walton"
},
new Customer {
FirstName = "Steve", LastName = "Hagen"
},
new Customer {
FirstName = "Pat", LastName = "Walton"
},
new Customer {
FirstName = "Bad", LastName = "Customer"
}
};
customers.ForEach(x => context.Customers.Add(x));
context.SaveChanges();
var cars = new List <Inventory>
{
new Inventory {
Make = "VW", Color = "Black", PetName = "Zippy"
},
new Inventory {
Make = "Ford", Color = "Rust", PetName = "Rusty"
},
new Inventory {
Make = "Saab", Color = "Black", PetName = "Mel"
},
new Inventory {
Make = "BMW", Color = "Green", PetName = "Hank"
}
};
context.Cars.AddRange(cars);
context.SaveChanges();
var orders = new List <Order>
{
new Order {
Car = cars[0], Customer = customers[0]
},
new Order {
Car = cars[1], Customer = customers[1]
},
new Order {
Car = cars[2], Customer = customers[2]
},
new Order {
Car = cars[3], Customer = customers[3]
}
};
orders.ForEach(x => context.Add(x));
context.SaveChanges();
context.CreditRisks.Add(new CreditRisk
{
Id = customers[4].Id,
FirstName = customers[4].FirstName,
LastName = customers[4].LastName
});
context.Database.OpenConnection();
try
{
// var tName = context.GetTableName(typeof(CreditRisk));
// We need dbcontext to access the models
var models = context.Model;
// Get all the entity types information
var entityTypes = models.GetEntityTypes();
// T is Name of class
var entityTypeOfT = entityTypes.First(t => t.ClrType == typeof(CreditRisk));
var tableNameAnnotation = entityTypeOfT.GetAnnotation("Relational:TableName");
var tableName = tableNameAnnotation.Value.ToString();
var command = $"SET IDENTITY_INSERT dbo.{tableName} ON;";
context.Database.ExecuteSqlCommand(command);
context.SaveChanges();
command = $"SET IDENTITY_INSERT dbo.CreditRisks OFF;";
context.Database.ExecuteSqlCommand(command);
}
finally
{
context.Database.CloseConnection();
}
}
public static void InitializeData(AutoLotContext context)
{
var customers = new List <Customer>
{
new Customer {
FirstName = "Dave", LastName = "Brenner"
},
new Customer {
FirstName = "Matt", LastName = "Walton"
},
new Customer {
FirstName = "Steve", LastName = "Hagen"
},
new Customer {
FirstName = "Pat", LastName = "Walton"
},
new Customer {
FirstName = "Bad", LastName = "Customer"
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
var cars = new List <Inventory>
{
new Inventory {
Make = "VW", Color = "Black", PetName = "Zippy"
},
new Inventory {
Make = "Ford", Color = "Rust", PetName = "Rusty"
},
new Inventory {
Make = "Saab", Color = "Black", PetName = "Mel"
},
new Inventory {
Make = "Yugo", Color = "Yellow", PetName = "Clunker"
},
new Inventory {
Make = "BMW", Color = "Black", PetName = "Bimmer"
},
new Inventory {
Make = "BMW", Color = "Green", PetName = "Hank"
},
new Inventory {
Make = "BMW", Color = "Pink", PetName = "Pinky"
},
new Inventory {
Make = "Pinto", Color = "Black", PetName = "Pete"
},
new Inventory {
Make = "Yugo", Color = "Brown", PetName = "Brownie"
},
};
context.Cars.AddRange(cars);
context.SaveChanges();
var orders = new List <Order>
{
new Order {
Car = cars[0], Customer = customers[0]
},
new Order {
Car = cars[1], Customer = customers[1]
},
new Order {
Car = cars[2], Customer = customers[2]
},
new Order {
Car = cars[3], Customer = customers[3]
},
};
context.Orders.AddRange(orders);
context.SaveChanges();
}
