Deleting records on Script Task process element
I am trying to perform the following command from a Script Task element:
DELETE FROM [dbo].[UsrListDocuments] WHERE [Opportunity] = @P1 AND [Product] = @P2
Currently, the C# code is similar to this:
var opportunityId = Get<int>("Read opportunity product.Opportunity"); var productId = Get<int>("Read opportunity product.Product"); var delete = new Delete(userConnection) .From("UsrListDocuments") .Where("Opportunity").IsEqual(opportunityId) .Where("Product").IsEqual(productId); return true;
Is this accurate? What would be the best practice in this case? The code is not working properly that´s why I am looking for your assistance.