DbExtensions - WHERE parameter with byte[] value (timestamp)

304 Views Asked by At

I am using this code

updateBuilder
    .UPDATE("myTable")
    .SET("UpdatedDate = {0}", updated.UpdatedDate)
    .SET("UpdatedByUserId = {0}", updated.UpdatedByUserId)
    .WHERE("Id = {0}", updated.Id)
    .WHERE("RowVersion = {0}", updated.RowVersion);

And the SQL it generates is like this

exec sp_executesql N'UPDATE myTable
SET UpdatedDate = @p0, UpdatedByUserId = @p1
WHERE Id = @p2 AND RowVersion = @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10

I am guessing that it is adding a value for each element in the byte array, as the property RowVersion = byte[], but how do i fix this?

In entity framework the byte[] is added in SQL like this

@3=0x0000000000560F94

How can i get my byte array to be this?

1

There are 1 best solutions below

0
On BEST ANSWER

This is a known issue, the answer is here.