SQL-361: Delete AuditedServiceOverride via Delete¶

This ORM statement deletes an EDI_AUDITED_SERVICE_OVERRIDE row identified by its composite key, executed from Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs (L170). The SQL below is inferred from the IRepository<AuditedServiceOverride>.Delete call and the AuditedServiceOverride NHibernate mapping, not literal SQL text in source.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Id`	Input	long?	N/A	Identifier of the AuditedServiceOverride being deleted (`BILL_ID`)
`:AuditId`	Input	long?	N/A	Identifier of the AuditedServiceOverride being deleted (`AUDIT_SEQ_NUM`)

Tables¶

Table	Access	Columns used
EDI_AUDITED_SERVICE_OVERRIDE	DELETE	`BILL_ID`, `AUDIT_SEQ_NUM`

LINQ statement¶

Source: Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs:170. The entity is loaded on the preceding line, Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs:169.

// Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs:169
var auditedServiceOverride = GetOverrideById(id, billId);
unitOfWork.GetRepository<DataModel.AuditedServiceOverride>().Delete(auditedServiceOverride);

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 EDI_AUDITED_SERVICE_OVERRIDE
WHERE BILL_ID = :Id
  AND AUDIT_SEQ_NUM = :AuditId

Translation notes:

Composite key (BILL_ID, AUDIT_SEQ_NUM); entity loaded by GetOverrideById(id, billId) (line 169) - a separate read.

Operations and processes¶

AuditedServiceOverrideService.Delete — see Operations and processes

Sources¶

Services/SAIF.Services/Edi/AuditedServiceOverrideService.cs (L170)