# Delete record in RO/DA service with business rules trigger

**URL:** https://talk.remobjects.com/t/delete-record-in-ro-da-service-with-business-rules-trigger/31009
**Category:** Data Abstract
**Tags:** net
**Created:** [November 14, 2024, 3:04pm UTC](https://talk.remobjects.com/t/delete-record-in-ro-da-service-with-business-rules-trigger/31009 "2024-11-14T15:04:08Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![fvancrae](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/f/ad7895/32.png) [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [November 14, 2024, 3:04pm UTC](https://talk.remobjects.com/t/delete-record-in-ro-da-service-with-business-rules-trigger/31009/1 "2024-11-14T15:04:08Z")

</div>

I have some code in a RODA service on the server side to delete rows from a table that must execute the businessprocessor rules

My code works but I achieve it by fetching the data from the DB.  
Is there a way to achive this without the DB fetch?

This is my code now

```
 var deltas = new List<Delta>();
 var dataTable = DB2RemObjectsUtil.GetDataTableFromROBinary(tabledata, TableName);
 foreach (DataRow row in dataTable.Rows)
 {
   int pk = (int)row[KeyFieldName];
   if (deleteList.ContainsKey(pk))
   {
     row.Delete();
     var delta = new Delta(dataTable);
     delta.Add(row);
     deltas.Add(delta);
   }
 }
 using (var dataAdapter=service.GetDataAdapter())
 {
   dataAdapter.Update(deltas.ToArray());            
 }

```

---

<div class="post-metadata">

### Author: ![EvgenyK](https://talk.remobjects.com/user_avatar/talk.remobjects.com/evgenyk/32/16_2.png) [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [November 15, 2024, 6:45am UTC](https://talk.remobjects.com/t/delete-record-in-ro-da-service-with-business-rules-trigger/31009/2 "2024-11-15T06:45:17Z")

</div>

Hi,

Use [LocalCommand](https://docs.dataabstract.com/API/NET/Classes/LocalCommand/) .  
This class supports [Business Rules Scripting API](https://docs.dataabstract.com/Technologies/BusinessRulesScripting/API/) .