LinqToSql Plus Audit

UseAudit

Gets or sets if INSERTED and DELETED data from the database should be returned as AuditEntries.

List<AuditEntry> auditEntries = new List<AuditEntry>();

context.BulkMerge(options =>
{
	options.UseAudit = true;
	options.BulkOperationExecuted = bulkOperation => auditEntries.AddRange(bulkOperation.AuditEntries);
});

AuditEntries

Gets INSERTED and DELETED data when UseAudit option is enabled.

List<AuditEntry> auditEntries = new List<AuditEntry>();

context.BulkMerge(options =>
{
	options.UseAudit = true;
	options.BulkOperationExecuted = bulkOperation => auditEntries.AddRange(bulkOperation.AuditEntries);
});

foreach (var entry in auditEntries)
{
    foreach (var value in entry.Values)
    {
        var oldValue = value.OldValue;
        var newValue = value.NewValue;
    }
}



Prime Library

Performance

Expression Evaluator

More Projects...