2

The requirement is to track all changes made to an entity, track it to know who did it, when he did, etc. For example, I have a Person entity, and a user has changed the name of the person; I'd like to keep that information somewhere.

What's the best approach for this? Or is there an existing framework to achieve this.

I know that SQL 2008 has support for tracking changes, but it's not an option for now, because a lot of our customers are already using SQL 2005.

Is the Logging Application Block of Enterprise Library a good candidate for this requirement? I've check it out a little bit but, I don't see how I can use it to track the who did it, what value has change, when he did it, etc.

We are using C# and .NET framework for our app.

tshepang
  • 12,111
  • 21
  • 91
  • 136
pdiddy
  • 6,217
  • 10
  • 50
  • 111
  • Has someone ever used the Logging Application Block of Enterprise Library to achieve this? – pdiddy Oct 30 '09 at 14:55
  • Very similar to this question: http://stackoverflow.com/questions/1051449/ideas-on-database-design-for-capturing-audit-trails – Shiraz Bhaiji Oct 30 '09 at 13:03
  • possible duplicate of [Tracking changes in a SQL server 2005 database](http://stackoverflow.com/questions/299931/tracking-changes-in-a-sql-server-2005-database) – Jonathan Leffler Oct 02 '13 at 04:31

2 Answers2

1

Standrad way is to use events from INotifyPropertyChanging and INotifyPropertyChanged interfaces. And for collections INotifyCollectionChanged. Once you subscribed to this events you can store information wherever you want.

If you using MSSQL you can try Query Notifications

Ilya Khaprov
  • 2,546
  • 14
  • 23
0

Some sort of AOP solution (like the one in enterprise library) should provide you with enough possibilities to create such a solution.

You can subscribe to a property-invoke method and log the information.

Jan Jongboom
  • 26,598
  • 9
  • 83
  • 120
  • 1
    AOP stands for Aspect-Oriented Programming. – Ronald Wildenberg Oct 30 '09 at 13:51
  • You would have an aspect representing changes to your business objects. You can define the function that has to be invoked when changing a property. Therefore you can add logging in your business code, so not only when doing the database query but also when just being in your business layer. – Jan Jongboom Nov 02 '09 at 13:40