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

HistoryQueryMode Enumeration

Used to control which type of query will be used for system versioned tables

Namespace:  Tortuga.Chain.SqlServer
Assembly:  Tortuga.Chain.SqlServer.MDS (in Tortuga.Chain.SqlServer.MDS.dll)

Syntax


public enum HistoryQueryMode
Public Enumeration HistoryQueryMode
public enum class HistoryQueryMode

Members


Member nameDescription
None Only return the current version of the record.
All Return all versions of the record.
AsOfDate Return the version of the record as of a specific date.
FromTo Return all versions of the record matching `ValidFrom < end_date_time AND ValidTo > start_date_time`
Between Return all versions of the record matching `ValidFrom <= end_date_time AND ValidTo > start_date_time`
Contains Return all versions of the record matching `ValidFrom >= start_date_time AND ValidTo <= end_date_time`