SQL Timestamps

Posted Tue, Apr 8 2008 22:36 by bill

I was just reading a work around for timestamps with LINQ or WCF, and I must be stupid, but I just don't get it. In fact, ever since dotnet came out mapping timestamp to a byte array or SqlBinary, I never got why they did that.  Timestamp is 8 bytes, so why not just map it to Int64 or UInt64 and for nullable timestamp columns map it to Int64? or UInt64?

Is there some reason why .NET maps it to a SQLBinary type even though we know it's a fixed size not a variable size ?

Filed under: , , ,