SAIF.Framework.Data.NHibernate SQL catalog

This page indexes all SQL statements used by this library, grouped by CRUD type. All four statements are session-level escape hatches (ISessionStrategy.CreateSqlQuery), not IBusinessCriteria-based SQL properties — this library has zero IBusinessCriteria implementations.

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-004	Retrieve current server date/time (engine-selected)	Inline	— (DUAL pseudo-table / no table)	N/A — infrastructure utility

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Fetch next Oracle sequence value for a new Image ID	image_seq	image	Image
SQL-002	Fetch next Oracle sequence value for a new ImageSystem ID	tower_seq	IMGSYS	ImageSystem
SQL-003	Fetch next Oracle sequence value for a new ImageAffiliation ID	image_affiliation_seq	IMAGE_AFFILIATION	ImageAffiliation

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference

Sources

• Repositories/Imaging/ImageRepositoryExtensions.cs
• SessionHelper/SessionHelperBase.cs
• SessionHelper/OracleSessionHelper.cs
• SessionHelper/SqlServerSessionHelper.cs