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); }