اسنیپت‌ها، ترفندها و کدهای کاربردی

public class SlowQueryLogInterceptor(ILogger<SlowQueryLogInterceptor> logger, long thresholdMilliseconds = 500) 
    : DbCommandInterceptor
{
    public override DbDataReader ReaderExecuted(
        DbCommand command, 
        CommandExecutedEventData eventData, 
        DbDataReader result)
    {
        CheckAndLogSlowQuery(command, eventData);
        return base.ReaderExecuted(command, eventData, result);
    }

    public override ValueTask<DbDataReader> ReaderExecutedAsync(
        DbCommand command, 
        CommandExecutedEventData eventData, 
        DbDataReader result, 
        CancellationToken cancellationToken = default)
    {
        CheckAndLogSlowQuery(command, eventData);
        return base.ReaderExecutedAsync(command, eventData, result, cancellationToken);
    }

    private void CheckAndLogSlowQuery(DbCommand command, CommandExecutedEventData eventData)
    {
        if (eventData.Duration.TotalMilliseconds > thresholdMilliseconds)
        {
            logger.LogWarning(
                "هشدار کوئری کند! زمان اجرا: {Duration}ms | متن کوئری: {Query}",
                eventData.Duration.TotalMilliseconds,
                command.CommandText);
        }
    }
}