SqlServerAppenders..::..WithHistory<(Of <(<'TObject>)>)> Method (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.
Namespace:
Tortuga.Chain.SqlServerAssembly: Tortuga.Chain.SqlServer.MDS (in Tortuga.Chain.SqlServer.MDS.dll)
Syntax
public static MultipleRowDbCommandBuilder<AbstractCommand, AbstractParameter, TObject> WithHistory<TObject>( this SingleRowDbCommandBuilder<AbstractCommand, AbstractParameter, TObject> tableDbCommand, DateTime fromDate, DateTime toDate, HistoryQueryMode mode )
<ExtensionAttribute> _ Public Shared Function WithHistory(Of TObject) ( _ tableDbCommand As SingleRowDbCommandBuilder(Of AbstractCommand, AbstractParameter, TObject), _ fromDate As DateTime, _ toDate As DateTime, _ mode As HistoryQueryMode _ ) As MultipleRowDbCommandBuilder(Of AbstractCommand, AbstractParameter, TObject)
[ExtensionAttribute] public: generic<typename TObject> static MultipleRowDbCommandBuilder<AbstractCommand^, AbstractParameter^, TObject>^ WithHistory( SingleRowDbCommandBuilder<AbstractCommand^, AbstractParameter^, TObject>^ tableDbCommand, DateTime^ fromDate, DateTime^ toDate, HistoryQueryMode^ mode )
Type Parameters
- TObject
Parameters
- tableDbCommand
- Type: Tortuga.Chain.CommandBuilders..::..SingleRowDbCommandBuilder<(Of <(<'AbstractCommand, AbstractParameter, TObject>)>)>
The table database command.
- fromDate
- Type: DateTime
The lower date range.
- toDate
- Type: DateTime
The upper date range.
- mode
- Type: Tortuga.Chain.SqlServer..::..HistoryQueryMode
The mode determines how the bounds checking will be applied (i.e. inclusive or exclusive).