private string GetSetForUpdate(AuditEvent auditEvent)
{
var jsonColumnName = JsonColumnNameBuilder?.Invoke(auditEvent);
var ludColumn = LastUpdatedDateColumnNameBuilder?.Invoke(auditEvent);
var sets = new List <string>();
if (jsonColumnName != null)
{
sets.Add($"[{jsonColumnName}] = @json");
}
if (ludColumn != null)
{
sets.Add($"[{ludColumn}] = GETUTCDATE()");
}
if (CustomColumns != null && CustomColumns.Any())
{
for (int i = 0; i < CustomColumns.Count; i++)
{
sets.Add($"[{CustomColumns[i].Name}] = @c{i}");
}
}
return(string.Join(", ", sets));
}
private string GetReplaceCommandText(AuditEvent auditEvent)
{
var ludScript = LastUpdatedDateColumnNameBuilder != null?string.Format(", [{0}] = GETUTCDATE()", LastUpdatedDateColumnNameBuilder.Invoke(auditEvent)) : string.Empty;
var cmdText = string.Format("UPDATE {0} SET [{1}] = @json{2} WHERE [{3}] = @eventId",
GetFullTableName(auditEvent), JsonColumnNameBuilder.Invoke(auditEvent), ludScript, IdColumnNameBuilder.Invoke(auditEvent));
return(cmdText);
}
