如何用C#在SQLite中获取最后插入的id？

using System.Data.SQLite;

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

// 打开数据库连接
connection.Open();

// 创建SQLiteCommand对象
SQLiteCommand command = new SQLiteCommand("INSERT INTO your_table (column1, column2) VALUES (@value1, @value2)", connection);

// 设置参数值
command.Parameters.AddWithValue("@value1", "some value");
command.Parameters.AddWithValue("@value2", "some value");

// 执行插入数据的命令
command.ExecuteNonQuery();

// 获取最后插入的id
SQLiteCommand getIdCommand = new SQLiteCommand("SELECT LAST_INSERT_ROWID()", connection);
int lastInsertedId = Convert.ToInt32(getIdCommand.ExecuteScalar());

// 关闭数据库连接
connection.Close();