SQL-087: Retrieve AuthorityBusinessProcessCode via CreateNewAuthorityLimitFromEdit¶

This ORM statement performs a read operation on AuthorityBusinessProcessCode via IUnitOfWork.GetRepository<T>(), executed from Services/SAIF.Services/Claims/Authority/ClaimAuthorityService.cs (L438).

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`((int)businessProcessType).ToString()`	Input	**	N/A	`a.Code == ((int)businessProcessType).ToString()` → column Code*

Tables¶

Table	Access	Columns used
CL_CLAIM_BUS_PROCESS_CODE	SELECT	`CODE`, `UPDATE_NUM`, `CODE_DESCR`, `UPDATE_DATE`, `UPDATE_USER`

LINQ statement¶

Source: Services/SAIF.Services/Claims/Authority/ClaimAuthorityService.cs:438

// Services/SAIF.Services/Claims/Authority/ClaimAuthorityService.cs:438
            var businessProcess = _unitOfWork.GetRepository<CodeTable.AuthorityBusinessProcessCode>().Query().Single(a => a.Code == ((int)businessProcessType).ToString());

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/Claims/Authority/ClaimAuthorityService.cs:438
SELECT
  CCBPC.CODE,
  CCBPC.UPDATE_NUM,
  CCBPC.CODE_DESCR,
  CCBPC.UPDATE_DATE,
  CCBPC.UPDATE_USER
FROM CL_CLAIM_BUS_PROCESS_CODE CCBPC
WHERE CCBPC.CODE = :businessProcessType
-- NHibernate expects at most one row

Translation notes: - ((int)businessProcessType).ToString() is evaluated client-side -> string bind :businessProcessType.

Operations and processes¶

ClaimAuthorityService.CreateNewAuthorityLimitFromEdit — see Operations and processes

Sources¶

Services/SAIF.Services/Claims/Authority/ClaimAuthorityService.cs (L438)