How to retrieve inserted id after inserting row in SQLite using C#?

Question

I am asking the C# equivalent of this question. When I insert a row of data that has an auto-increment primary key, how can I then read the primary key back?

I need this for SQlite (this answers for SQL Server).

thanks - dave

We're using the SQlite ADO.NET connector. System.Data.SQLite version 1.0.108.0 — David Thielen, Aug 30 '18 at 15:11

score 2 · Accepted Answer · answered Aug 30 '18 at 17:34

2

// IDbCommand cmd
cmd.ExecuteScalar();
return ((SQLiteConnection) cmd.Connection).LastInsertRowId;

Very easy :)

answered Aug 30 '18 at 17:34

David Thielen

28,723
34
119
193

How to retrieve inserted id after inserting row in SQLite using C#?

1 Answers1