locked
RowVersion Tracking - Legacy Database RRS feed

  • 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

    Sunday, August 5, 2012 9:28 PM

Answers

All replies

  • 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

    • Marked as answer by GarryB2506 Thursday, August 9, 2012 4:30 AM
    Thursday, August 9, 2012 12:39 AM
    Moderator
  • 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

    Thursday, August 9, 2012 5:20 AM