C#•10mo ago

.HasPrincipalKey -> Specify different column name

I need to use .HasPrincipalKey in Fluent, but I need the resulting column to be named differently from what the Fluent API wants to use. I don't see an option to override the column name to something different?

2 Replies

engineertdogOP•10mo ago

c#
modelBuilder.Entity<PiCollectiveDigitalSet>()
    .HasMany(e => e.Values)
    .WithOne(e => e.PiCollectiveDigitalSet)
    .HasPrincipalKey(e => e.StatesetId) // Column name for the FK should be `StatesetId` instead of `PiCollectiveDigitalSetStatesetId`

c#
modelBuilder.Entity<PiCollectiveDigitalSet>()
    .HasMany(e => e.Values)
    .WithOne(e => e.PiCollectiveDigitalSet)
    .HasPrincipalKey(e => e.StatesetId) // Column name for the FK should be `StatesetId` instead of `PiCollectiveDigitalSetStatesetId`

leowest•10mo ago

.HasColumnName("the name u want to use") https://learn.microsoft.com/en-us/ef/core/modeling/entity-properties?tabs=fluent-api%2Cwithout-nrt#column-names not sure u can name the FK thou

Gaming

Programming

.HasPrincipalKey -> Specify different column name