dotnet 2026

 raodmap

when you order by two columns use this.imp

 

SELECT *

FROM dbo.tbl_WorkFlowMembers w

WHERE w.WorkFlow_ID IN (

    SELECT WorkFlow_ID

    FROM dbo.tbl_WorkFlow

    WHERE country_code = 'BE'

)

ORDER BY 

    w.WorkFlow_ID,

    w.Approver_Sequence DESC;

kAFKA CONFLUENT FREE TRAIL

 For me two promos are showing

VFREETRIAL400 $400.00 / $400.00 USD remaining Expires Jan. 13, 2026 CONFLUENTDEV1 $1.00 / $1.00 USD remaining Expires Jan. 13, 2026For me two promos are showing FREETRIAL400 $400.00 / $400.00 USD remaining Expires Jan. 13, 2026 CONFLUENTDEV1 $1.00 / $1.00 USD remaining Expires Jan. 13, 2026

Best UI

 BestUI

best UI

 https://ui-patterns.com/explore

create delete cascade

if you delete dependant record then child data also deleted 
ALTER TABLE tbl_UARRecord

ADD CONSTRAINT FK_tbl_UARRecord_tbl_UploadCycle

    FOREIGN KEY (UploadCycleId)

    REFERENCES tbl_UploadCycle(UploadCycleId)

    ON DELETE CASCADE;

DI error

 

👉 When your ExceptionHandlingMiddleware tries to resolve a scoped service directly from the app root container
(which is NOT allowed).

The fix is simple — and you’re very close.
Let me give you the correct, production-safe version.

---

✅ Root Cause

Your middleware is registered as a singleton (default), meaning:

• Middleware = Singleton

• ErrorLoggerService = Scoped

➡ Middleware cannot directly use scoped service from constructor
➡ Must resolve inside InvokeAsync() using context.RequestServices

You already attempted this — but the middleware itself still injects the service incorrectly.

---

✅ Correct Fix (100% works)

❌ WRONG (current middleware constructor injects scoped service)

public ExceptionHandlingMiddleware(RequestDelegate next, IErrorLoggerService logger)

This forces the DI system to resolve IErrorLoggerService at startup (root provider).
→ Boom: exception.

---

✅ ✔ RIGHT: Middleware must NOT receive scoped services in constructor

✔ FIXED Middleware

public class ExceptionHandlingMiddleware
{
    private readonly RequestDelegate _next;
    private readonly ILogger<ExceptionHandlingMiddleware> _logger;

    public ExceptionHandlingMiddleware(RequestDelegate next, ILogger<ExceptionHandlingMiddleware> logger)
    {
        _next = next;
        _logger = logger;
    }

    public async Task InvokeAsync(HttpContext context)
    {
        try
        {
            await _next(context);
        }
        catch (Exception ex)
        {
            // 🔥 Resolve scoped service CORRECTLY
            var errorLogger = context.RequestServices.GetRequiredService<IErrorLoggerService>();

            await errorLogger.LogErrorAsync(new ErrorLogDto
            {
                UserName = context.User?.Identity?.Name ?? "SYSTEM",
                Path = context.Request.Path,
                ErrorMessage = ex.Message
            }, ex);

            await HandleExceptionAsync(context, ex);
        }
    }
}

Notice:
✔ No scoped services in constructor
✔ Scoped service resolved inside request pipeline → valid

---

🛠 Program.cs validation (your DI is correct)

services.AddScoped<IErrorLoggerService, ErrorLoggerService>();

This is perfect.
No need to change DI.