What is the equivalent type of SQL Timestamp in c#

Question

We have a recordversion column (Something like 0x00000000006EC935) of type timestamp in SQL. Want to have it as a string in c# code. What is equivalent type? How to convert?

Answer 1

You can map Timestamp type in sql to Byte[] in .net.

you can convert string rowVersion to byte[] and vise versa like this:

    // string rowVersion To Byte[]
    byte[] byt = System.Text.Encoding.UTF8.GetBytes(strOriginal);

    // Byte[] rowVersion to string

    strModified = Convert.ToBase64String(byt);