SAIF.Presentation.Web.MVC database tables¶
This page catalogs database tables accessed by this library. Access is direct ADO.NET (SqlConnection/SqlCommand/SqlDataAdapter), not the standard BOF IBusinessCriteria pattern used elsewhere in SAIF.
Table catalog¶
| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
|---|---|---|---|---|---|
| Context | SQL Server (catalog NETFRAMEWORK) |
[unqualified]** |
C, R, D | Persists/retrieves cross-application MVC "context" hand-off values (claim ID, policy number, SAIF claim number, provider location sequence number) during navigation between SAIF applications. | clsContext |
Context¶
| Field | Value |
|---|---|
| Database | SQL Server (catalog NETFRAMEWORK) |
| Schema/Link | [unqualified]** — no OWNER.TABLE_NAME qualifier appears anywhere in the SQL text; actual owning schema could not be confirmed from this library's source alone. |
| Purpose | Backs cross-application/cross-page session state hand-off: when a user navigates from one SAIF web application to another, the source application writes context values (claim ID, policy number, SAIF claim number, provider location sequence number) keyed by application name and ASP.NET session ID; the target application reads and then deletes those rows on arrival. |
| Access pattern | Direct ADO.NET (SqlCommand/SqlDataAdapter, inline SQL text, CommandType.Text) via the private nested clsContextRepository class in clsContext.vb — not the BOF IBusinessCriteria pattern. |
| CRUD operations | Create (Insert), Read (two Retrieve variants), Delete. No Update operation exists against this table in this library. |
| Key columns used | AppName, SessionID, ContextName, ContextValue, ID (SELECT-list only, no identity-retrieval code present), UpdateDate (populated via CURRENT_TIMESTAMP literal on insert, not a bound parameter). |
| Sequence | N/A — key-generation strategy (identity column vs. natural key) is unknown**; no SCOPE_IDENTITY()/@@IDENTITY retrieval exists in source. |
| Related tables | None — Context is the only table referenced anywhere in clsContext.vb, clsOnlineContext.vb, or the calling code in clsControllerBase.vb; no JOIN clauses appear in any of the four SQL statements. |
| Business objects | clsContext, clsOnlineContext (subclass; performs no additional table access of its own) |
Operations referencing this table¶
Business rules referencing this table¶
SQL referencing this table¶
- SQL-MVC-001: Insert context value
- SQL-MVC-002: Retrieve cross-application context
- SQL-MVC-003: Retrieve single context value by session and name
- SQL-MVC-004: Delete context rows
Table relationship diagram¶
No cross-table relationships were identified in this library's SQL. Context is a single, standalone table with no JOIN clauses or shared-key references to any other table in this library's scope.
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Security and authorization
- Configuration
- SQL catalog
- API reference
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
- SAIF.Presentation.Web.MVC\clsContext.vb
- SAIF.Presentation.Web.MVC\clsOnlineContext.vb
- SAIF.Presentation.Web.MVC\clsControllerBase.vb