Click or drag to resize
TableTEntity Class
A Linq IQueryProvider that represents a table in Cassandra
Inheritance Hierarchy
SystemObject
  DseStatement
    Dse.Data.LinqCqlQueryBaseTEntity
      Dse.Data.LinqCqlQueryTEntity
        Dse.Data.LinqTableTEntity

Namespace: Dse.Data.Linq
Assembly: Dse (in Dse.dll) Version: 2.2.0
Syntax
C#
public class Table<TEntity> : CqlQuery<TEntity>, 
	ITable, IQueryProvider

Type Parameters

TEntity

The TableTEntity type exposes the following members.

Constructors
  NameDescription
Public methodTableTEntity(ISession)
Creates a new instance of the Linq IQueryProvider that represents a table in Cassandra using Global configuration.
Public methodTableTEntity(ISession, MappingConfiguration)

Creates a new instance of the Linq IQueryProvider that represents a table in Cassandra using the mapping configuration provided.

Fluent configuration or attributes can be used to define mapping information.

Public methodTableTEntity(ISession, MappingConfiguration, String)

Creates a new instance of the Linq IQueryProvider that represents a table in Cassandra using the mapping configuration provided.

Use this constructor if you want to use a different table name than the one defined in the mapping configuration.

Fluent configuration or attributes can be used to define mapping information.

Public methodTableTEntity(ISession, MappingConfiguration, String, String)

Creates a new instance of the Linq IQueryProvider that represents a table in Cassandra using the mapping configuration provided.

Use this constructor if you want to use a different table and keyspace names than the ones defined in the mapping configuration.

Fluent configuration or attributes can be used to define mapping information.

Top
Methods
  NameDescription
