Jul 05, 2017 04:06 PM|AD83|LINK
I solved my own problem!
When I was displaying the comments on my page, I had not excluded the comments marked for a soft deletion so although the magic was working in the background, I could still see the comments! Code now changed to:
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Comments] WHERE ([Ad_ID] = @Ad_ID) AND CommentDeleted != 'Yes' ORDER BY [CommentCreationDateTime] ASC">
I'll just leave this here in the event that someone else ever makes the same error!