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); }