public void AddCheckedPost(string postId) { try { SQLCmd_AddCheckedPost.Parameters["@postID"].Value = postId; SQLCmd_AddCheckedPost.ExecuteNonQuery(); } catch (SQLiteException ex) when(ex.ResultCode == SQLiteErrorCode.Constraint) { throw new InvalidOperationException($"the post {postId} already exists in the database"); } }
private bool disposedValue = false; // To detect redundant calls protected virtual void Dispose(bool disposing) { if (!disposedValue) { if (disposing) { SQLCmd_AddBotComment.Dispose(); SQLCmd_AddCheckedComment.Dispose(); SQLCmd_DoesBotCommentExist.Dispose(); SQLCmd_GetBotComment.Dispose(); SQLCmd_HasCommentBeenChecked.Dispose(); SQLCmd_HasPostBeenChecked.Dispose(); SQLCmd_AddCheckedPost.Dispose(); SQLCmd_UpdateBotComment.Dispose(); dbConnection.Dispose(); // TODO: dispose managed state (managed objects). } // TODO: free unmanaged resources (unmanaged objects) and override a finalizer below. // TODO: set large fields to null. disposedValue = true; } }