How to get a last inserted id with dapper and Sqlite

Just a quick code sample:

string sql = "INSERT INTO Users (Name) VALUES (@Name); select last_insert_rowid()";
 long id = connection.Query<long>(sql, user).First();

Leave a Reply

Your email address will not be published. Required fields are marked *