Skip to content

SQL-184: OutputDocumentQueryProvider.DocumentSystemDate

This statement is a read operation invoked through ORM (IRepository.SystemDate). Executed by OutputDocumentQueryProvider.DocumentSystemDate.

Classification

Field Value
SQL ID SQL-184
Operation type Read
Execution method ORM (IRepository.SystemDate)
Database Oracle*
Schema [unqualified]**
Command type N/A (ORM-generated)
Business object OutputDocumentQueryProvider
Criteria property N/A — ORM
Lifecycle method DocumentSystemDate

Tables

Table Access Columns used
none (Oracle DUAL) SELECT SYSDATE (pseudo-column)

LINQ statement

Source: Data/SAIF.Data/Queries/OutputDocuments/OutputDocumentQueryProvider.cs:51.

public DateTime DocumentSystemDate { get { return Factory.GetRepository<PolicyOutputDocument>().SystemDate; } }

Sample SQL

Inferred SQL: This SQL was inferred from the LINQ statement above and the NHibernate mappings. It is not concrete SQL from source code; NHibernate generates the executed statement at runtime, so aliases, column order, join syntax, and bind-parameter names may differ.

-- Inferred from LINQ (NHibernate mapping translation); not concrete SQL
-- SQL text for Repository.SystemDate is documented by SAIF.Framework.Data.NHibernate (Legends CLI)
SELECT SYSDATE FROM DUAL

Translation notes: - This is not a LINQ expression but a framework repository member. Per the skill's provenance table, repository members are still inferred-from-linq. The SQL text comes from the SAIF.Framework.Data.NHibernate docgen (Legends CLI lookup of Repository.SystemDate → select sysdate from dual), not from this repository's source. - DUAL is an Oracle system table; it is listed for accuracy. The Writer may render Tables as "none (Oracle DUAL)".

Operations and processes

Business rules

Sources

  • Data/SAIF.Data/Queries/OutputDocuments/OutputDocumentQueryProvider.cs:51