?
Solved

detecting added rows of in linq

Posted on 2009-04-13
3
Medium Priority
?
262 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 1480 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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…
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

752 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