/// <summary> /// All navigation properties defined in this class /// </summary> /// <param name="ignore">Associations to remove from the result</param> /// <returns>All navigation properties defined in this class, except those listed in the parameter</returns> public IEnumerable <NavigationProperty> LocalNavigationProperties(params Association[] ignore) { List <NavigationProperty> sourceProperties = Association.GetLinksToTargets(this) .Except(ignore) .Select(NavigationProperty.LinkToTarget) .ToList(); List <NavigationProperty> targetProperties = Association.GetLinksToSources(this) .Except(ignore) .OfType <BidirectionalAssociation>() .Select(NavigationProperty.LinkToSource) .ToList(); targetProperties.AddRange(Association.GetLinksToSources(this) .Except(ignore) .OfType <UnidirectionalAssociation>() .Select(NavigationProperty.LinkToSource)); int suffix = 0; foreach (NavigationProperty navigationProperty in targetProperties.Where(x => x.PropertyName == null)) { navigationProperty.PropertyName = $"_{navigationProperty.ClassType.Name.ToLower()}{suffix++}"; navigationProperty.ConstructorParameterOnly = true; } return(sourceProperties.Concat(targetProperties)); }
/// <summary> /// All navigation properties defined in this class /// </summary> /// <param name="ignore">Associations to remove from the result</param> /// <returns>All navigation properties defined in this class, except those listed in the parameter</returns> public IEnumerable <NavigationProperty> LocalNavigationProperties(params Association[] ignore) { List <NavigationProperty> sourceProperties = Association.GetLinksToTargets(this) .Except(ignore) .Select(x => new NavigationProperty { Cardinality = x.TargetMultiplicity , ClassType = x.Target , AssociationObject = x , PropertyName = x.TargetPropertyName , Summary = x.TargetSummary , Description = x.TargetDescription , CustomAttributes = x.TargetCustomAttributes , DisplayText = x.TargetDisplayText , IsAutoProperty = true , ImplementNotify = x.TargetImplementNotify , FKPropertyName = x.TargetRole == EndpointRole.Principal ? x.FKPropertyName : null }) .ToList(); List <NavigationProperty> targetProperties = Association.GetLinksToSources(this) .Except(ignore) .OfType <BidirectionalAssociation>() .Select(x => new NavigationProperty { Cardinality = x.SourceMultiplicity , ClassType = x.Source , AssociationObject = x , PropertyName = x.SourcePropertyName , Summary = x.SourceSummary , Description = x.SourceDescription , CustomAttributes = x.SourceCustomAttributes , DisplayText = x.SourceDisplayText , IsAutoProperty = true , ImplementNotify = x.SourceImplementNotify , FKPropertyName = x.SourceRole == EndpointRole.Principal ? x.FKPropertyName : null }) .ToList(); targetProperties.AddRange(Association.GetLinksToSources(this) .Except(ignore) .OfType <UnidirectionalAssociation>() .Select(x => new NavigationProperty { Cardinality = x.SourceMultiplicity , ClassType = x.Source , AssociationObject = x , PropertyName = null , FKPropertyName = x.SourceRole == EndpointRole.Principal ? x.FKPropertyName : null })); int suffix = 0; foreach (NavigationProperty navigationProperty in targetProperties.Where(x => x.PropertyName == null)) { navigationProperty.PropertyName = $"_{navigationProperty.ClassType.Name.ToLower()}{suffix++}"; navigationProperty.ConstructorParameterOnly = true; } return(sourceProperties.Concat(targetProperties)); }
public IEnumerable <NavigationProperty> LocalNavigationProperties(params Association[] ignore) { List <NavigationProperty> sourceProperties = Association.GetLinksToTargets(this) .Except(ignore) .Select(x => new NavigationProperty { Cardinality = x.TargetMultiplicity, ClassType = x.Target, AssociationObject = x, PropertyName = x.TargetPropertyName, Summary = x.TargetSummary, Description = x.TargetDescription }) .ToList(); List <NavigationProperty> targetProperties = Association.GetLinksToSources(this) .Except(ignore) .OfType <BidirectionalAssociation>() .Select(x => new NavigationProperty { Cardinality = x.SourceMultiplicity, ClassType = x.Source, AssociationObject = x, PropertyName = x.SourcePropertyName, Summary = x.SourceSummary, Description = x.SourceDescription }) .ToList(); targetProperties.AddRange(Association.GetLinksToSources(this) .Except(ignore) .OfType <UnidirectionalAssociation>() .Select(x => new NavigationProperty { Cardinality = x.SourceMultiplicity, ClassType = x.Source, AssociationObject = x, PropertyName = null })); int index = 0; foreach (NavigationProperty navigationProperty in targetProperties.Where(x => x.PropertyName == null)) { navigationProperty.PropertyName = $"_{navigationProperty.ClassType.Name.ToLower()}{index++}"; navigationProperty.ConstructorParameterOnly = true; } return(sourceProperties.Concat(targetProperties)); }
public override void ElementPropertyChanged(ElementPropertyChangedEventArgs e) { base.ElementPropertyChanged(e); ModelClass element = (ModelClass)e.ModelElement; if (element.IsDeleted) { return; } Store store = element.Store; Transaction current = store.TransactionManager.CurrentTransaction; if (current.IsSerializing || ModelRoot.BatchUpdating) { return; } if (Equals(e.NewValue, e.OldValue)) { return; } List <string> errorMessages = EFCoreValidator.GetErrors(element).ToList(); switch (e.DomainProperty.Name) { case "DbSetName": { string newDbSetName = (string)e.NewValue; if (element.IsDependentType) { if (!string.IsNullOrEmpty(newDbSetName)) { element.DbSetName = string.Empty; } } else { if (string.IsNullOrEmpty(newDbSetName)) { element.DbSetName = MakeDefaultName(element.Name); } if (current.Name.ToLowerInvariant() != "paste" && (string.IsNullOrWhiteSpace(newDbSetName) || !CodeGenerator.IsValidLanguageIndependentIdentifier(newDbSetName))) { errorMessages.Add($"DbSet name '{newDbSetName}' isn't a valid .NET identifier."); } else if (store.GetAll <ModelClass>() .Except(new[] { element }) .Any(x => x.DbSetName == newDbSetName)) { errorMessages.Add($"DbSet name '{newDbSetName}' already in use"); } } break; } case "ImplementNotify": { bool newImplementNotify = (bool)e.NewValue; if (newImplementNotify) { List <string> nameList = element.Attributes.Where(x => x.AutoProperty).Select(x => x.Name).ToList(); if (nameList.Any()) { string names = nameList.Count > 1 ? string.Join(", ", nameList.Take(nameList.Count - 1)) + " and " + nameList.Last() : nameList.First(); string verb = nameList.Count > 1 ? "is an autoproperty" : "are autoproperties"; WarningDisplay.Show($"{names} {verb}, so will not participate in INotifyPropertyChanged messages"); } } PresentationHelper.UpdateClassDisplay(element); break; } case "IsAbstract": { bool newIsAbstract = (bool)e.NewValue; if (newIsAbstract && element.IsDependentType) { errorMessages.Add($"Can't make {element.Name} abstract since it's a dependent type"); break; } PresentationHelper.UpdateClassDisplay(element); break; } case "IsDependentType": { bool newIsDependentType = (bool)e.NewValue; if (newIsDependentType) { if (element.IsAbstract) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's abstract"); break; } // dependent type can't be source in an association if (store.GetAll <UnidirectionalAssociation>() .Any(a => a.Source == element)) { errorMessages.Add($"Can't make {element.Name} a dependent class since it references other classes"); break; } if (store.GetAll <BidirectionalAssociation>() .Any(a => a.Source == element || a.Target == element)) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's in a bidirectional association"); break; } if (store.GetAll <Association>() .Any(a => a.Target == element && a.TargetMultiplicity == Multiplicity.ZeroMany)) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's the target of a 0..* association"); break; } foreach (ModelAttribute modelAttribute in element.AllAttributes.Where(a => a.IsIdentity)) { modelAttribute.IsIdentity = false; } foreach (UnidirectionalAssociation association in Association.GetLinksToTargets(element).OfType <UnidirectionalAssociation>()) { if (association.SourceMultiplicity == Multiplicity.ZeroMany) { association.SourceMultiplicity = Multiplicity.ZeroOne; } if (association.TargetMultiplicity == Multiplicity.ZeroMany) { association.TargetMultiplicity = Multiplicity.ZeroOne; } association.TargetRole = EndpointRole.Dependent; } element.TableName = string.Empty; element.DbSetName = string.Empty; } else { element.DbSetName = MakeDefaultName(element.Name); element.TableName = MakeDefaultName(element.Name); } PresentationHelper.UpdateClassDisplay(element); break; } case "Name": { string newName = (string)e.NewValue; if (current.Name.ToLowerInvariant() != "paste" && (string.IsNullOrWhiteSpace(newName) || !CodeGenerator.IsValidLanguageIndependentIdentifier(newName))) { errorMessages.Add($"Class name '{newName}' isn't a valid .NET identifier."); } else if (store.ElementDirectory .AllElements .OfType <ModelClass>() .Except(new[] { element }) .Any(x => x.Name == newName)) { errorMessages.Add($"Class name '{newName}' already in use by another class"); } else if (store.ElementDirectory .AllElements .OfType <ModelEnum>() .Any(x => x.Name == newName)) { errorMessages.Add($"Class name '{newName}' already in use by an enum"); } else if (!string.IsNullOrEmpty((string)e.OldValue)) { string oldDefaultName = MakeDefaultName((string)e.OldValue); string newDefaultName = MakeDefaultName(newName); if (element.DbSetName == oldDefaultName) { element.DbSetName = newDefaultName; } if (element.TableName == oldDefaultName) { element.TableName = newDefaultName; } } break; } case "Namespace": { string newNamespace = (string)e.NewValue; if (current.Name.ToLowerInvariant() != "paste") { errorMessages.Add(CommonRules.ValidateNamespace(newNamespace, CodeGenerator.IsValidLanguageIndependentIdentifier)); } break; } case "TableName": { string newTableName = (string)e.NewValue; if (element.IsDependentType) { if (!string.IsNullOrEmpty(newTableName)) { element.TableName = string.Empty; } } else { if (string.IsNullOrEmpty(newTableName)) { element.TableName = MakeDefaultName(element.Name); } if (store.GetAll <ModelClass>() .Except(new[] { element }) .Any(x => x.TableName == newTableName)) { errorMessages.Add($"Table name '{newTableName}' already in use"); } } break; } } errorMessages = errorMessages.Where(m => m != null).ToList(); if (errorMessages.Any()) { current.Rollback(); ErrorDisplay.Show(store, string.Join("\n", errorMessages)); } }
public override void ElementPropertyChanged(ElementPropertyChangedEventArgs e) { base.ElementPropertyChanged(e); ModelClass element = (ModelClass)e.ModelElement; ModelRoot modelRoot = element.ModelRoot; if (element.IsDeleted) { return; } Store store = element.Store; Transaction current = store.TransactionManager.CurrentTransaction; if (current.IsSerializing || ModelRoot.BatchUpdating) { return; } if (Equals(e.NewValue, e.OldValue)) { return; } List <string> errorMessages = new List <string>(); switch (e.DomainProperty.Name) { case "BaseClass": { if (element.IsDependentType) { errorMessages.Add($"Can't give {element.Name} a base class since it's a dependent type"); } break; } case "CustomInterfaces": { if (modelRoot.ShowInterfaceIndicators) { PresentationHelper.UpdateClassDisplay(element); } break; } case "DbSetName": { string newDbSetName = (string)e.NewValue; if (element.IsDependentType) { if (!string.IsNullOrEmpty(newDbSetName)) { element.DbSetName = string.Empty; } } else { if (string.IsNullOrEmpty(newDbSetName)) { element.DbSetName = MakeDefaultTableAndSetName(element.Name); } if (current.Name.ToLowerInvariant() != "paste" && (string.IsNullOrWhiteSpace(newDbSetName) || !CodeGenerator.IsValidLanguageIndependentIdentifier(newDbSetName))) { errorMessages.Add($"DbSet name '{newDbSetName}' isn't a valid .NET identifier."); } else if (store.GetAll <ModelClass>() .Except(new[] { element }) .Any(x => x.DbSetName == newDbSetName)) { errorMessages.Add($"DbSet name '{newDbSetName}' already in use"); } } break; } case "ImplementNotify": { bool newImplementNotify = (bool)e.NewValue; if (newImplementNotify) { List <string> nameList = element.Attributes.Where(x => x.AutoProperty).Select(x => x.Name).ToList(); if (nameList.Any()) { string names = nameList.Count > 1 ? string.Join(", ", nameList.Take(nameList.Count - 1)) + " and " + nameList.Last() : nameList.First(); string verb = nameList.Count > 1 ? "is an autoproperty" : "are autoproperties"; WarningDisplay.Show($"{names} {verb}, so will not participate in INotifyPropertyChanged messages"); } } PresentationHelper.UpdateClassDisplay(element); break; } case "IsAbstract": { bool newIsAbstract = (bool)e.NewValue; if (newIsAbstract && element.IsDependentType) { errorMessages.Add($"Can't make {element.Name} abstract since it's a dependent type"); break; } PresentationHelper.UpdateClassDisplay(element); break; } case "IsDatabaseView": { bool newIsView = (bool)e.NewValue; if (newIsView) { if (element.IsDependentType) { errorMessages.Add($"Can't base {element.Name} off a view since it's a dependent type"); break; } if (element.IsQueryType) { errorMessages.Add($"Can't base {element.Name} off a view since it's a query type"); break; } if (string.IsNullOrEmpty(element.ViewName)) { element.ViewName = element.TableName; } if (string.IsNullOrEmpty(element.ViewName)) { element.ViewName = MakeDefaultTableAndSetName(element.Name); } if (modelRoot.IsEFCore5Plus) { VerifyKeylessTypeEFCore5(); } else { VerifyKeylessType(); } } break; } case "IsDependentType": { if (element.IsDependentType) { if (element.IsDatabaseView) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's backed by a database view"); break; } if (element.IsQueryType) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's a query type"); break; } if (element.BaseClass != null) { errorMessages.Add($"Can't make {element.Name} a dependent class since it has a base class"); break; } string subclasses = string.Join(", ", store.GetAll <Generalization>().Where(g => g.Superclass == element).Select(g => g.Subclass.Name)); if (!string.IsNullOrEmpty(subclasses)) { errorMessages.Add($"Can't make {element.Name} a dependent class since it has subclass(es) {subclasses}"); break; } if (element.IsAbstract) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's abstract"); break; } List <Association> principalAssociations = store.GetAll <Association>().Where(a => a.Principal == element).ToList(); if (principalAssociations.Any()) { string badAssociations = string.Join(", ", principalAssociations.Select(a => a.GetDisplayText())); errorMessages.Add($"Can't make {element.Name} a dependent class since it's the principal end in: {badAssociations}"); break; } List <UnidirectionalAssociation> entityTargets = store.GetAll <UnidirectionalAssociation>().Where(a => a.Source == element && !a.Target.IsDependentType).ToList(); if (entityTargets.Any()) { string badAssociations = string.Join(", ", entityTargets.Select(a => a.GetDisplayText())); errorMessages.Add($"Can't make {element.Name} a dependent class since it has unidirectional associations to entities in: {badAssociations}"); break; } List <BidirectionalAssociation> bidirectionalAssociations = store.GetAll <BidirectionalAssociation>().Where(a => a.Source == element || a.Target == element).ToList(); if (bidirectionalAssociations.Any()) { if (!modelRoot.IsEFCore5Plus) { string badAssociations = string.Join(", ", entityTargets.Select(a => a.GetDisplayText())); errorMessages.Add($"Can't make {element.Name} a dependent class since it has bidirectional associations in: {badAssociations}"); break; } bidirectionalAssociations = bidirectionalAssociations.Where(a => (a.Source == element && a.TargetMultiplicity != Multiplicity.One) || (a.Target == element && a.SourceMultiplicity != Multiplicity.One)) .ToList(); if (bidirectionalAssociations.Any()) { string badAssociations = string.Join(", ", entityTargets.Select(a => a.GetDisplayText())); errorMessages.Add($"Can't make {element.Name} a dependent class since it has bidirectional associations without 1 or 0/1 ownership multiplicity in: {badAssociations}. The other end must be a single, required reference."); break; } } if (element.ModelRoot.EntityFrameworkVersion == EFVersion.EF6 || element.ModelRoot.GetEntityFrameworkPackageVersionNum() < 2.2) { if (store.GetAll <Association>().Any(a => a.Target == element && a.TargetMultiplicity == Multiplicity.ZeroMany)) { errorMessages.Add($"Can't make {element.Name} a dependent class since it's the target of a 0..* association"); break; } foreach (UnidirectionalAssociation association in Association.GetLinksToTargets(element).OfType <UnidirectionalAssociation>()) { if (association.SourceMultiplicity == Multiplicity.ZeroMany) { association.SourceMultiplicity = Multiplicity.ZeroOne; } if (association.TargetMultiplicity == Multiplicity.ZeroMany) { association.TargetMultiplicity = Multiplicity.ZeroOne; } association.TargetRole = EndpointRole.Dependent; } element.TableName = string.Empty; } foreach (ModelAttribute modelAttribute in element.AllAttributes.Where(a => a.IsIdentity)) { modelAttribute.IsIdentity = false; } element.DbSetName = string.Empty; } else { element.DbSetName = MakeDefaultTableAndSetName(element.Name); element.TableName = MakeDefaultTableAndSetName(element.Name); } // Remove any foreign keys in any incoming or outgoing associations foreach (Association association in Association.GetLinksToTargets(element).Union(Association.GetLinksToSources(element)).Distinct()) { association.FKPropertyName = null; } PresentationHelper.UpdateClassDisplay(element); break; } case "IsPropertyBag": { if (element.Superclass != null && !element.Superclass.IsPropertyBag) { element.Superclass.IsPropertyBag = true; } if (element.Subclasses.Any()) { foreach (ModelClass subclass in element.Subclasses) { subclass.IsPropertyBag = true; } } PresentationHelper.UpdateClassDisplay(element); break; } case "IsQueryType": { if ((bool)e.NewValue) { if (element.IsDependentType) { errorMessages.Add($"Can't make {element.Name} a query type since it's a dependent class"); break; } if (modelRoot.EntityFrameworkVersion == EFVersion.EF6) { element.IsQueryType = false; } else if (modelRoot.IsEFCore5Plus) { VerifyKeylessTypeEFCore5(); } else { VerifyKeylessType(); } } break; } case "Name": { if (current.Name.ToLowerInvariant() == "paste") { return; } if (string.IsNullOrWhiteSpace(element.Name) || !CodeGenerator.IsValidLanguageIndependentIdentifier(element.Name)) { errorMessages.Add("Name must be a valid .NET identifier"); } else if (store.GetAll <ModelClass>().Except(new[] { element }).Any(x => x.FullName == element.FullName)) { errorMessages.Add($"Class name '{element.FullName}' already in use by another class"); } else if (store.GetAll <ModelEnum>().Any(x => x.FullName == element.FullName)) { errorMessages.Add($"Class name '{element.FullName}' already in use by an enum"); } else if (!string.IsNullOrEmpty((string)e.OldValue)) { string oldDefaultName = MakeDefaultTableAndSetName((string)e.OldValue); string newDefaultName = MakeDefaultTableAndSetName(element.Name); if (element.DbSetName == oldDefaultName) { element.DbSetName = newDefaultName; } if (element.TableName == oldDefaultName) { element.TableName = newDefaultName; } } break; } case "Namespace": { string newNamespace = (string)e.NewValue; if (current.Name.ToLowerInvariant() != "paste") { errorMessages.Add(CommonRules.ValidateNamespace(newNamespace, CodeGenerator.IsValidLanguageIndependentIdentifier)); } break; } case "TableName": { if (!element.IsDatabaseView) { string newTableName = (string)e.NewValue; if (element.IsDependentType) { if (!modelRoot.IsEFCore5Plus && !string.IsNullOrEmpty(newTableName)) { element.TableName = string.Empty; } } else { if (string.IsNullOrEmpty(newTableName)) { element.TableName = MakeDefaultTableAndSetName(element.Name); } if (store.GetAll <ModelClass>() .Except(new[] { element }) .Any(x => x.TableName == newTableName)) { errorMessages.Add($"Table name '{newTableName}' already in use"); } } } break; } case "ViewName": { if (element.IsDatabaseView) { string newViewName = (string)e.NewValue; if (element.IsDependentType) { if (!modelRoot.IsEFCore5Plus && !string.IsNullOrEmpty(newViewName)) { element.TableName = string.Empty; } } else { if (string.IsNullOrEmpty(newViewName)) { element.TableName = MakeDefaultTableAndSetName(element.Name); } if (store.GetAll <ModelClass>() .Except(new[] { element }) .Any(x => x.TableName == newViewName)) { errorMessages.Add($"Table name '{newViewName}' already in use"); } } } break; } } errorMessages = errorMessages.Where(m => m != null).ToList(); if (errorMessages.Any()) { current.Rollback(); ErrorDisplay.Show(store, string.Join("\n", errorMessages)); } void VerifyKeylessTypeEFCore5() { // TODO: Find definitive documentation on query type restrictions in EFCore5+ // Restrictions: // ================================= // Cannot have a key defined. List <string> allIdentityAttributeNames = element.AllIdentityAttributeNames.ToList(); if (allIdentityAttributeNames.Any()) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has identity attribute(s) {string.Join(", ", allIdentityAttributeNames)}. Set their 'Is Identity' property to false first."); } // Only support a subset of navigation mapping capabilities, specifically: // - They may never act as the principal end of a relationship. string badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => a.Principal == element) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it is the principal end of association(s) {badAssociations}."); } // - They may not have navigations to owned entities badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => (a is UnidirectionalAssociation && a.Source == element && a.Target.IsDependentType) || (a is BidirectionalAssociation b && b.Source == element && b.Target.IsDependentType) || (a is BidirectionalAssociation c && c.Target == element && c.Source.IsDependentType)) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has association(s) to dependent type(s) in {badAssociations}."); } // - Entities cannot contain navigation properties to query types. badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => (a is UnidirectionalAssociation && a.Source == element && a.Target.IsQueryType) || (a is BidirectionalAssociation b && b.Source == element && b.Target.IsQueryType) || (a is BidirectionalAssociation c && c.Target == element && c.Source.IsQueryType)) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has association to sql-mapped type(s) in {badAssociations}."); } // - They can only contain reference navigation properties pointing to regular entities. badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => (a is UnidirectionalAssociation && a.Source == element && a.TargetMultiplicity == Multiplicity.ZeroMany) || (a is BidirectionalAssociation b && b.Source == element && b.TargetMultiplicity == Multiplicity.ZeroMany) || (a is BidirectionalAssociation c && c.Target == element && c.SourceMultiplicity == Multiplicity.ZeroMany)) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has zero-to-many association(s) in {badAssociations}. Only to-one or to-zero-or-one associations are allowed. "); } } void VerifyKeylessType() { // Restrictions: // ================================= // Cannot have a key defined. List <string> allIdentityAttributeNames = element.AllIdentityAttributeNames.ToList(); if (allIdentityAttributeNames.Any()) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has identity attribute(s) {string.Join(", ", allIdentityAttributeNames)}. Set their 'Is Identity' property to false first."); } // Only support a subset of navigation mapping capabilities, specifically: // - They may never act as the principal end of a relationship. string badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => a.Principal == element) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it is the principal end of association(s) {badAssociations}."); } // - They may not have navigations to owned entities badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => (a is UnidirectionalAssociation && a.Source == element && a.Target.IsDependentType) || (a is BidirectionalAssociation b && b.Source == element && b.Target.IsDependentType) || (a is BidirectionalAssociation c && c.Target == element && c.Source.IsDependentType)) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has association(s) to dependent type(s) in {badAssociations}."); } // - Entities cannot contain navigation properties to query types. badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => (a is UnidirectionalAssociation && a.Source == element && a.Target.IsQueryType) || (a is BidirectionalAssociation b && b.Source == element && b.Target.IsQueryType) || (a is BidirectionalAssociation c && c.Target == element && c.Source.IsQueryType)) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has association to sql-mapped type(s) in {badAssociations}."); } // - They can only contain reference navigation properties pointing to regular entities. badAssociations = string.Join(", " , store.ElementDirectory.AllElements .OfType <Association>() .Where(a => (a is UnidirectionalAssociation && a.Source == element && a.TargetMultiplicity == Multiplicity.ZeroMany) || (a is BidirectionalAssociation b && b.Source == element && b.TargetMultiplicity == Multiplicity.ZeroMany) || (a is BidirectionalAssociation c && c.Target == element && c.SourceMultiplicity == Multiplicity.ZeroMany)) .Select(a => a.GetDisplayText())); if (!string.IsNullOrEmpty(badAssociations)) { errorMessages.Add($"{element.Name} can't be mapped to a Sql query since it has zero-to-many association(s) in {badAssociations}. Only to-one or to-zero-or-one associations are allowed. "); } } }