• For example, notice in the above screenshot that “Address Type” has a value of “1” since that is how the data is stored in the table. This number does little good for the end user, so in V2 it is now possible to customize specific properties as needed. I will explain more details about this soon. Below I am overriding the default auditing of the Product.CategoryID property by querying the category by looking up the CategoryID, returning the Category.CategoryName, and renaming the audit field to “Category” since “CategoryID” is no longer accurate.

public class ProductAuditResolver : AuditPropertyResolver
{
    protected override void CustomizeProperties()
    {
        CustomizeProperty(p => p.CategoryID, categoryId => GetCategoryByID(cid).CategoryName, "Category");
    }
}	
   

Instructions

1. Download the latest release from CodePlex, the source code and compiled DLL are available, and add reference to Doddle.Linq.Audit.dll in your project that contains your LINQ to SQL DBML
2. At a minimum you will need to add 2 tables to your database (and your DBML) to store the audit records. Please see the schema below and add these tables to your database.
   • NOTE: Keep in mind this database schema is entirely customizable. I chose to use two tables to store all of my audits, but you could very easily change this logic to use a separate table for each entity or whatever storage schema you choose.  
     
     
3. Open your DBML and click in the designer surface. In the property pane you will need to change the Base Class property of your generated DataContext to be Doddle.Linq.Audit.LinqToSql.AuditableDataContext 
   
   
   
4. Lastly you will need to create a partial DataContext class to wire up the auditing infrastructure to match your database schema. Add a new Class file to your project and insert the following code. Customize if necessary to match your auditing schema.
   

   public partial class NorthwindEntitiesDataContext
   {
       protected override void InsertAuditRecordToDatabase(EntityAuditRecord record)
       {
           AuditRecord audit = new AuditRecord();
           audit.Action = (byte)record.Action;
           audit.AuditDate = DateTime.Now;
           audit.AssociationTable = record.AssociationTable;
           audit.AssociationTableKey = record.AssociationTableKey;
           audit.EntityTable = record.EntityTable;
           audit.EntityTableKey = record.EntityTableKey;
   
           audit.UserName = HttpContext.Current.User.Identity.Name;
   
           foreach (ModifiedEntityProperty av in record.ModifiedProperties)
           {
               AuditRecordModifiedField field = new AuditRecordModifiedField();
               field.MemberName = av.MemberName;
               field.OldValue = av.OldValue;
               field.NewValue = av.NewValue;
   
               audit.AuditRecordModifiedFields.Add(field);
           }
   
           this.AuditRecords.InsertOnSubmit(audit);
       }
   
       protected override void DefaultAuditDefinitions()
       {
           this.Products.Audit();
           this.Categories.Audit().AuditAssociation(c => c.Products);
       }
   }

Known Issues

1. I have not finished the support for the Entity Framework implementation of the auditing yet. If anyone more experienced with EF is out there downloading this source please let me know if you want to help complete it.
   

Hopefully that is enough to get anyone started with the code. I am certainly looking for feedback for any suggestions, problems, or improvements. After some more unit testing and perhaps some slight refinements to the API I will remove the “beta” moniker.