从Dapper/PostgreSQL返回插入项的UUID

using Dapper;
using Npgsql;

public class UserRepository
{
    private readonly string connectionString;

    public UserRepository(string connectionString)
    {
        this.connectionString = connectionString;
    }

    public Guid InsertUser(User user)
    {
        using (var connection = new NpgsqlConnection(connectionString))
        {
            connection.Open();

            // 生成新的UUID
            Guid uuid = Guid.NewGuid();

            // 执行插入语句，并返回生成的UUID
            connection.Execute("INSERT INTO Users (Id, Name) VALUES (@Id, @Name)", new { Id = uuid, Name = user.Name });

            return uuid;
        }
    }
}