Solved

detecting added rows of in linq

Posted on 2009-04-13
3
256 Views
Last Modified: 2013-11-11
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
Comment
Question by:TheSilverBullet
3 Comments
 
LVL 9

Expert Comment

by:Sreedhar Vengala
ID: 24133541
would this be helpful : LINQ Audit   - DoddleAudit : http://www.matthidinger.com/archive/2009/01/12/linq-audit-trail-v2.aspx
0
 

Author Comment

by:TheSilverBullet
ID: 24148108
that sounds good, but it has limitations, as the tables should use auto increment pk, and only on pk for a table!
0
 
LVL 11

Accepted Solution

by:
anyoneis earned 370 total points
ID: 24180520
TSB: The DataContext has a GetChangeSet() method which returns a ChangeSet. In there you will find properties for Inserts, Updates, and Deletes.

David
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question