Skip to content

SQL-390: Delete RctPolicyToTransmit via RemoveRctPolicyToTransmit

This statement deletes the RctPolicyToTransmit entity identified by its POLICY_NUM key from RCT_POLICIES_TO_TRANSMIT, executed via IUnitOfWork.GetRepository<T>().Delete(...) from Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs (L52) in RctPolicyToTransmitService.RemoveRctPolicyToTransmit. The SQL below is inferred from this repository call and the NHibernate RctPolicyToTransmitMap mapping — it is not literal SQL present in source.

Classification

Field Value
SQL ID SQL-390
Operation type Delete
Execution method ORM (IRepository.Delete)
Database Oracle
Schema [unqualified]**
Command type N/A (ORM-generated)
Business object RctPolicyToTransmit
Criteria property N/A — ORM
Lifecycle method RemoveRctPolicyToTransmit

Parameters

Parameter Direction Type Max length Description
:PolicyNumber Input long N/A Identifier of the RctPolicyToTransmit being deleted (POLICY_NUM)

Tables

Table Access Columns used
RCT_POLICIES_TO_TRANSMIT DELETE POLICY_NUM

LINQ statement

Source: Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs:52. The entity is mapped from policyToTransmit at line 50.

// Services/SAIF.Services/Rct/RctPolicyToTransmitService.cs:50
var dataPolicyToTransmit = Mapper.Map<DataRct.RctPolicyToTransmit>(policyToTransmit);

_unitOfWork.GetRepository<DataRct.RctPolicyToTransmit>().Delete(dataPolicyToTransmit);

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
DELETE FROM RCT_POLICIES_TO_TRANSMIT
WHERE POLICY_NUM = :PolicyNumber

Translation notes:

  • The entity is a detached instance from Mapper.Map (line 50); deleted by identifier POLICY_NUM.

Operations and processes

Sources

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