I thought "that will be easy", but now I'm pretty much stuck on something that looked all too easy to accomplish.

Plan: A workflow that deletes the current record.

Execution: Custom workflow class (see below)

Result: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery

This is the code

public override WorkflowExecutionStatus Execute(Record record, RecordEventArgs e)
            {
                using (RecordService rs = new RecordService(record))
                {
                    rs.Delete();
                }

                return WorkflowExecutionStatus.Completed;
            }

Here are the details from UmbracoTraceLog.txt:

2013-08-08 14:35:08,368 [30] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlServerCe.SqlCeParameter, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]] - [Thread 19] Error executing query INSERT INTO UFRecordDataString([key], Value) VALUES(@key, @value)
SqlCE4Umbraco.SqlCeProviderException: Error running NonQuery: 
SQL Statement:
INSERT INTO UFRecordDataString([key], Value) VALUES(@key, @value)

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK_UFRecordDataString_UFRecordFields ]
   bei System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
   bei System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
   bei System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
   bei System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
   bei SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
   bei SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
   bei SqlCE4Umbraco.SqlCEHelper.ExecuteNonQuery(String commandText, SqlCeParameter[] parameters)
   bei umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)

Assigned to submit state

It seems to me that this issue is reported in a similar manner here:

http://our.umbraco.org/forum/umbraco-pro/contour/37335-Contour-Workflow-delete-record-database-error

http://our.umbraco.org/forum/umbraco-pro/contour/23003-workflow-delete-record-not-working

Any help would be greatly appreciated! :)

Marc.