• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

detecting added rows of in linq

in a datatable I have kind of row status (new, added ,deleted..), this is whether the datatable is filled by an adapter of a stored procedure or a table. now in linq with a list filled by a stored procedrue, how to track the deleted/added/modified rows?
0
TheSilverBullet
Asked:
TheSilverBullet
1 Solution
 
Sreedhar VengalaSr. Consultant - Business IntelligenceCommented:
would this be helpful : LINQ Audit   - DoddleAudit : http://www.matthidinger.com/archive/2009/01/12/linq-audit-trail-v2.aspx
0
 
TheSilverBulletAuthor Commented:
that sounds good, but it has limitations, as the tables should use auto increment pk, and only on pk for a table!
0
 
anyoneisCommented:
TSB: The DataContext has a GetChangeSet() method which returns a ChangeSet. In there you will find properties for Inserts, Updates, and Deletes.

David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now