---
title: SAIF.Framework.Data.NHibernate SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: Framework
last_reviewed: 2026-09-15
library: SAIF.Framework.Data.NHibernate
reference_type: package
---

# 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](SQL-004-saif-framework-data-nhibernate.md) | 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](SQL-001-saif-framework-data-nhibernate.md) | Fetch next Oracle sequence value for a new Image ID | `image_seq` | [image](../database-tables.md#image) | `Image` |
| [SQL-002](SQL-002-saif-framework-data-nhibernate.md) | Fetch next Oracle sequence value for a new ImageSystem ID | `tower_seq` | [IMGSYS](../database-tables.md#imgsys) | `ImageSystem` |
| [SQL-003](SQL-003-saif-framework-data-nhibernate.md) | Fetch next Oracle sequence value for a new ImageAffiliation ID | `image_affiliation_seq` | [IMAGE_AFFILIATION](../database-tables.md#image_affiliation) | `ImageAffiliation` |

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

## Sources
- `Repositories/Imaging/ImageRepositoryExtensions.cs`
- `SessionHelper/SessionHelperBase.cs`
- `SessionHelper/OracleSessionHelper.cs`
- `SessionHelper/SqlServerSessionHelper.cs`