Public methodBeginExecute (Inherited from CqlQueryBaseTEntity.)
Public methodCreate
Public methodCreateIfNotExists
Public methodCreateQueryTElement
Public methodDisableTracing
Disable tracing for the statement.
(Inherited from Statement.)
Public methodEnableTracing
Enables tracing for the statement
(Inherited from Statement.)
Public methodEndExecute (Inherited from CqlQueryBaseTEntity.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExecute
Evaluates the Linq query, executes the cql statement and adapts the results.
(Inherited from CqlQueryBaseTEntity.)
Public methodExecuteAsync
Evaluates the Linq query, executes asynchronously the cql statement and adapts the results.
(Inherited from CqlQueryBaseTEntity.)
Public methodExecutePaged
Executes the query and returns a page of results
(Inherited from CqlQueryTEntity.)
Public methodExecutePagedAsync
Asynchronously executes the query and returns a task of a page of results
(Inherited from CqlQueryTEntity.)
Public methodExecutingAs
Allows this statement to be executed as a different user/role than the one currently authenticated (a.k.a. proxy execution).
(Inherited from Statement.)
Public methodGetEntityType
Public methodGetEnumerator (Inherited from CqlQueryTEntity.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetSession
Public methodGetTable (Inherited from CqlQueryBaseTEntity.)
Public methodGetTableType
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodInsert(TEntity)
Public methodInsert(TEntity, Boolean)
Public methodSetAutoPage
Sets the paging behavior. When set to true (default), the RowSet returned when executing this IStatement will automatically fetch the following result pages. When false, the RowSet returned will only contain the rows contained in the result page and will not fetch additional pages.
(Inherited from Statement.)
Public methodSetConsistencyLevel (Inherited from CqlQueryTEntity.)
Public methodSetIdempotence
Sets whether this statement is idempotent.

Idempotence of the statement plays a role in ISpeculativeExecutionPolicy. If a statement is not idempotent, the driver will not schedule speculative executions for it.

(Inherited from Statement.)
Public methodSetOutgoingPayload
Sets a custom outgoing payload for this statement. Each time this statement is executed, this payload will be included in the request. Once it is set using this method, the payload should not be modified.
(Inherited from Statement.)
Public methodSetPageSize
Sets the page size for this query. The page size controls how much resulting rows will be retrieved simultaneously (the goal being to avoid loading too much results in memory for queries yielding large results). Please note that while value as low as 1 can be used, it is highly discouraged to use such a low value in practice as it will yield very poor performance. If in doubt, leaving the default is probably a good idea.
(Inherited from CqlQueryTEntity.)
Public methodSetPagingState
Sets the paging state, a token representing the current page state of query used to continue paging by retrieving the following result page. Setting the paging state will disable automatic paging.
(Inherited from CqlQueryTEntity.)
Public methodSetReadTimeoutMillis
Overrides the default per-host read timeout ReadTimeoutMillis for this statement.
(Inherited from Statement.)
Public methodSetRetryPolicy
Sets the retry policy to use for this query.

Calling this method is only required when you want to override the default RetryPolicy set in the cluster configuration for this request.

Use a IExtendedRetryPolicy implementation to cover all error scenarios.

(Inherited from Statement.)
Public methodSetSerialConsistencyLevel (Inherited from CqlQueryTEntity.)
Public methodSetTimestamp
Sets the timestamp associated with this statement execution. If provided, this will replace the server side assigned timestamp as default timestamp. Note that a timestamp in the query itself will still override this timestamp.
(Inherited from Statement.)
Public methodToString
Generates and returns cql query for this instance
(Inherited from CqlQueryTEntity.)
Top
Extension Methods
  NameDescription
Public Extension MethodAllowFilteringTEntity
The ALLOW FILTERING option allows to explicitly allow queries that require filtering. Please note that a query using ALLOW FILTERING may thus have unpredictable performance (for the definition above), i.e. even a query that selects a handful of records may exhibit performance that depends on the total amount of data stored in the cluster.
(Defined by CqlQueryExtensions.)
Public Extension MethodCountTEntity
Returns the number of rows matching the query. To execute this CqlScalar use Execute() method.
(Defined by CqlQueryExtensions.)
Public Extension MethodDeleteTEntity
Returns a representation of a DELETE cql statement
(Defined by CqlQueryExtensions.)
Public Extension MethodDeleteIfTEntity
Returns a representation of a DELETE ... IF ... cql statement, for Lightweight Transactions support
(Defined by CqlQueryExtensions.)
Public Extension MethodFirstTEntityOverloaded.
Returns a CqlQuery which after execution will return the first element in a sequence. To execute this CqlQuery use Execute() method.
(Defined by CqlQueryExtensions.)
Public Extension MethodFirstTSource(ExpressionFuncTSource, Boolean)Overloaded.
Returns a CqlQuery which after execution returns the first element in a sequence that satisfies a specified condition. To execute this CqlQuery use Execute() method.
(Defined by CqlQueryExtensions.)
Public Extension MethodFirstOrDefaultTEntityOverloaded.
Returns a CqlQuery which after execution will return the first element of a sequence, or a default value if the sequence contains no elements. To execute this CqlQuery use Execute() method.
(Defined by CqlQueryExtensions.)
Public Extension MethodFirstOrDefaultTSource(ExpressionFuncTSource, Boolean)Overloaded.
Returns a CqlQuery which after execution will return the first element of the sequence that satisfies a condition or a default value if no such element is found. To execute this CqlQuery use Execute() method.
(Defined by CqlQueryExtensions.)
Public Extension MethodOrderByTEntity, TKey
Sorts the elements, which are returned from CqlQuery, in ascending order according to a key.
(Defined by CqlQueryExtensions.)
Public Extension MethodOrderByDescendingTEntity, TKey
Sorts the elements, which are returned from CqlQuery, in ascending order according to a key.
(Defined by CqlQueryExtensions.)
Public Extension MethodSelectTEntity, TResult
Projects each element of a sequence into a new form.
(Defined by CqlQueryExtensions.)
Public Extension MethodTakeTEntity
Returns a CqlQuery which after execution will return IEnumerable<TSource> with specified number of contiguous elements from the start of a sequence. To execute this CqlQuery use Execute() method.
(Defined by CqlQueryExtensions.)
Public Extension MethodThenByTEntity, TKey
Sorts the elements, which are returned from CqlQuery, in ascending order according to a key.
(Defined by CqlQueryExtensions.)
Public Extension MethodThenByDescendingTEntity, TKey
Sorts the elements, which are returned from CqlQuery, in descending order according to a key.
(Defined by CqlQueryExtensions.)
Public Extension MethodUpdateTEntity
Returns a representation of a UPDATE cql statement
(Defined by CqlQueryExtensions.)
Public Extension MethodUpdateIfTEntity
Returns a representation of a UPDATE ... IF ... cql statement, for Lightweight Transactions support
(Defined by CqlQueryExtensions.)
Public Extension MethodUpdateIfExistsTEntity
Returns a representation of a UPDATE ... IF EXISTS cql statement, for Lightweight Transactions support.
(Defined by CqlQueryExtensions.)
Public Extension MethodWhereTEntity
Returns a CqlQuery which after execution returns filtered sequence of values based on a predicate. To execute this CqlQuery use Execute() method.
(Defined by CqlQueryExtensions.)
Top
Properties
  NameDescription
Public propertyAutoPage
Determines if the RowSet returned when executing this IStatement will automatically fetch the following result pages. Defaults to true.
(Inherited from Statement.)
Public propertyConsistencyLevel
Gets the consistency level for this query.
(Inherited from Statement.)
Public propertyElementType (Inherited from CqlQueryBaseTEntity.)
Public propertyExpression (Inherited from CqlQueryBaseTEntity.)
Public propertyIsIdempotent
Determines if this statement is idempotent, i.e. whether it can be applied multiple times without changing the result beyond the initial application.

Idempotence of the statement plays a role in ISpeculativeExecutionPolicy. If a statement is not idempotent, the driver will not schedule speculative executions for it.

When the property is null, the driver will use the default value from the GetDefaultIdempotence.
(Inherited from Statement.)
Public propertyIsTracing
Gets whether tracing is enabled for this query or not.
(Inherited from Statement.)
Public propertyKeyspace
Gets the keyspace this query operates on. The returned value should not be null only when the IStatement applies to a different keyspace to the logged keyspace of the ISession.
(Inherited from CqlQueryBaseTEntity.)
Public propertyKeyspaceName
Gets the name of the keyspace used. If null, it uses the active session keyspace.
Public propertyName
Gets the name of the Table in Cassandra
Public propertyOutgoingPayload
Gets custom payload for that will be included when executing this Statement.
(Inherited from Statement.)
Public propertyPageSize
Gets query's page size.
(Inherited from Statement.)
Public propertyPagingState
This object represents the next page to be fetched if the query is multi page. It can be saved and reused later on a different execution.
(Inherited from Statement.)
Public propertyProvider
IQueryable.Provider implementation
(Inherited from CqlQueryTEntity.)
Public propertyQueryTrace
After being executed, it retrieves the trace of the CQL query.

Use EnableTracing(Boolean) to enable tracing.

Note that enabling query trace introduces server-side overhead by storing request information, so it's recommended that you only enable query tracing when trying to identify possible issues / debugging.

(Inherited from CqlQueryBaseTEntity.)
Public propertyQueryValues (Inherited from Statement.)
Public propertyReadTimeoutMillis
Gets the per-host read timeout for this statement.

When the value is 0 or lower, the default value from the socket options will be used.

(Inherited from Statement.)
Public propertyRetryPolicy
Gets the retry policy sets for this query, if any.
(Inherited from Statement.)
Public propertyRoutingKey (Inherited from CqlQueryBaseTEntity.)
Public propertySerialConsistencyLevel
Gets the serial consistency level for this query.
(Inherited from Statement.)
Public propertySkipMetadata (Inherited from Statement.)
Public propertyTimestamp
Gets the timestamp associated with this statement execution.
(Inherited from Statement.)
Top
See Also