private void CreateRelationship(EntityContext entityContext, Entity foreignEntity, DatabaseForeignKey tableKeySchema)
{
Entity primaryEntity = GetEntity(entityContext, tableKeySchema.PrincipalTable, false, false);
string primaryName = primaryEntity.EntityClass;
string foreignName = foreignEntity.EntityClass;
string relationshipName = tableKeySchema.Name;
relationshipName = _namer.UniqueRelationshipName(relationshipName);
var foreignMembers = GetKeyMembers(foreignEntity, tableKeySchema.Columns, tableKeySchema.Name);
bool foreignMembersRequired = foreignMembers.Any(c => c.IsRequired);
var primaryMembers = GetKeyMembers(primaryEntity, tableKeySchema.PrincipalColumns, tableKeySchema.Name);
bool primaryMembersRequired = primaryMembers.Any(c => c.IsRequired);
// skip invalid fkeys
if (foreignMembers.Count == 0 || primaryMembers.Count == 0)
{
return;
}
Relationship foreignRelationship = foreignEntity.Relationships
.FirstOrDefault(r => r.RelationshipName == relationshipName && r.IsForeignKey);
if (foreignRelationship == null)
{
foreignRelationship = new Relationship
{
RelationshipName = relationshipName
};
foreignEntity.Relationships.Add(foreignRelationship);
}
foreignRelationship.IsMapped = true;
foreignRelationship.IsForeignKey = true;
foreignRelationship.Cardinality = foreignMembersRequired ? Cardinality.One : Cardinality.ZeroOrOne;
foreignRelationship.PrimaryEntity = primaryEntity;
foreignRelationship.PrimaryProperties = new PropertyCollection(primaryMembers);
foreignRelationship.Entity = foreignEntity;
foreignRelationship.Properties = new PropertyCollection(foreignMembers);
string prefix = GetMemberPrefix(foreignRelationship, primaryName, foreignName);
string foreignPropertyName = ToPropertyName(foreignEntity.EntityClass, prefix + primaryName);
foreignPropertyName = _namer.UniqueName(foreignEntity.EntityClass, foreignPropertyName);
foreignRelationship.PropertyName = foreignPropertyName;
// add reverse
Relationship primaryRelationship = primaryEntity.Relationships
.FirstOrDefault(r => r.RelationshipName == relationshipName && r.IsForeignKey == false);
if (primaryRelationship == null)
{
primaryRelationship = new Relationship {
RelationshipName = relationshipName
};
primaryEntity.Relationships.Add(primaryRelationship);
}
primaryRelationship.IsMapped = false;
primaryRelationship.IsForeignKey = false;
primaryRelationship.PrimaryEntity = foreignEntity;
primaryRelationship.PrimaryProperties = new PropertyCollection(foreignMembers);
primaryRelationship.Entity = primaryEntity;
primaryRelationship.Properties = new PropertyCollection(primaryMembers);
bool isOneToOne = IsOneToOne(tableKeySchema, foreignRelationship);
if (isOneToOne)
{
primaryRelationship.Cardinality = primaryMembersRequired ? Cardinality.One : Cardinality.ZeroOrOne;
}
else
{
primaryRelationship.Cardinality = Cardinality.Many;
}
string primaryPropertyName = prefix + foreignName;
if (!isOneToOne)
{
primaryPropertyName = RelationshipName(primaryPropertyName);
}
primaryPropertyName = ToPropertyName(primaryEntity.EntityClass, primaryPropertyName);
primaryPropertyName = _namer.UniqueName(primaryEntity.EntityClass, primaryPropertyName);
primaryRelationship.PropertyName = primaryPropertyName;
foreignRelationship.PrimaryPropertyName = primaryRelationship.PropertyName;
foreignRelationship.PrimaryCardinality = primaryRelationship.Cardinality;
primaryRelationship.PrimaryPropertyName = foreignRelationship.PropertyName;
primaryRelationship.PrimaryCardinality = foreignRelationship.Cardinality;
foreignRelationship.IsProcessed = true;
primaryRelationship.IsProcessed = true;
}
