Search Results for

Show / Hide Table of Contents

# Class QuerySqlFieldAttribute

Marks field or property for SQL queries.

Using this attribute is an alternative to Fields in CacheConfiguration.

##### Inheritance

System.Object
QuerySqlFieldAttribute

###### Namespace: Apache.Ignite.Core.Cache.Configuration

###### Assembly: Apache.Ignite.Core.dll

##### Syntax

    public sealed class QuerySqlFieldAttribute : Attribute

### Constructors

#### QuerySqlFieldAttribute()

Initializes a new instance of the QuerySqlFieldAttribute class.

##### Declaration

    public QuerySqlFieldAttribute()

### Properties

#### DefaultValue

Gets or sets the default value for the field (has effect when inserting with DML).

##### Declaration

    public object DefaultValue { get; set; }

##### Property Value

Type | Description
--- | ---
System.Object |

#### IndexGroups

Gets or sets the collection of index groups this field belongs to. Groups are used for compound indexes, whenever index should be created on more than one field. All fields within the same group will belong to the same index.

##### Declaration

    public string[] IndexGroups { get; set; }

##### Property Value

Type | Description
--- | ---
System.String[] |

#### IndexInlineSize

Gets or sets the index inline size, see InlineSize.

##### Declaration

    public int IndexInlineSize { get; set; }

##### Property Value

Type | Description
--- | ---
System.Int32 |

#### IsDescending

Gets or sets a value indicating whether index for this field should be descending. Ignored when IsIndexed is `false`.

##### Declaration

    public bool IsDescending { get; set; }

##### Property Value

Type | Description
--- | ---
System.Boolean |

#### IsIndexed

Gets or sets a value indicating whether corresponding field should be indexed. Just like with databases, field indexing may require additional overhead during updates, but makes select operations faster.

##### Declaration

    public bool IsIndexed { get; set; }

##### Property Value

Type | Description
--- | ---
System.Boolean |

#### Name

Gets or sets the sql field name. If not provided, property or field name will be used.

##### Declaration

    public string Name { get; set; }

##### Property Value

Type | Description
--- | ---
System.String |

#### NotNull

Gets or sets a value indicating whether null values are allowed for this field.

##### Declaration

    public bool NotNull { get; set; }

##### Property Value

Type | Description
--- | ---
System.Boolean |

#### Precision

Gets or sets the precision for the field.

##### Declaration

    public int Precision { get; set; }

##### Property Value

Type | Description
--- | ---
System.Int32 |

#### Scale

Gets or sets the scale for the field.

##### Declaration

    public int Scale { get; set; }

##### Property Value

Type | Description
--- | ---
System.Int32 |