A middleware used for log EFCore slow query.
$ dotnet add package WJChi.Net.EFCoreSlowQueryThis is a middleware used for log EFCore slow query.
Click here for release notes.
A complete example can be found here.
using Api.Database;
using EFCoreExtensions.Middlewares;
using Microsoft.EntityFrameworkCore;
var builder = WebApplication.CreateBuilder(args);
// Add services to the container.
builder.Services.AddControllers();
builder.Services.AddDbContext<InfoDbContext>(opt =>
{
opt.UseSqlServer("Server = localhost;Database = Demo;User ID = sa;Password = Docker2022!;Application Name = EFCore;");
});
var app = builder.Build();
// Configure the HTTP request pipeline.
// Configuration via code
app.UseEFCoreSlowQuery(opt =>
{
opt.ServiceName = "DemoApi";
opt.SlowQueryThresholdMilliseconds = 20;
});
app.MapControllers();
app.Run();
Also support configure via configuration file:
builder.Services.Configure<EFCoreSlowQueryOptions>(builder.Configuration.GetSection(EFCoreSlowQueryOptions.OptionsName));
app.UseEFCoreSlowQuery();
{
"EFCoreSlowQuery": {
"ServiceName": "DemoApi",
"SlowQueryThresholdMilliseconds": 20
}
}