Saturday, July 6, 2013

C# Linq To SQL get new inserted data (Tracking)

Is it possible to have a auto-tracking event or something similar to track the database when it changes?
For an example:

If the database gets a new insert value from another application that I currently have: then
My other application will notice it and fetch that data instead of getting the whole table each time.

Currently I have a loop that just gets the whole table each second. But I need to fetch the last change of the database. Is this possible or do I have to use a trigger in the database? Because I need to fix this without the use of a trigger.

(I only need the new change from the table, inserts, deletion & updates)

Thanks - Full Post

No comments:

Post a Comment