/// <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;
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. ");
}
}
}
