Returns the number of rows changed since the database was last "quiescent".
Integer of the number of changed rows
The ChangedRows() method returns the number of rows that have been inserted, deleted, or modified since the database was last quiescent. A "quiescent" database is one in which there are no outstanding calls to Execute. In common usage, ChangedRows() returns the number of rows inserted, deleted, or modified by the most recent Execute call. The number reported includes any changes that were later undone by a ROLLBACK or ABORT. But rows that are deleted because of a DROP TABLE are not counted.
SQLite implements the command "DELETE FROM table" (without a WHERE clause) by dropping the table then recreating it. This is much faster than deleting the elements of the table individually. But it also means that the value returned from ChangedRows() will be zero regardless of the number of elements that were originally in the table. If an accurate count of the number of elements deleted is necessary, use "DELETE FROM table WHERE 1" instead.
SQLiteClient Class | SQLite.NET Namespace