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;}
}