Audit by using CreatedDateTime, CreatedBy

This is a question regarding an answer on a previous post entitled:
CreatedDateTime, CreatedBy, UpdatedDateTime and UpdatedBy

Ive implemented the code A Method to Handle Audit Fields in LINQ to SQL mentioned above and it works perfectly for string values. When I try referencing a date column, I keep getting the following error:

'DataRecord' does not implement interface member 'IAuditable.ChangedDate'. 'DataRecord.ChangedDate' cannot implement 'IAuditable.ChangedDate' because it does not have the matching return type of 'System.DateTime'.

Ive tried different date types in SQL 2008 (date / datetime / datetime2). Ive tried changing the type in the interface to different data types (System.Data.SqlTypes.SqlDateTime). Ive even tried converting between date types in ProcessAuditFields but with no luck.

Im probably doing something really silly, but I just cant seem to find it.I have a table with multiple columns, including 2 for audit. The Audit columns are called: ChangedDate (datetime) and ChangedUser (nvarchar(50)). Code:

internal interface IAuditable
    {
         
        string ChangedUser { get; set; }
        DateTime ChangedDate { get; set; }
 
    }
 
        private static void ProcessAuditFields(IList<System.Object> list)
        {
            foreach (var item in list)
            {
                IAuditable entity = item as IAuditable;
                if (entity != null)
                {
           
                        entity.ChangedUser = GetUserName();
                        entity.ChangedDate = DateTime.Now;
 
            
                }
            }
        }

I treat both INSERTS and UPDATES the same.

Does anyone have any ideas?

Many thanks

Re: Audit by using CreatedDateTime, CreatedBy

erwee
'DataRecord' does not implement interface member 'IAuditable.ChangedDate'.

Hello

This means your DataRecord class hasn't got a method that comes from IAuditable.ChangedDate

erwee
'DataRecord.ChangedDate' cannot implement 'IAuditable.ChangedDate' because it does not have the matching return type of 'System.DateTime'.

Please check whether your ChangedData is THE SAME AS WHAT you've defined in the interface's method(Must be the same namesame parameters in numberorder and typesand your return type should be also the same)

Best reguards

Re: Audit by using CreatedDateTime, CreatedBy

Hi Erwee, I use this all the time with EF mostly now but have recently implemented in L2S. Can you post you metadata classes please (what you are applying the IAuditable interface). also can you identify what line the error occurs on, is it in the model or the helper?