I have an IIS application under Windows Server that needs to keep an external MS SQL Server db in sync with Hana. I have to use the Service Layer interface, because the DI API dll has memory leaks and crashes regularly.
There is no direct ContactEmplyees entity in SL. I found a way to keep the contact persons synched via PATCHes on the BusinessPartners entity. Patches with an existing InternalCode update the contact information, while patches without InternalCode insert new contact persons under the provided CardCode.
I didn't find a way of deleting them. If I use DELETE, this will remove the whole Business Partner. Any ideas? A solution I though of is using the ADO OleDb provider, but AFAIK this is discuraged for manipulating data.