SqlServerAppenders..::..WithHistory Method (SingleRowDbCommandBuilder<(Of <(<'AbstractCommand, AbstractParameter>)>)>, 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 SingleRowDbCommandBuilder<AbstractCommand, AbstractParameter> WithHistory( this SingleRowDbCommandBuilder<AbstractCommand, AbstractParameter> tableDbCommand, DateTime asOfDate )
<ExtensionAttribute> _ Public Shared Function WithHistory ( _ tableDbCommand As SingleRowDbCommandBuilder(Of AbstractCommand, AbstractParameter), _ asOfDate As DateTime _ ) As SingleRowDbCommandBuilder(Of AbstractCommand, AbstractParameter)
[ExtensionAttribute] public: static SingleRowDbCommandBuilder<AbstractCommand^, AbstractParameter^>^ WithHistory( SingleRowDbCommandBuilder<AbstractCommand^, AbstractParameter^>^ tableDbCommand, DateTime^ asOfDate )
Parameters
- tableDbCommand
- Type: Tortuga.Chain.CommandBuilders..::..SingleRowDbCommandBuilder<(Of <(<'AbstractCommand, AbstractParameter>)>)>
The table database command.
- asOfDate
- Type: DateTime
As Of Date to use