Owned type mapping EF Core fails when saving

Question

I want to make TableSplitting using Owned Types. I have the following model:

public class Account  {   public GUID Id { get; set; }   public string Email { get; set; }   public StreetAddress Address { get; set; } }  public class StreetAddress {   public string Name { get; set; }   public string Address { get; set; }   public string Zipcode { get; set; }   public string City { get; set; }   public string  Country { get; set; }   public Location Location { get; set; } }  public class Location {   public double Lat { get; set; }   public double Lng { get; set; } } 

And I defined my mapping of the Account like this:

public override void Map(EntityTypeBuilder<Account> map) {     // Keys     map.HasKey(x => x.Id);      // Indexs     map.HasIndex(x => x.Email).IsUnique();      // Property mappings.     map.Property(x => x.Email).HasMaxLength(255).IsRequired();      // Owned types.     map.OwnsOne(x => x.Address, cb => cb.OwnsOne(a => a.Location)); } 

When I run the migration things are working and the columns are created in the database. But when I try to insert and save an address like so:

var account1 = new Account("[email protected]", "First", "Last")     {       Address = new StreetAddress()                   {                         Address1 = "Street 1",                         City = "City",                         Zipcode = "2000",                         Country = "Denmark",                         Location = new Location()                         {                             Lat = 0.0,                             Lng = 5.5                         }                      }                 }; this.Context.Accounts.Add(account1); 

I get this error

Message "The entity of 'Account' is sharing the table 'Accounts' with 'Account.Address#StreetAddress', but there is no entity of this type with the same key value 'Id:b7662057-44c2-4f3f-2cf0-08d504db1849' that has been marked as 'Added'."

Answer 1

Consider using virtual properties. This can also be used for lazy loading in your application

 public class Account   {   public GUID Id { get; set; }   public string Email { get; set; }   public virtual StreetAddress Address { get; set; }  }  public class StreetAddress {   public string Name { get; set; }   public string Address { get; set; }   public string Zipcode { get; set; }   public string City { get; set; }   public string  Country { get; set; }   public virtual Location Location { get; set; } }  public class Location {   public double Lat { get; set; }   public double Lng { get; set; } }