无法让Dapper正确处理SQL RowVersion。

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    var sql = "SELECT Id, Name, RowVersion FROM YourTable WHERE Id = @Id";
    var parameters = new { Id = 1 };

    var result = connection.QueryFirstOrDefault<dynamic>(sql, parameters);

    if (result != null)
    {
        byte[] rowVersion = (byte[])result.RowVersion;
        // 处理rowVersion
    }
}

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    var sql = "UPDATE YourTable SET Name = @Name, RowVersion = @RowVersion WHERE Id = @Id AND RowVersion = @CurrentRowVersion";
    var parameters = new
    {
        Id = 1,
        Name = "NewName",
        CurrentRowVersion = currentRowVersion // 当前的RowVersion值
    };

    int affectedRows = connection.Execute(sql, parameters);

    if (affectedRows == 0)
    {
        // 并发冲突，RowVersion已更改
    }
}

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    var sql = "SELECT Id, Name, RowVersion FROM YourTable WHERE Id = @Id";
    var parameters = new { Id = 1 };

    var result = connection.QueryFirstOrDefault<dynamic>(sql, parameters);

    if (result != null)
    {
        ulong rowVersion = BitConverter.ToUInt64((byte[])result.RowVersion, 0);
        // 处理rowVersion
    }
}

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    var sql = "UPDATE YourTable SET Name = @Name, RowVersion = @RowVersion WHERE Id = @Id AND RowVersion = @CurrentRowVersion";
    var parameters = new
    {
        Id = 1,
        Name = "NewName",
        CurrentRowVersion = currentRowVersion // 当前的RowVersion值
    };

    int affectedRows = connection.Execute(sql, parameters);

    if (affectedRows == 0)
    {
        // 并发冲突，RowVersion已更改
    }
}