如何使用SQLiteCommand对象获取自动递增的ID插入行

using System.Data.SQLite;

// 创建SQLiteConnection对象
using (SQLiteConnection connection = new SQLiteConnection("Data Source=database.db"))
{
    // 打开数据库连接
    connection.Open();

    // 创建INSERT语句
    string insertSql = "INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)";

    // 创建SQLiteCommand对象
    using (SQLiteCommand command = new SQLiteCommand(insertSql, connection))
    {
        // 添加参数
        command.Parameters.AddWithValue("@Value1", "Value1");
        command.Parameters.AddWithValue("@Value2", "Value2");

        // 执行插入操作
        command.ExecuteNonQuery();
    }

    // 创建SELECT LAST_INSERT_ROWID()语句
    string selectSql = "SELECT LAST_INSERT_ROWID()";

    // 创建SQLiteCommand对象
    using (SQLiteCommand command = new SQLiteCommand(selectSql, connection))
    {
        // 执行查询操作，获取自动递增的ID
        int lastInsertId = Convert.ToInt32(command.ExecuteScalar());
        Console.WriteLine("Last Insert ID: " + lastInsertId);
    }

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