public static void AddCustomer(Customers customer)
{
try
{
_log.Info(l => l("Start adding a new customer with PK: {0}", customer.CustomerID));
using (var dbContext = new NorthwindDbContext())
{
var validation = dbContext.GetValidationErrors();
dbContext.Customers.Add(customer);
dbContext.SaveChanges();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
_log.Error(l => l("Property: {0} Error: {1}", validationError.PropertyName,
validationError.ErrorMessage));
}
}
}
catch (ExecutionEngineException ex)
{
throw ex;
}
}
public static List<Customers> GetCustomers()
{
using (var dbContext = new NorthwindDbContext())
{
return dbContext.Customers.ToList();
}
}
static void Main(string[] args)
{
_log.Info(l => l("Start"));
using (var dbContext = new NorthwindDbContext())
{
var customers = dbContext.Customers.ToList();
foreach (var c in customers)
{
_log.Info(l => l("CustomerID: {0}, CompanyName: {1}, ContactName: {2}", c.CustomerID,
c.CompanyName, c.ContactName));
//Console.WriteLine(string.Format("CustomerID: {0}, CompanyName: {1}, ContactName: {2}", c.CustomerID,
// c.CompanyName, c.ContactName));
}
}
_log.Info(l => l("Stop"));
}
