SAIF.Framework.Preferences SQL catalog

This page indexes all 7 SQL statements in SAIF.Framework.Preferences, all issued inline by PreferenceData against a single table, USER_PREFERENCE.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-004	Insert a new preference row	Inline	USER_PREFERENCE	PreferenceData

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-002	Retrieve a single preference blob scoped by app/user/page	Inline	USER_PREFERENCE	PreferenceData
SQL-003	Retrieve all preference rows for a user	Inline	USER_PREFERENCE	PreferenceData
SQL-007	Scalar existence check (Count(*)) before insert/update	Inline	USER_PREFERENCE	PreferenceData

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-005	Update an existing preference row's text and audit columns	Inline	USER_PREFERENCE	PreferenceData

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-006	Delete a preference row when the supplied text is empty	Inline	USER_PREFERENCE	PreferenceData

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Inline USER_PREFERENCE_SEQ.nextval key-generation expression embedded in the SQL-004 INSERT	USER_PREFERENCE_SEQ	USER_PREFERENCE	PreferenceData

Related documentation

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

Sources

• SAIF.Framework.Preferences\PreferenceData.cs