SQLite Forum

ADO.NET INSERT/UPDATE RETURNING statement question
Login
Hello, I have a few question when i using INSERT/UPDATE RETURNING statement.
``` sql
CREATE TABLE "test" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" text
);
INSERT INTO "test"("name") VALUES ('johnny') RETURNING "id","name";
UPDATE "test" as a set "name" = 'SAM' WHERE (a."id" = 1) RETURNING "id","name";
```
It worked, but 

1. The return value of [RecordsAffected] at System.Data.SQLite.SQLiteDataReader *is -1*, So I don't know how to judge thas rows has been affected.

2. The return columns at System.Data.SQLite.SQLiteDataReader names '"id"' and '"name"', *Column names containing quotation marks('"')*, but this problem does not appear in SELECT statement.

Are they correct or should they be?

SQLite version is ``3.55.5``

Nuget Package is:
```
<PackageReference Include="System.Data.SQLite.Core" Version="1.0.114.3" />
```