static void Main() { try { CultureInfo.DefaultThreadCurrentCulture = CultureInfo.InstalledUICulture; var context = new HotelContext(); using (context) { var employee = new Employee { FirstName = "Ivo", LastName = "Malakov", Title = "Boss", Notes = "Nai-dobria be" }; var customer = new Customer { FirstName = "Penka", LastName = "Penkova", PhoneNumber = "+359886000000" }; var roomStatus = new RoomStatus { Status = RoomStatuses.Free }; var roomtype = new RoomType { Type = RoomTypes.Large }; var bedtype = new BedType { Type = BedTypes.KingSize }; var room = new Room { RoomType = roomtype, BedType = bedtype, Rate = 10m, RoomStatus = roomStatus, Notes = "Mnogo hubava staqa" }; var payment = new Payment { PaymentDate = new DateTime(2016, 11, 09), AccountNumber = 1000, FirstDateOccupied = new DateTime(2016, 11, 05), LastDateOccupied = new DateTime(2016, 11, 08), TotalDays = 4, AmountCharged = 1000m, TaxRate = 1m, TaxAmount = 2m, PaymentTotal = 1003m }; var occupancie = new Occupancie { DateOccupied = new DateTime(2016, 11, 05), AccountNumber = 1000, RoomNumber = 303, RateApplied = 100m, PhoneCharge = 130m, Notes = "I am the best" }; context.Employees.Add(employee); context.Customers.Add(customer); context.RoomStatus.Add(roomStatus); context.RoomTypes.Add(roomtype); context.Rooms.Add(room); context.Payments.Add(payment); context.Occupancies.Add(occupancie); context.SaveChanges(); } } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult dbEntityValidationResult in ex.EntityValidationErrors) { foreach (DbValidationError dbValidationError in dbEntityValidationResult.ValidationErrors) { Console.WriteLine(dbValidationError.ErrorMessage); } } } }