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?
This is a known issue, the answer is here.