Search Results for

    Show / Hide Table of Contents

    Class SqlQuery

    SQL Query.

    Inheritance
    object
    QueryBase
    SqlQuery
    Inherited Members
    QueryBase.DefaultPageSize
    QueryBase.Local
    QueryBase.PageSize
    object.Equals(object)
    object.Equals(object, object)
    object.GetHashCode()
    object.GetType()
    object.MemberwiseClone()
    object.ReferenceEquals(object, object)
    Namespace: Apache.Ignite.Core.Cache.Query
    Assembly: Apache.Ignite.Core.dll
    Syntax
    [Obsolete("Use SqlFieldsQuery instead. For strongly-typed queries use Apache.Ignite.Linq. SqlQuery is a limited subset of SqlFieldsQuery.")]
    public class SqlQuery : QueryBase

    Constructors

    SqlQuery(string, string, bool, params object[])

    Constructor.

    Declaration
    public SqlQuery(string queryType, string sql, bool local, params object[] args)
    Parameters
    Type Name Description
    string queryType

    Type.

    string sql

    SQL.

    bool local

    Whether query should be executed locally.

    object[] args

    Arguments.

    SqlQuery(string, string, params object[])

    Constructor.

    Declaration
    public SqlQuery(string queryType, string sql, params object[] args)
    Parameters
    Type Name Description
    string queryType

    Type.

    string sql

    SQL.

    object[] args

    Arguments.

    SqlQuery(Type, string, bool, params object[])

    Constructor.

    Declaration
    public SqlQuery(Type queryType, string sql, bool local, params object[] args)
    Parameters
    Type Name Description
    Type queryType

    Type.

    string sql

    SQL.

    bool local

    Whether query should be executed locally.

    object[] args

    Arguments.

    SqlQuery(Type, string, params object[])

    Constructor.

    Declaration
    public SqlQuery(Type queryType, string sql, params object[] args)
    Parameters
    Type Name Description
    Type queryType

    Type.

    string sql

    SQL.

    object[] args

    Arguments.

    Properties

    Arguments

    Arguments.

    Declaration
    [SuppressMessage("Microsoft.Performance", "CA1819:PropertiesShouldNotReturnArrays")]
    public object[] Arguments { get; set; }
    Property Value
    Type Description
    object[]

    EnableDistributedJoins

    Gets or sets a value indicating whether distributed joins should be enabled for this query.

    When disabled, join results will only contain colocated data (joins work locally). When enabled, joins work as expected, no matter how the data is distributed.
    Declaration
    public bool EnableDistributedJoins { get; set; }
    Property Value
    Type Description
    bool

    true if enable distributed joins should be enabled; otherwise, false.

    QueryType

    Type.

    Declaration
    public string QueryType { get; set; }
    Property Value
    Type Description
    string

    ReplicatedOnly

    Gets or sets a value indicating whether this query contains only replicated tables. This is a hint for potentially more effective execution.

    Declaration
    [Obsolete("No longer used as of Apache Ignite 2.8.")]
    public bool ReplicatedOnly { get; set; }
    Property Value
    Type Description
    bool

    Sql

    SQL.

    Declaration
    public string Sql { get; set; }
    Property Value
    Type Description
    string

    Timeout

    Gets or sets the query timeout. Query will be automatically cancelled if the execution timeout is exceeded. Default is Zero, which means no timeout.

    Declaration
    public TimeSpan Timeout { get; set; }
    Property Value
    Type Description
    TimeSpan

    Methods

    ToString()

    Returns a string that represents this instance.

    Declaration
    public override string ToString()
    Returns
    Type Description
    string

    A string that represents this instance.

    Overrides
    object.ToString()
    In this article
    Back to top © 2015 - 2019 The Apache Software Foundation