SubSonic 3.0.0.3 | Data Access Layer - Audit trails

Posted by No Body on Stack Overflow See other posts from Stack Overflow or by No Body
Published on 2009-08-08T05:36:14Z Indexed on 2010/04/29 0:17 UTC
Read the original article Hit count: 646

Filed under:
|
|

Hi guys how do you implementing an Audit Trails on all objects/class on SubSonic under Data Access Layer?

If what I want is, all changes on all objects will be recorded on a single table/object.

public class AuditTrail
{
   public int Id { get; set; }
   public string SourceObjectName { get; set; }
   public int RowPK { get; set; } // Id of the SourceObject
   public string ChangeType {get; set;} // value such as "Add", "Update", "Delete"
   public string RowCapture { get; set; } // Id="6" UserId="xxx3" SurName="NoBodyx" FirstName="no3" MiddleName="B." Email="[email protected]" CreatedDate="8/6/2009 1:57:58 PM" CreatedBy="ca3" UpdatedDate="8/7/2009 5:58:37 AM" UpdatedBy="qqq" Name="no3 B. NoBodyx"
   public CreatedDate {get; set;}
}

© Stack Overflow or respective owner

Related posts about subsonic

Related posts about subsonic3