---
title: SAIF.NetCore.NHibernate SQL catalog
summary: Index of SQL statements and LINQ-to-NHibernate queries issued by this library's own code.
status: draft
owner: Framework
last_reviewed: 2026-10-02
library: SAIF.NetCore.NHibernate
reference_type: package
---

# SAIF.NetCore.NHibernate SQL catalog

This library ships no entity mappings of its own, so almost all data access it performs on behalf of a consumer is opaque to it (plain LINQ-to-NHibernate against a consumer-supplied `TEntity`). Only four statements/queries originate directly from this library's own source: three engine-specific system-date probes and one generic connectivity-test query.

## Read operations

| SQL ID | Database | Description | Provenance |
| --- | --- | --- | --- |
| [SQL-001](SQL-001-oracle-system-date.md) | Oracle | Reads the current database server date from the `DUAL` pseudo-table to back `ISessionHelper.SystemDate` on the Oracle engine. | Concrete |
| [SQL-002](SQL-002-postgresql-system-date.md) | PostgreSQL | Reads the current database server date to back `ISessionHelper.SystemDate` on the PostgreSQL engine. | Concrete |
| [SQL-003](SQL-003-sql-server-system-date.md) | SQL Server | Reads the current database server date to back `ISessionHelper.SystemDate` on the SQL Server engine. | Concrete |
| [SQL-004](SQL-004-test-connection.md) | Any (consumer-mapped) | Probes database connectivity by running a bounded, always-empty query against a consumer-supplied entity type inside its own transaction. | LINQ (inferred SQL) |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Configuration](../configuration.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Service registration](../service-registration.md)
- [API reference](../api/index.md)

## Sources
- `src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/SessionHelpers/OracleSessionHelper.cs`
- `src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/SessionHelpers/SQLSessionHelper.cs`
- `src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/SessionHelpers/PostgreSqlSessionHelper.cs`
- `src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/SessionHelpers/SessionHelperBase.cs`
- `src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/UnitOfWork.cs`
- `src/SAIF.NetCore.Nhibernate/SAIF.NetCore.NHibernate/SAIF.NetCore.NHibernate/Repository.cs`