public Address Create(Address address) { //_ctx.DetachAll(); //_ctx.Attach(address.City).State = EntityState.Unchanged; var addressEntry = _ctx.Add(new AddressSql { Id = address.Id, Additional = address.Additional, CityId = address.City?.ZipCode ?? 0, StreetName = address.StreetName, StreetNr = address.StreetNr }); _ctx.SaveChanges(); return(new Address() { Id = addressEntry.Entity.Id, Additional = addressEntry.Entity.Additional, City = new City() { ZipCode = addressEntry.Entity.CityId }, StreetName = addressEntry.Entity.StreetName, StreetNr = addressEntry.Entity.StreetNr }); }
public City Create(City city) { try { var cityEntry = _ctx.Add(_mapper.Map <City, CitySql>(city)); _ctx.SaveChanges(); var newCity = cityEntry.Entity; return(_mapper.Map <CitySql, City>(newCity)); } catch (Exception e) { throw new DataSourceException(e.InnerException?.Message); } }
public static void Seed(CustomerAppDBContext context) { context.Customers.Add(new Customer { Firstname = "Lars", Lastname = "Bilde", Address = "Uhhahahstrasse1", EMail = "jumbaimba.org" } ); context.SaveChanges(); }
public Customer Create(Customer customer) { //_ctx.Attach(customer.Address).State = EntityState.Unchanged; var customerEntity = new CustomerSql { FirstName = customer.FirstName, LastName = customer.LastName, AddressId = customer.Address.Id }; var customerEntry = _ctx.Add(customerEntity); _ctx.SaveChanges(); return(new Customer { Id = customerEntry.Entity.Id, LastName = customerEntry.Entity.LastName, FirstName = customerEntry.Entity.FirstName, Address = new Address { Id = customer.Address.Id } }); }
public Country Create(Country country) { var entry = _ctx.Countries.Add(new CountrySql { Id = country.Id, Name = country.Name }); _ctx.SaveChanges(); return(new Country { Id = entry.Entity.Id, Name = entry.Entity.Name }); }