---
title: SAIF.Presentation.Web.MVC SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Documentation Team
last_reviewed: 2026-08-17
library: SAIF.Presentation.Web.MVC
reference_type: package
---

# SAIF.Presentation.Web.MVC SQL catalog

This page indexes all SQL statements used by this library, grouped by CRUD type. All four statements are direct, inline ADO.NET SQL Server statements against the `Context` table (`CommandType.Text` is never overridden, so none are stored-procedure calls).

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MVC-001](SQL-MVC-001-insert-context-value.md) | Insert one cross-application context key/value row for a session | Inline | [Context](../database-tables.md#context) | `clsContext` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MVC-002](SQL-MVC-002-retrieve-cross-application-context.md) | Retrieve context rows left by a different source application for a session | Inline | [Context](../database-tables.md#context) | `clsContext` |
| [SQL-MVC-003](SQL-MVC-003-retrieve-single-context-value.md) | Retrieve a single named context value for a session (used to look up the page ID) | Inline | [Context](../database-tables.md#context) | `clsContext` |

## Update operations

No Update (SET) operations exist against the `Context` table in this library.

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-MVC-004](SQL-MVC-004-delete-context-rows.md) | Delete all context rows for an application and session | Inline | [Context](../database-tables.md#context) | `clsContext` |

## Sequence operations

No sequence-generation operations exist in this library.

## 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)
- [Security and authorization](../security-authorization.md)
- [Configuration](../configuration.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- SAIF.Presentation.Web.MVC\clsContext.vb