Timestamps and TableAdapters

June 8, 2006
No Comments.

I was having a chat with David Sceppa about TableAdapters recently when he mentioned that in the final VS 2005 bits, the TableAdapters will use timestamp fields for concurrency.  I told him flatly I didn’t think it worked, but I was wrong.  If you create a Table in a Typed DataSet in VS 2005 and include the timestamp field in the select statement, it will use the timestamp field for concurrency.  Awesome!

(Note: ASP.NET 2.0 DataSources use their own source code for concurrency so that doesn’t work at all in DataSources AFAIK.)