在C#中使用SQLite.NET获取最后一个插入ID

using System.Data.SQLite;

// 创建SQLite连接对象
SQLiteConnection connection = new SQLiteConnection("Data Source=your_database.db");

connection.Open();

SQLiteCommand command = new SQLiteCommand("INSERT INTO your_table (column1, column2) VALUES (@value1, @value2); SELECT last_insert_rowid();", connection);
command.Parameters.AddWithValue("@value1", value1);
command.Parameters.AddWithValue("@value2", value2);

int lastInsertId = Convert.ToInt32(command.ExecuteScalar());

connection.Close();