mardi 23 février 2016

Get number of rows affected using 'Update' or 'Delete' query in SQLite-WinRT wrapper

How to get the number of rows affected in SQLite-WinRT wrapper for Delete or Update queries? Here is the blog that describes the CRUD operations of SQLite-WinRT wrapper in Windows Runtime apps.

Some code snippet is:

var dbFile = await StorageFile.GetFileFromPathAsync(dbPath);
db = new SQLiteWinRT.Database(dbFile);
await db.OpenAsync(SqliteOpenMode.OpenReadWrite);
await db.ExecuteStatementAsync("DELETE FROM Customer WHERE Name = 'abc'");

Thanks!

Aucun commentaire:

Enregistrer un commentaire