RowVersion Tracking - Legacy Database

Question

Hi All,

I read elsewhere about row level concurrency in LS V2 and how it creates a RowVersion column to track row level changes.

I have a legacy DB which I can modify but I haven't been able to find any notes (so far) on how to add the RowVersion column and what needs to be done on the SQL DB to make it all happen.

I appreciate that a in GreenField implementation LS will do the work for me ... but I'm not sure about the Legacy DB.

Appreciate any leads...

GB

Answer 1

All I think you need to do is add a column to your tables that is of type rowversion: http://msdn.microsoft.com/en-us/library/ms182776(v=sql.105).aspx. Then, go back to LightSwitch and update the attached data source.

---

Justin Anderson, LightSwitch Development Team

Answer 2

Hi Justin,

I'm not able to get the RowVersion to 'stick' in SQL2008R2.

I understand that SSMS 2008 R2 does not know about RowVersion and does not display it in the table designer UI.

Instead I do a Create Table statement using RowVersion as the datatype (for field named RowVersion) it is displayed later as being timestamp.  Is this OK to use TimeStamp as a replacement for RowVersion ?

Thanks, GB