SQL-003 SQL Server system date

This raw SQL statement is issued by SqlServerSessionHelper/SessionHelperBase to read the SQL Server database server's current date, which backs the ISessionHelper.SystemDate/IRepository<TEntity>.SystemDate property consumers use for server-authoritative timestamps (see BR-NH-17).

Classification

Field	Value
SQL ID	SQL-003
Operation type	Read
Execution method	Inline SQL via ISessionStrategy.CreateSqlQuery(string).UniqueResult()
Database	SQL Server
Schema	Unqualified** (depends on the consumer's connection string/default schema)
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	SqlServerSessionHelper (via SessionHelperBase.SystemDate)

Parameters

This statement has no parameters.

Tables

No tables — GetDate() is a SQL Server built-in function and requires no FROM clause.

Sample SQL

SELECT
  GetDate()

Operations and processes

• Get database system date

Business rules

• BR-NH-17
• BR-NH-18

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/SessionHelpers/SQLSessionHelper.cs
• src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/SessionHelpers/SessionHelperBase.cs