Chain 5.6

Version 5.6

#560 FOR SYSTEM_TIME support for SQL Server

Tables and Views

• .WithHistory() Return all versions of the record.
• .WithHistory(asOfDate) Return the version of the record as of a specific date.
• .WithHistory(fromDate, toDate, HistoryQueryMode.FromTo) Return all versions of the record matching ValidFrom < end_date_time AND ValidTo > start_date_time
• .WithHistory(fromDate, toDate, HistoryQueryMode.Between) Return all versions of the record matching ValidFrom <= end_date_time AND ValidTo > start_date_time
• .WithHistory(fromDate, toDate, HistoryQueryMode.Contains) Return all versions of the record matching ValidFrom >= start_date_time AND ValidTo <&lt;>= end_date_time

#559 Ignore Soft Delete Rule when Reading

• .WithDeletedRecords() causes soft delete rules to be ignored so that you can read deleted rows.