Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Audit Trail in C#
Message
De
25/10/2007 23:28:40
 
 
À
25/10/2007 20:52:18
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
01263434
Message ID:
01263938
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform