Can the differences found with Snapshotting be reported?

[erict-powersoft]

We're using Snapshotting to update database records. I need to report which columns are being changed, with before and after values. Is there a way to do this with Snapshotting or do I need to roll my own comparison code for columns? and if so - can you think of a way to do this generically?
Thanks!

[schotime]

Have a look at these tests, but yes, the updated columns are in there.

https://github.com/schotime/NPoco/blob/master/test/NPoco.Tests/SnapshotterTests.cs

[tbasallo]

This is a bit old, but I have some code that does some work around that. I'd probably tweak if I did it again. But this works well, for years now as an audit of changed items.

 public static List<PropertyComparison> AsPropertyComparison<T>(this List<NPoco.Snapshot<T>.Change> changes)      
 {
        return changes.Where(d =>
               (d.OldValue != null && d.NewValue != null && d.OldValue.ToString() != d.NewValue.ToString())
            || (d.OldValue != null && d.NewValue == null)
            || (d.NewValue != null && d.OldValue == null)).Select(d => new PropertyComparison(d.ColumnName, d.OldValue, d.NewValue)).ToList();
    }

Where PropertyComaprison looks like this:

public class PropertyComparison
{
    public PropertyComparison() { }
    public PropertyComparison(string name, object? oldValue, object? newValue)
    {
        Name = name;
        if (oldValue != null)
        {
            Type = oldValue.GetType().Name;
            OldValue = oldValue.ToString() ?? "";
        }
        if(newValue != null)
        {
            if (Type == null)
            {
                Type = newValue.GetType().Name;
            }
            NewValue = newValue.ToString() ?? "";
        }
    }


    public string Name { get; set; } = null!;
    public string OldValue { get; set; } = null!;
    public string NewValue { get; set; } = null!;
    public string Type { get; set; } = null!;
}