05 Ağustos 2012 Pazar 21:28
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...
09 Ağustos 2012 Perşembe 00:39ModeratörAll 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
- Yanıt Olarak İşaretleyen GarryB2506 09 Ağustos 2012 Perşembe 04:30
09 Ağustos 2012 Perşembe 05:20
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 ?