Class EntityIndexAttribute
Specifies an index to be created on the table for this entity
Inherited Members
Namespace: LemonEdge.API.Attributes
Assembly: LemonEdge.API.dll
Syntax
[AttributeUsage(AttributeTargets.Class|AttributeTargets.Interface, Inherited = false, AllowMultiple = true)]
public class EntityIndexAttribute : AttributeConstructors
EntityIndexAttribute()
Declaration
public EntityIndexAttribute()Fields
PRIMARY
Primary index
Declaration
public const string PRIMARY = "PRIMARY"Field Value
| Type | Description |
|---|---|
| string |
Properties
ColumnNames
The list of columns for this index
Declaration
public string[] ColumnNames { get; set; }Property Value
| Type | Description |
|---|---|
| string[] |
IncludeColumns
The list of columns that should also be included within the index, but are not part of the index itself
Declaration
public string[] IncludeColumns { get; set; }Property Value
| Type | Description |
|---|---|
| string[] |
IndexOrder
The associated order of each column in the index
Declaration
public IndexOrder[] IndexOrder { get; set; }Property Value
| Type | Description |
|---|---|
| IndexOrder[] |
IsClustered
Indicates if this index is clustered.
The system already creates the default clustered index for you unless EntityDefinitionAttribute.AutoClusteredIndexes is set to false
Declaration
public bool IsClustered { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
IsUnique
Indicates the combination of columns in ColumnNames results in each row holding unique values
Declaration
public bool IsUnique { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Name
The name for the index
Declaration
public string Name { get; set; }Property Value
| Type | Description |
|---|---|
| string |