public static MappingRelationshipMN Parse(ManyToManyRelationshipMetadata rel, string ThisEntityLogicalName)
{
var result = new MappingRelationshipMN();
if (rel.Entity1LogicalName == ThisEntityLogicalName)
{
result.Attribute = new CrmRelationshipAttribute
{
FromEntity = rel.Entity1LogicalName,
FromKey = rel.Entity1IntersectAttribute,
ToEntity = rel.Entity2LogicalName,
ToKey = rel.Entity2IntersectAttribute,
IntersectingEntity = rel.IntersectEntityName
};
}
else
{
result.Attribute = new CrmRelationshipAttribute
{
ToEntity = rel.Entity1LogicalName,
ToKey = rel.Entity1IntersectAttribute,
FromEntity = rel.Entity2LogicalName,
FromKey = rel.Entity2IntersectAttribute,
IntersectingEntity = rel.IntersectEntityName
};
}
result.EntityRole = "null";
result.SchemaName = Naming.GetProperVariableName(rel.SchemaName);
result.DisplayName = Naming.GetProperVariableName(rel.SchemaName);
if (rel.Entity1LogicalName == rel.Entity2LogicalName && rel.Entity1LogicalName == ThisEntityLogicalName)
{
result.DisplayName = "Referenced" + result.DisplayName;
result.EntityRole = "Microsoft.Xrm.Sdk.EntityRole.Referenced";
result.IsSelfReferenced = true;
}
if (result.DisplayName == ThisEntityLogicalName)
{
result.DisplayName += "1"; // this is what CrmSvcUtil does
}
result.HybridName = Naming.GetProperVariableName(rel.SchemaName) + "_NN";
result.PrivateName = "_nn" + Naming.GetEntityPropertyPrivateName(rel.SchemaName);
result.ForeignKey = Naming.GetProperVariableName(result.Attribute.ToKey);
result.Type = Naming.GetProperVariableName(result.Attribute.ToEntity);
return(result);
}
public static MappingRelationshipMN Parse(ManyToManyRelationshipMetadata rel,
MappingRelationshipMN relationshipManyToMany,
string thisEntityLogicalName)
{
relationshipManyToMany ??= new MappingRelationshipMN();
if (rel.Entity1LogicalName != null)
{
if (rel.Entity1LogicalName == thisEntityLogicalName)
{
relationshipManyToMany.Attribute ??= new CrmRelationshipAttribute();
relationshipManyToMany.Attribute.FromEntity = rel.Entity1LogicalName ?? relationshipManyToMany.Attribute.FromEntity;
relationshipManyToMany.Attribute.FromKey = rel.Entity1IntersectAttribute
?? relationshipManyToMany.Attribute.FromKey;
relationshipManyToMany.Attribute.ToEntity = rel.Entity2LogicalName ?? relationshipManyToMany.Attribute.ToEntity;
relationshipManyToMany.Attribute.ToKey = rel.Entity2IntersectAttribute ?? relationshipManyToMany.Attribute.ToKey;
}
else
{
relationshipManyToMany.Attribute ??= new CrmRelationshipAttribute();
relationshipManyToMany.Attribute.ToEntity = rel.Entity1LogicalName ?? relationshipManyToMany.Attribute.ToEntity;
relationshipManyToMany.Attribute.ToKey = rel.Entity1IntersectAttribute ?? relationshipManyToMany.Attribute.ToKey;
relationshipManyToMany.Attribute.FromEntity = rel.Entity2LogicalName ?? relationshipManyToMany.Attribute.FromEntity;
relationshipManyToMany.Attribute.FromKey = rel.Entity2IntersectAttribute
?? relationshipManyToMany.Attribute.FromKey;
}
relationshipManyToMany.Attribute.IntersectingEntity = rel.IntersectEntityName
?? relationshipManyToMany.Attribute.IntersectingEntity;
}
relationshipManyToMany.EntityRole = "null";
if (rel.SchemaName != null)
{
relationshipManyToMany.SchemaName = rel.SchemaName;
relationshipManyToMany.DisplayName = rel.SchemaName;
relationshipManyToMany.HybridName = Naming.GetProperVariableName(rel.SchemaName, false) + "_NN";
relationshipManyToMany.PrivateName = "_nn" + Naming.GetEntityPropertyPrivateName(rel.SchemaName);
}
if (rel.Entity1LogicalName != null && rel.Entity2LogicalName != null &&
rel.Entity1LogicalName == rel.Entity2LogicalName && rel.Entity1LogicalName == thisEntityLogicalName)
{
relationshipManyToMany.DisplayName = "Referenced_" + relationshipManyToMany.DisplayName;
relationshipManyToMany.EntityRole = "Microsoft.Xrm.Sdk.EntityRole.Referenced";
relationshipManyToMany.IsSelfReferenced = true;
}
if (relationshipManyToMany.DisplayName == thisEntityLogicalName)
{
relationshipManyToMany.DisplayName += "1"; // this is what CrmSvcUtil does
}
relationshipManyToMany.ForeignKey = Naming.GetProperVariableName(relationshipManyToMany.Attribute.ToKey, false);
relationshipManyToMany.Type = relationshipManyToMany.Attribute.ToEntity;
relationshipManyToMany.MetadataId = rel.MetadataId;
return(relationshipManyToMany);
}
private static MappingEntity GetMappingEntity(EntityMetadata entityMetadata, string serverStamp,
MappingEntity entity, bool isTitleCaseLogicalName)
{
entity = entity ?? new MappingEntity();
entity.MetadataId = entityMetadata.MetadataId;
entity.ServerStamp = serverStamp;
entity.Attribute = entity.Attribute ?? new CrmEntityAttribute();
entity.TypeCode = entityMetadata.ObjectTypeCode ?? entity.TypeCode;
entity.Attribute.LogicalName = entityMetadata.LogicalName ?? entity.Attribute.LogicalName;
entity.IsIntersect = (entityMetadata.IsIntersect ?? entity.IsIntersect);
entity.Attribute.PrimaryKey = entityMetadata.PrimaryIdAttribute ?? entity.Attribute.PrimaryKey;
if (entityMetadata.DisplayName?.UserLocalizedLabel != null)
{
entity.Label = entityMetadata.DisplayName.UserLocalizedLabel.Label;
}
if (entityMetadata.SchemaName != null)
{
entity.DisplayName = Naming.GetProperEntityName(entityMetadata.SchemaName);
entity.SchemaName = entityMetadata.SchemaName;
if (entityMetadata.LogicalName != null)
{
entity.HybridName = Naming.GetProperHybridName(entityMetadata.SchemaName, entityMetadata.LogicalName);
}
}
entity.StateName = entity.HybridName + "State";
if (entityMetadata.Description != null &&
entityMetadata.Description.UserLocalizedLabel != null)
{
entity.Description = entityMetadata.Description.UserLocalizedLabel.Label;
}
var fields = (entity.Fields ?? new MappingField[0]).ToList();
foreach (var field in entityMetadata.Attributes.Where(a => a.AttributeOf == null))
{
var existingField = fields.FirstOrDefault(fieldQ => fieldQ.MetadataId == field.MetadataId);
// if it exists, remove it from the list
if (existingField != null)
{
fields.RemoveAll(fieldQ => fieldQ.MetadataId == field.MetadataId);
}
// update/create and add to list
fields.Add(MappingField.GetMappingField(field, entity, existingField, isTitleCaseLogicalName));
}
fields.ForEach(f =>
{
if (f.DisplayName == entity.DisplayName)
{
f.DisplayName += "1";
}
if (f.HybridName == entity.HybridName)
{
f.HybridName += "1";
}
}
);
AddEntityImageCrm2013(fields);
AddLookupFields(fields);
entity.Fields = fields.ToArray();
if (entityMetadata.Attributes != null)
{
// get the states enum from the metadata
entity.States = entityMetadata.Attributes.Where(a => a is StateAttributeMetadata && a.AttributeOf == null)
.Select(a => MappingEnum.GetMappingEnum(a as EnumAttributeMetadata, null, isTitleCaseLogicalName))
.FirstOrDefault() ?? entity.States;
// get all optionsets from the metadata
var newEnums = entityMetadata.Attributes
.Where(a => (a is EnumAttributeMetadata || a is BooleanAttributeMetadata) &&
a.AttributeOf == null);
// if there was never any enums previously, then just take the ones sent
if (entity.Enums == null)
{
entity.Enums = newEnums.Select(newEnum => MappingEnum.GetMappingEnum(newEnum, null, isTitleCaseLogicalName)).ToArray();
}
else
{
var existingEnums = entity.Enums.ToList();
// else, update the changed ones
newEnums.AsParallel()
.ForAll(newEnum =>
{
// has this enum been updated?
var existingEnum = existingEnums.Find(existingEnumQ => existingEnumQ.MetadataId == newEnum.MetadataId);
if (existingEnum != null)
{
// update it here
entity.Enums[existingEnums.IndexOf(existingEnum)] =
MappingEnum.GetMappingEnum(newEnum, existingEnum, isTitleCaseLogicalName);
}
else
{
// add new
existingEnums.Add(MappingEnum.GetMappingEnum(newEnum, null, isTitleCaseLogicalName));
}
});
entity.Enums = existingEnums.ToArray();
}
}
entity.PrimaryKey = entity.Fields.First(f => f.Attribute.LogicalName == entity.Attribute.PrimaryKey);
entity.PrimaryKeyProperty = entity.PrimaryKey.DisplayName;
entity.PrimaryNameAttribute = entityMetadata.PrimaryNameAttribute ?? entity.PrimaryNameAttribute;
MappingRelationship1N.UpdateCache(entityMetadata.OneToManyRelationships.ToList(), entity, entity.Fields);
MappingRelationshipN1.UpdateCache(entityMetadata.ManyToOneRelationships.ToList(), entity, entity.Fields);
MappingRelationshipMN.UpdateCache(entityMetadata.ManyToManyRelationships.ToList(), entity, entity.LogicalName);
// add a clone for self-referenced relation
var relationshipsManyToMany = entity.RelationshipsManyToMany.ToList();
var selfReferenced = relationshipsManyToMany.Where(r => r.IsSelfReferenced).ToList();
foreach (var referenced in selfReferenced)
{
if (relationshipsManyToMany.All(
rel => rel.DisplayName != "Referencing" + Naming.GetProperVariableName(referenced.SchemaName, false)))
{
var referencing = (MappingRelationshipMN)referenced.Clone();
referencing.DisplayName = "Referencing" + Naming.GetProperVariableName(referenced.SchemaName, false);
referencing.EntityRole = "Microsoft.Xrm.Sdk.EntityRole.Referencing";
relationshipsManyToMany.Add(referencing);
}
}
entity.RelationshipsManyToMany = relationshipsManyToMany.OrderBy(r => r.DisplayName).ToArray();
entity.FriendlyName = Naming.Clean(string.IsNullOrEmpty(entity.Label)
? Naming.Clean(entity.HybridName)
: Naming.Clean(entity.Label));
// generate attribute friendly names and detect duplicates
entity.Fields.AsParallel()
.ForAll(field =>
{
var cleanFieldName =
Naming.Clean(
string.IsNullOrEmpty(field.Label)
? Naming.Clean(field.DisplayName)
: Naming.Clean(field.Label))
+ (field == entity.PrimaryKey ? "Id" : "");
var isDuplicateName = entity.Fields.Count(
fieldQ => Naming.Clean(
string.IsNullOrEmpty(fieldQ.Label)
? Naming.Clean(fieldQ.DisplayName)
: Naming.Clean(fieldQ.Label))
== cleanFieldName) > 1;
isDuplicateName = isDuplicateName ||
cleanFieldName == "Attributes" ||
cleanFieldName == entity.FriendlyName ||
cleanFieldName == "LogicalName" ||
cleanFieldName == "EntityLogicalName" ||
cleanFieldName == "SchemaName" ||
cleanFieldName == "DisplayName" ||
cleanFieldName == "EntityTypeCode";
field.FriendlyName = cleanFieldName +
(isDuplicateName ? "_" + field.DisplayName : "");
});
// generate enum friendly names
entity.Enums.AsParallel()
.ForAll(enm =>
{
var attribute = entity.Fields.FirstOrDefault(field => field.LogicalName == enm.LogicalName);
enm.FriendlyName = attribute == null ? enm.DisplayName : attribute.FriendlyName;
});
return(entity);
}
public static MappingEntity Parse(EntityMetadata entityMetadata)
{
var entity = new MappingEntity();
entity.Attribute = new CrmEntityAttribute();
entity.TypeCode = entityMetadata.ObjectTypeCode;
entity.Attribute.LogicalName = entityMetadata.LogicalName;
entity.IsIntersect = (bool)entityMetadata.IsIntersect;
entity.Attribute.PrimaryKey = entityMetadata.PrimaryIdAttribute;
// entity.DisplayName = Helper.GetProperVariableName(entityMetadata.SchemaName);
entity.DisplayName = Naming.GetProperEntityName(entityMetadata.SchemaName);
entity.HybridName = Naming.GetProperHybridName(entityMetadata.SchemaName, entityMetadata.LogicalName);
entity.StateName = entity.HybridName + "State";
if (entityMetadata.Description != null)
{
if (entityMetadata.Description.UserLocalizedLabel != null)
{
entity.Description = entityMetadata.Description.UserLocalizedLabel.Label;
}
}
var fields = entityMetadata.Attributes
.Where(a => a.AttributeOf == null)
.Select(a => MappingField.Parse(a, entity)).ToList();
fields.ForEach(f =>
{
if (f.DisplayName == entity.DisplayName)
{
f.DisplayName += "1";
}
//f.HybridName = Naming.GetProperHybridFieldName(f.DisplayName, f.Attribute);
}
);
AddEnityImageCRM2013(fields);
AddLookupFields(fields);
entity.Fields = fields.ToArray();
entity.States = entityMetadata.Attributes.Where(a => a is StateAttributeMetadata).Select(a => MappingEnum.Parse(a as EnumAttributeMetadata)).FirstOrDefault();
entity.Enums = entityMetadata.Attributes
.Where(a => a is PicklistAttributeMetadata || a is StateAttributeMetadata || a is StatusAttributeMetadata || a is BooleanAttributeMetadata)
.Select(a => MappingEnum.Parse(a)).ToArray();
entity.PrimaryKey = entity.Fields.First(f => f.Attribute.LogicalName == entity.Attribute.PrimaryKey);
entity.PrimaryKeyProperty = entity.PrimaryKey.DisplayName;
entity.PrimaryNameAttribute = entityMetadata.PrimaryNameAttribute;
entity.RelationshipsOneToMany = entityMetadata.OneToManyRelationships.Select(r =>
MappingRelationship1N.Parse(r, entity.Fields)).ToArray();
entity.RelationshipsOneToMany.ToList().ForEach(r => {
var newName = r.DisplayName;
if (newName == entity.DisplayName || newName == entity.HybridName)
{
newName = r.DisplayName += "1";
}
if (entity.Fields.Any(e => e.DisplayName == newName))
{
newName = r.DisplayName += "2";
}
});
entity.RelationshipsManyToOne = entityMetadata.ManyToOneRelationships.Select(r =>
MappingRelationshipN1.Parse(r, entity.Fields)).ToArray();
entity.RelationshipsManyToOne.ToList().ForEach(r => {
var newName = r.DisplayName;
if (newName == entity.DisplayName || newName == entity.HybridName)
{
newName = r.DisplayName += "1";
}
if (entity.Fields.Any(e => e.DisplayName == newName))
{
newName = r.DisplayName += "2";
}
});
var RelationshipsManyToMany = entityMetadata.ManyToManyRelationships.Select(r => MappingRelationshipMN.Parse(r, entity.LogicalName)).ToList();
var selfReferenced = RelationshipsManyToMany.Where(r => r.IsSelfReferenced).ToList();
foreach (var referecned in selfReferenced)
{
var referencing = (MappingRelationshipMN)referecned.Clone();
referencing.DisplayName = "Referencing" + Naming.GetProperVariableName(referecned.SchemaName);
referencing.EntityRole = "Microsoft.Xrm.Sdk.EntityRole.Referencing";
RelationshipsManyToMany.Add(referencing);
}
RelationshipsManyToMany.ForEach(r => {
var newName = r.DisplayName;
if (newName == entity.DisplayName || newName == entity.HybridName)
{
newName = r.DisplayName += "1";
}
if (entity.Fields.Any(e => e.DisplayName == newName))
{
newName = r.DisplayName += "2";
}
});
entity.RelationshipsManyToMany = RelationshipsManyToMany.OrderBy(r => r.DisplayName).ToArray();
return(entity);
}