static void Main(string[] args)
{
WriteLine("...droping and recreate database");
/// baza testowa!
Database.SetInitializer(new DropCreateDatabaseAlways <BasicContext>());
WriteLine("...instatiate context");
using (var ctx = new BasicContext())
{
//insert
ctx.Policy.Add(new Policy
{
PolicyNumber = "ABCDEF",
Premium = 123,
Policyholder = new Policyholder
{
FirstName = "Adam",
LastName = "Testowy"
}
});
ctx.SaveChanges();
//insert i modyfikacja
ctx.Policy.Add(new Policy
{
PolicyNumber = "UKIIO",
Premium = 456,
Policyholder = new Policyholder
{
FirstName = "Jan",
LastName = "Testman"
}
});
var policy = ctx.Policy.Single(p => p.PolicyNumber == "ABCDEF");
policy.Premium = 789;
ctx.SaveChanges();
WriteLine("Zapisano!");
}
using (var read = new BasicContext())
{
var myPolicies = read.Policy.ToList();
}
WriteLine("...end");
ReadKey();
}
static void Main(string[] args)
{
WriteLine("...droping and recreate database");
/// baza testowa!
Database.SetInitializer(new CreateDatabaseIfNotExists <BasicContext>());
WriteLine("...instatiate context");
using (var ctx = new BasicContext())
{
ctx.Persons.Add(new Person("Jan", "Kowalski"));
ctx.Persons.Add(new Person("Paweł", "Nowak"));
ctx.SaveChanges();
}
WriteLine("...end");
ReadKey();
}
static void Main(string[] args)
{
WriteLine("...droping and recreate database");
/// baza testowa!
Database.SetInitializer(new CreateDatabaseIfNotExists <BasicContext>());
WriteLine("...instatiate context");
using (var ctx = new BasicContext())
{
ctx.Policy.Add(new Policy
{
Policyholder = "ABCDEF",
Premium = 123
});
try
{
ctx.SaveChanges();
WriteLine("Zapisano!");
}
catch (DbEntityValidationException validation)
{
WriteLine("Zakończono niepowodzeniem z powodu znalezionych błędów:\n");
int i = 0;
foreach (var errorsPerType in validation.EntityValidationErrors)
{
WriteLine(
$"{++i}. Walidatory typu: '{errorsPerType.Entry.Entity.GetType().Name}' zgłosił następujące problemy:\n"
);
foreach (var error in errorsPerType.ValidationErrors)
{
WriteLine($"Właściwość: '{error.PropertyName}' - {error.ErrorMessage}");
}
}
}
}
WriteLine("...end");
ReadKey();
}
