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 | Insert one cross-application context key/value row for a session | Inline | Context | clsContext |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-MVC-002 | Retrieve context rows left by a different source application for a session | Inline | Context | clsContext |
| SQL-MVC-003 | Retrieve a single named context value for a session (used to look up the page ID) | Inline | 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 | Delete all context rows for an application and session | Inline | Context | clsContext |
Sequence operations¶
No sequence-generation operations exist in this library.
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Security and authorization
- Configuration
- Database tables
- API reference
Sources¶
- SAIF.Presentation.Web.MVC\clsContext.vb