private string GetInsertCommandText(AuditEvent auditEvent)
{
return(string.Format("INSERT INTO {0} ([{1}]) OUTPUT CONVERT(NVARCHAR(MAX), INSERTED.[{2}]) AS [Id] VALUES (@json)",
GetFullTableName(auditEvent),
JsonColumnNameBuilder.Invoke(auditEvent),
IdColumnNameBuilder.Invoke(auditEvent)));
}
private string GetSelectCommandText(AuditEvent auditEvent)
{
var cmdText = string.Format("SELECT [{0}] As [Id] FROM {1} WHERE [{2}] = @eventId",
JsonColumnNameBuilder.Invoke(auditEvent),
GetFullTableName(auditEvent),
IdColumnNameBuilder.Invoke(auditEvent));
return(cmdText);
}
private string GetReplaceCommandText(AuditEvent auditEvent)
{
var cmdText = string.Format("UPDATE {0} SET {1} WHERE [{2}] = @eventId",
GetFullTableName(auditEvent),
GetSetForUpdate(auditEvent),
IdColumnNameBuilder.Invoke(auditEvent));
return(cmdText);
}
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);
}
