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