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	Oracle	Reads the current database server date from the DUAL pseudo-table to back ISessionHelper.SystemDate on the Oracle engine.	Concrete
SQL-002	PostgreSQL	Reads the current database server date to back ISessionHelper.SystemDate on the PostgreSQL engine.	Concrete
SQL-003	SQL Server	Reads the current database server date to back ISessionHelper.SystemDate on the SQL Server engine.	Concrete
SQL-004	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
• Overview
• Architecture
• Dependencies
• Configuration
• Operations and processes
• Business rules
• Database tables
• Service registration
• API reference

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