How Do I Read A Rowversion or Timestamp SQL Server Data Type From a SQLDataReader to a C# Variable

Question

I have a SQL Server 2012 database. Each table has a set of audit fields. One is a column named RowVer with a datatype of timestamp (same as rowversion).

I'm having difficulty reading the value from a SqlDataReader into a C# object with a property named User.RowVersion with a datatype of Byte[].

Code Snippet of while (rdr.Read()) block

...
user.DateCreated = rdr.GetDateTime(14);
user.CreatedByUserId = rdr.GetInt32(15);
if (!rdr.IsDBNull(16)) { user.DateLastUpdated = rdr.GetDateTime(16); }
if (!rdr.IsDBNull(17)) { user.LastUpdatedByUserId = rdr.GetInt32(17); }
user.RowVersion = rdr.???;
...

The RowVersion value is only used as a comparison for concurrency when updating the database.

This of course is NOT an EF implementation.

Scott Chamberlain · Accepted Answer · 2015-10-08 00:47:36Z

8

If you are using .NET 4.5 or newer you can do

user.RowVersion = rdr.GetFieldValue<byte[]>(18);

If you are on 4.0 or older you will need to perform a cast.

user.RowVersion = rdr.GetValue(18) as byte[];

answered Oct 8, 2015 at 0:47

Scott Chamberlain

128k37 gold badges299 silver badges448 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richard Over a year ago

Perfect, thanks! First option worked fine. I knew this was easy, but I couldn't find the answer and I couldn't remember how to do it, thanks!

Joel Coehoorn · Accepted Answer · 2015-10-08 00:58:20Z

3

One option is to handle this at the SQL level with the CONVERT() function, where it maps nicely to BIGINT:

CONVERT(BIGINT, MyRowVersionColumn)

And now you can read it easily into an Int64:

user.RowVersion = rdr.GetInt64(18);

That will, of course, mean changing the datatype of your object, but you may that this is a good thing.

If you want to keep the byte array, you can do this:

rdr.GetBytes(18, 0, user.RowVersion, 0, rdr.GetBytes());

Or, since the length of the field is known:

rdr.GetBytes(18, 0, user.RowVersion, 0, 8);

answered Oct 8, 2015 at 0:58

Joel Coehoorn

419k114 gold badges582 silver badges820 bronze badges

Collectives™ on Stack Overflow

How Do I Read A Rowversion or Timestamp SQL Server Data Type From a SQLDataReader to a C# Variable

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related