What about the return value of RecordsAffected at System.Data.SQLite.SQLiteDataReader is -1 question? Is that what you designed or is it a bug?
``` C#
var affrows = 0;
long id = 0;
string name = null;
using (var conn = new SQLiteConnection(MainConnectionString))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"UPDATE ""test"" AS a SET ""name"" = 'Sam' WHERE (a.""id"" = 1) RETURNING id,name";
var reader = cmd.ExecuteReader();
while (reader.Read())
{
id = Convert.ToInt64(reader["id"]);
name = reader["name"].ToString();
}
affrows = reader.RecordsAffected; // result is -1.
}
```