CODEWITHSUNDEEP
ef-core-2.0
Tommy Jakobsen
Tommy Jakobsen

Reputation: 2361

EF Core 2.0 OwnsOne column prefix

When using OwnsOne to map complex types, the sql column name is prefixed with the attribute name. Is it possible to specify the prefix name in the mapping?

This is my mapping:

e.OwnsOne(x => x.Attributes, cb =>
{
    cb.OwnsOne(a => a.Supplier);
});

I would like the sql column to be prefixed with "Attr_" Instead of "Attributes_". Is this possible?

Upvotes: 7

Views: 2891

Answers (2)

Jeremy Lakeman
Jeremy Lakeman

Reputation: 11090

You could write an extension method to override the names of all columns;

   public static void WithPrefix<T, R>(this OwnedNavigationBuilder<T, R> builder, string prefix) where T:class where R:class
   {
      foreach (var p in builder.OwnedEntityType.GetProperties())
         p.SetColumnName($"{prefix}{p.Name}");
   }

   .OwnsOne(e => e.Address, cb => cb.WithPrefix(""));

Upvotes: 5

AnorZaken
AnorZaken

Reputation: 2114

Ivan Stoev's answer from the question comments:

It has to be done through the corresponding OwnsOne builder action argument. e.g. .OwnsOne(e => e.Address, cb => { cb.Property(e => e.Postcode).HasColumnName("Postcode"); });

(Making this a community wiki, just marking the question as being answered.)

Upvotes: 2

Related Questions