In this 15 minutes video blog I will explain the magic (or not so magicJ) that I’m doing in the LinqHelper client and server classes for enabling client side change tracking with LINQ to SQL.
If you didn’t watch the first part I encourage you to watch it first: http://blogs.msdn.com/swiss_dpe_team/archive/2008/04/04/crud-operations-with-optimistic-locking-using-silverlight-2-beta1-wcf-and-linq-to-sql-inserts-updates-and-deletes.aspx
Attached to the mentioned video blog is the sample code.
- it is not production code, it is a sample to show one approach to change tracking in multi tier architecture with LINQ to SQL
- there are for sure better solutions and feel free to submit your ideas and improvements.
- works only with tables with Primary Key as single column
- works with timestamps or original values
- it is not fully tested (or better is not tested at allJ) with different tables/data types etc…
double click the player to play in fullscreen