This question is locked. New answers and comments are not allowed.
I have a table with two primary ki
var siteContactConfiguration = new MappingConfiguration<SiteContact>(); siteContactConfiguration.MapType(sc => new { ContactId = sc.ContactId, SiteId = sc.SiteId }).ToTable(tableName: "SiteContact"); siteContactConfiguration.HasProperty(sc => sc.ContactId).IsIdentity(); siteContactConfiguration.HasProperty(sc => sc.SiteId).IsIdentity(); siteContactConfiguration.HasIndex(sc => new { sc.ContactId, sc.SiteId }).WithName(indexName: "PRIMARY"); siteContactConfiguration. HasIndex(). WithMember(sc => sc.SiteId). Ascending(). WithName(indexName: "FK_Site_SiteContact_idx"); siteContactConfiguration. HasAssociation(sc => sc.Site). WithOpposite(s => s.SiteContacts). HasConstraint((sc, s) => sc.SiteId == s.SiteId). IsRequired(); configurations.Add(siteContactConfiguration);I need to know how to create the foreign key reference in the following configuration:
var contactConfiguration = new MappingConfiguration<Contact>(); contactConfiguration.MapType(ct => new { ContactId = ct.ContactId, FirstName = ct.FirstName, LastName = ct.LastName, Suffix = ct.Suffix, EmailAddress = ct.EmailAddress, IsPlantManager = ct.IsPlantManager, IsActive = ct.IsActive }).ToTable(tableName: "Contact"); contactConfiguration.HasProperty(ct => ct.ContactId).IsIdentity(); contactConfiguration. HasAssociation(ct => ct.SiteContact). WithOpposite(sc => sc.Contact). HasConstraint((ct, sc) => ct.ContactId == sc.ContactId). IsRequired(); configurations.Add(contactConfiguration);This is the error message I am currently receiving:
The field 'siteContact' of class 'Contact' must use nested db-column extensions in a db-ref extension as the class 'SiteContact' has a composite primary key. --> FromMetadataContainer/namespace/class[Contact]/field[siteContact]/db-column
I have searched through the online documentation, and I cannot find any reference to a nested -column extension.