Class EntityHasPivotAttribute

Indicates this entity contains information held in a sub table that can be pivotted and displayed against this record too.

This will ensure exports, and imports will allow reference to the pivotted values against this entity record too

Inheritance
System.Object
System.Attribute
EntityHasPivotAttribute
Inherited Members
System.Attribute.Equals(System.Object)
System.Attribute.GetCustomAttribute(System.Reflection.Assembly, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.Assembly, System.Type, System.Boolean)
System.Attribute.GetCustomAttribute(System.Reflection.MemberInfo, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.MemberInfo, System.Type, System.Boolean)
System.Attribute.GetCustomAttribute(System.Reflection.Module, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.Module, System.Type, System.Boolean)
System.Attribute.GetCustomAttribute(System.Reflection.ParameterInfo, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.ParameterInfo, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Module)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Type, System.Boolean)
System.Attribute.GetHashCode()
System.Attribute.IsDefaultAttribute()
System.Attribute.IsDefined(System.Reflection.Assembly, System.Type)
System.Attribute.IsDefined(System.Reflection.Assembly, System.Type, System.Boolean)
System.Attribute.IsDefined(System.Reflection.MemberInfo, System.Type)
System.Attribute.IsDefined(System.Reflection.MemberInfo, System.Type, System.Boolean)
System.Attribute.IsDefined(System.Reflection.Module, System.Type)
System.Attribute.IsDefined(System.Reflection.Module, System.Type, System.Boolean)
System.Attribute.IsDefined(System.Reflection.ParameterInfo, System.Type)
System.Attribute.IsDefined(System.Reflection.ParameterInfo, System.Type, System.Boolean)
System.Attribute.Match(System.Object)
System.Attribute.TypeId
System.Object.Equals(System.Object, System.Object)
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: LemonEdge.API.Attributes
Assembly: API.dll
Syntax
[AttributeUsage(AttributeTargets.Interface, Inherited = false, AllowMultiple = false)]
public sealed class EntityHasPivotAttribute : Attribute
Remarks

For example you could have the following entities:

Person +Name

Skills +Name

SkillCompetencyLevels +SkillID +Name

PersonSkill +PersonID +SkillID +SkillCompetencyLevelID

This attribute would allow you mark the Person entity as so: [PersonSkillID, nameof(PersonSkill.PersonID), nameof(PersonSkill.SkillID), nameof(PersonSkill.SkillCompetencyLevelID)]

Assuming we had the following skills: Accounting, Excel, Coding

This would allow you import/export of the person entity with the following headers automatically from the system: PersonID, PersonName, PersonSkill_Accounting, PersonSkill_Excel, PersonSkill_Coding

Which you could then populate with skill competency level values for the PersonSkill columns.

Constructors

EntityHasPivotAttribute(EntityID, String, String, String)

Marks this entity as wanting extra columns in export/imports that hold pivotted sub table information

Declaration
public EntityHasPivotAttribute(EntityID id, string pivotLinkColumn, string pivotHeaderColumn, string pivotValueColumn = "")
Parameters
Type Name Description
EntityID id

The unique global id of the entity that holds the information to be pivotted as columns against this entity
System.String pivotLinkColumn

The name of the column on that entity that holds a relationship back to this entity
System.String pivotHeaderColumn

The name of the column on that entity that holds values that should be represented as distinct column headers against this entity
System.String pivotValueColumn

The name of the column on that entity that holds the value associated with this entity for that pivotHeaderColumn

EntityHasPivotAttribute(String, String, String, String)

Marks this entity as wanting extra columns in export/imports that hold pivotted sub table information

Declaration
public EntityHasPivotAttribute(string entityID, string pivotLinkColumn, string pivotHeaderColumn, string pivotValueColumn = "")
Parameters
Type Name Description
System.String entityID

The unique global id of the entity that holds the information to be pivotted as columns against this entity
System.String pivotLinkColumn

The name of the column on that entity that holds a relationship back to this entity
System.String pivotHeaderColumn

The name of the column on that entity that holds values that should be represented as distinct column headers against this entity
System.String pivotValueColumn

The name of the column on that entity that holds the value associated with this entity for that pivotHeaderColumn

Properties

Info

The definition for the entity that holds pivot information to be displayed alongside this entity

Declaration
public PivotTableInfo Info { get; }
Property Value
Type Description
PivotTableInfo

Extension Methods

See Also