SqlServerAppenders..::..WithHistory<(Of <(<'TObject>)>)> Method (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.
Namespace:
Tortuga.Chain.SqlServerAssembly: Tortuga.Chain.SqlServer.MDS (in Tortuga.Chain.SqlServer.MDS.dll)
Syntax
public static TableDbCommandBuilder<SqlCommand, SqlParameter, SqlServerLimitOption, TObject> WithHistory<TObject>( this TableDbCommandBuilder<SqlCommand, SqlParameter, SqlServerLimitOption, TObject> tableDbCommand, DateTime asOfDate )
<ExtensionAttribute> _ Public Shared Function WithHistory(Of TObject) ( _ tableDbCommand As TableDbCommandBuilder(Of SqlCommand, SqlParameter, SqlServerLimitOption, TObject), _ asOfDate As DateTime _ ) As TableDbCommandBuilder(Of SqlCommand, SqlParameter, SqlServerLimitOption, TObject)
[ExtensionAttribute] public: generic<typename TObject> static TableDbCommandBuilder<SqlCommand^, SqlParameter^, SqlServerLimitOption^, TObject>^ WithHistory( TableDbCommandBuilder<SqlCommand^, SqlParameter^, SqlServerLimitOption^, TObject>^ tableDbCommand, DateTime^ asOfDate )
Type Parameters
- TObject
Parameters
- tableDbCommand
- Type: Tortuga.Chain.CommandBuilders..::..TableDbCommandBuilder<(Of <(<'SqlCommand, SqlParameter, SqlServerLimitOption, TObject>)>)>
The table database command.
- asOfDate
- Type: DateTime
As Of Date to use