Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Audit Trail in C#
Message
From
25/10/2007 23:28:40
 
 
To
25/10/2007 20:52:18
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01263434
Message ID:
01263938
Views:
12
As Kevin mentioned, you shouldn't be relying on code for the audit trail. You should be relying on the DB to maintain the trail. Using Triggers to insert records into the history table.

>Hi Kevin,
>
>Thanks for replying. I use SQL Server 2005 for the database and Mere Mortals for the business objects.
>
>I would like to create an audit trail of which user edited which information on a particular module of our system. By the way, the system is an Inventory System. It has several modules like Purchase Requests; Purchase Orders; Stock Transfer etc...
>
>We would like to record an audit of a paticular document like Purchase Order for an example. We would like to know which user encoded or edited the document. We would also like to record the original document and line items as well as the edited one.
>
>There are articles that I stumbled in the web that suggest on using Generics when building an audit trail. Unfortunately, the example is not clearly stated specially for beginners like me.
>
>Thanks in advance...

(On an infant's shirt): Already smarter than Bush
Previous
Reply
Map
View

Click here to load this message in the networking platform