/// <summary> /// This method registers in the current SQL Transaction a command to perform the /// Delete of a SubTask entity /// </summary> private void CreateSqlCommandToDeleteSubTask(int parentTaskId, int childTaskId) { const string paramNameParentTaskId = "@ParentTaskId"; const string paramNameChildTaskId = "@ChildTaskId"; var paramParentTaskId = new SqlParameter(paramNameParentTaskId, parentTaskId); var paramChildTaskId = new SqlParameter(paramNameChildTaskId, childTaskId); var rawSqlString = $"DELETE SubTasks WHERE ParentTaskId = {paramNameParentTaskId} and ChildTaskId = {paramNameChildTaskId} "; var rawSQlCommand = new RawSQlCommand(rawSqlString, new object[] { paramParentTaskId, paramChildTaskId }); //Include comand to a Listof commands that will be checked when the Commit is performed _uow.AddRawCommand(rawSQlCommand); }