SQL-090: Retrieve AutoImportIndexDefaults via GenerateIdxFile

This ORM statement performs a read operation on AutoImportIndexDefaults via IUnitOfWork.GetRepository<T>(), executed from Services/SAIF.Services/Imaging/AutoImportHelperService.cs (L58).

Classification

Field	Value
SQL ID	SQL-090
Operation type	Read
Execution method	ORM (NHibernate LINQ)
Database	Oracle
Schema	[unqualified]**
Command type	N/A (ORM-generated)
Business object	AutoImportIndexDefaults
Criteria property	N/A — ORM
Lifecycle method	GenerateIdxFile

Parameters

Parameter	Direction	Type	Max length	Description
(none)	N/A	N/A	N/A	No inline filter — full-entity read (Query().ToList()/projection) or filters appended later

Tables

Table	Access	Columns used
AUTO_IMPORT_INDEX_DEFAULTS	SELECT	CODE, UPDATE_NUM, AGENCY_ID, CODE_DESCR, DISCOVERY_FLAG, DOC_DATE_SOURCE, EXTERNAL_VIEW_CODE, GROUP_ASSOCIATION_CODE, IMAGE_CATEGORY_CODE, IMAGE_DELETE_FLAG, IMAGE_DOCUMENT_NAME_CODE, IMAGE_DOCUMENT_TYPE_CODE, IMAGE_FILE_CODE, IMAGE_INDEX_FLAG, LONG_COMMENT, LPT_CODE, PRODUCER_ID, S_LEVEL, SOURCE, SYSTEM_GENERATED_FLAG, TASK_CATEGORY, TASK_DATE, TASK_MAIL_ID_LIST, TASK_PRIORITY, TASK_SECURITY, TASK_TEXT, UPDATE_DATE, UPDATE_USER

LINQ statement

Source: Services/SAIF.Services/Imaging/AutoImportHelperService.cs:57

// Services/SAIF.Services/Imaging/AutoImportHelperService.cs:57-60
            var indexDefaults = _unitOfWork
                .GetRepository<AutoImportIndexDefaults>()
                .Query()
                .FirstOrDefault(x => x.Code.ToUpper() == details.DocDescriptionCode.ToUpper());

Sample SQL

Inferred SQL: This SQL was inferred from the LINQ statement above and the NHibernate mappings. It is not concrete SQL from source code; NHibernate generates the executed statement at runtime, so aliases, column order, join syntax, and bind-parameter names may differ.

-- Inferred from LINQ (NHibernate mapping translation); not concrete SQL
-- Services/SAIF.Services/Imaging/AutoImportHelperService.cs:58
SELECT *
FROM (
  SELECT
    AIID.CODE,
    AIID.UPDATE_NUM,
    AIID.AGENCY_ID,
    AIID.CODE_DESCR,
    AIID.DISCOVERY_FLAG,
    AIID.DOC_DATE_SOURCE,
    AIID.EXTERNAL_VIEW_CODE,
    AIID.GROUP_ASSOCIATION_CODE,
    AIID.IMAGE_CATEGORY_CODE,
    AIID.IMAGE_DELETE_FLAG,
    AIID.IMAGE_DOCUMENT_NAME_CODE,
    AIID.IMAGE_DOCUMENT_TYPE_CODE,
    AIID.IMAGE_FILE_CODE,
    AIID.IMAGE_INDEX_FLAG,
    AIID.LONG_COMMENT,
    AIID.LPT_CODE,
    AIID.PRODUCER_ID,
    AIID.S_LEVEL,
    AIID.SOURCE,
    AIID.SYSTEM_GENERATED_FLAG,
    AIID.TASK_CATEGORY,
    AIID.TASK_DATE,
    AIID.TASK_MAIL_ID_LIST,
    AIID.TASK_PRIORITY,
    AIID.TASK_SECURITY,
    AIID.TASK_TEXT,
    AIID.UPDATE_DATE,
    AIID.UPDATE_USER
  FROM AUTO_IMPORT_INDEX_DEFAULTS AIID
  WHERE UPPER(AIID.CODE) = :DocDescriptionCode
)
WHERE ROWNUM <= 1

Translation notes: - x.Code.ToUpper() is on a mapped column -> UPPER(AIID.CODE); details.DocDescriptionCode.ToUpper() is on a captured object -> evaluated client-side into :DocDescriptionCode.

Operations and processes

• AutoImportHelperService.GenerateIdxFile — see Operations and processes

Sources

• Services/SAIF.Services/Imaging/AutoImportHelperService.cs (L58)