Skip to content

SQL-289: Retrieve RctPolicyToTransmit via GetPoliciesToTransmit

This NHibernate LINQ query reads every row of RCT_POLICIES_TO_TRANSMIT and maps it to RctPolicyToTransmit contract objects. RctPolicyToTransmitService.GetPoliciesToTransmit uses AutoMapper enumeration to materialize the full table.

Classification

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

Parameters

None (literals only or full-table read).

Tables

Table Access Columns used
RCT_POLICIES_TO_TRANSMIT SELECT POLICY_NUM, POLICY_PERIOD_EFF_DATE, MARKET_TYPE_CODE, ORIGINAL_PP_EFF_DATE

LINQ statement

Source: Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs:32-33

// Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs:32-33
var dataPolicies = _unitOfWork.GetRepository<DataRct.RctPolicyToTransmit>().Query();
var contractPolicies = Mapper.Map<RctPolicyToTransmit[]>(dataPolicies);

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
SELECT
  RPTT.POLICY_NUM,
  RPTT.POLICY_PERIOD_EFF_DATE,
  RPTT.MARKET_TYPE_CODE,
  RPTT.ORIGINAL_PP_EFF_DATE
FROM RCT_POLICIES_TO_TRANSMIT RPTT

Translation notes: - The cited line builds an unexecuted IQueryable; Mapper.Map enumerates it, producing a full-table read.

Operations and processes

Sources

  • Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs (L32)