Tortuga.Chain Namespace
Tortuga.Chain.CommandBuilders Namespace
Tortuga.Chain.Metadata Namespace

SqlServerAppenders Methods

The SqlServerAppenders type exposes the following members.

Methods


  Name Description
Public method Static member AsCountDistinctApproximate(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>))
Return the approximate row count using the APPROX_COUNT_DISTINCT function.
Public method Static member AsCountDistinctApproximate(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>), String)
Return the approximate distinct count using the APPROX_COUNT_DISTINCT function.
Public method Static member AutoInvalidate<(Of <<'(TResult>)>>)
Attaches a SQL Server dependency change listener to this operation that will automatically invalidate the cache.
Public method Static member WithChangeNotification<(Of <<'(TResult>)>>)
Attaches a SQL Server dependency change listener to this operation.
Public method Static member WithHistory(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>))
Adds a FOR SYSTEM_TIME cluse to the query to get all historical records.
Public method Static member WithHistory(SingleRowDbCommandBuilder<(Of <<'(AbstractCommand, AbstractParameter>)>>))
Adds a FOR SYSTEM_TIME cluse to the query to get all historical records.
Public method Static member WithHistory(SingleRowDbCommandBuilder<(Of <<'(AbstractCommand, AbstractParameter>)>>), DateTime)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date.
Public method Static member WithHistory(SingleRowDbCommandBuilder<(Of <<'(AbstractCommand, AbstractParameter>)>>), DateTime, DateTime, HistoryQueryMode)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date range.
Public method Static member WithHistory(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>), DateTime)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date.
Public method Static member WithHistory(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>), DateTime, DateTime, HistoryQueryMode)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date range.
Public method Static member WithHistory<(Of <<'(TObject>)>>)(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>>))
Adds a FOR SYSTEM_TIME cluse to the query to get all historical records.
Public method Static member WithHistory<(Of <<'(TObject>)>>)(SingleRowDbCommandBuilder<(Of <<'(AbstractCommand, AbstractParameter, TObject>)>>))
Adds a FOR SYSTEM_TIME cluse to the query to get all historical records.
Public method Static member WithHistory<(Of <<'(TObject>)>>)(SingleRowDbCommandBuilder<(Of <<'(AbstractCommand, AbstractParameter, TObject>)>>), DateTime)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date.
Public method Static member WithHistory<(Of <<'(TObject>)>>)(SingleRowDbCommandBuilder<(Of <<'(AbstractCommand, AbstractParameter, TObject>)>>), DateTime, DateTime, HistoryQueryMode)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date range.
Public method Static member WithHistory<(Of <<'(TObject>)>>)(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>>), DateTime)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date.
Public method Static member WithHistory<(Of <<'(TObject>)>>)(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>>), DateTime, DateTime, HistoryQueryMode)
Adds a FOR SYSTEM_TIME cluse to the query to get the historical record for a specific date range.
Public method Static member WithIndex(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>), String)
Overrides which index will be used for a query.
Public method Static member WithIndex(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>), IndexMetadata<(Of <<'(AbstractObjectName, AbstractDbType>)>>))
Overrides which index will be used for a query.
Public method Static member WithIndex<(Of <<'(TObject>)>>)(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>>), String)
Overrides which index will be used for a query.
Public method Static member WithIndex<(Of <<'(TObject>)>>)(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>>), IndexMetadata<(Of <<'(AbstractObjectName, AbstractDbType>)>>))
Overrides which index will be used for a query.
Public method Static member WithInfoMessageNotification<(Of <<'(TResult>)>>)
Attaches a listener for SQL Server Info Message events.
Public method Static member WithIsolationLevel(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption>)>>), SqlServerIsolationLevel)
Sets the isolation level on the query using a table hint.
Public method Static member WithIsolationLevel<(Of <<'(TObject>)>>)(TableDbCommandBuilder<(Of <<'(SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>>), SqlServerIsolationLevel)
Sets the isolation level on the query using a table hint.