Home

Deleting a row

Select historical data

From .NET code

Use DataInterface.AuditedDelete, as demonstrated in the following code sample. For more information, see the documentation.

    dataInterface.AuditedDelete(UserID, "tblCompany", 12);

From SQL CLR

Use CLR_SqlRetroview_AuditedUpdate, as demonstrated in the following code sample. Note that if your connection has an associated UserID (Using SetCurrentUserID) you may pass null instead, and the associated UserID will be used.

    
    EXEC dbo.CLR_SqlRetroview_AuditedDelete 'tblCompany', 
        12, @UserID