WJChi.Net.EFCoreSlowQuery
2.0.0
dotnet add package WJChi.Net.EFCoreSlowQuery --version 2.0.0
NuGet\Install-Package WJChi.Net.EFCoreSlowQuery -Version 2.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="WJChi.Net.EFCoreSlowQuery" Version="2.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add WJChi.Net.EFCoreSlowQuery --version 2.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: WJChi.Net.EFCoreSlowQuery, 2.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install WJChi.Net.EFCoreSlowQuery as a Cake Addin
#addin nuget:?package=WJChi.Net.EFCoreSlowQuery&version=2.0.0
// Install WJChi.Net.EFCoreSlowQuery as a Cake Tool
#tool nuget:?package=WJChi.Net.EFCoreSlowQuery&version=2.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Summary
This is a middleware used for log EFCore slow query.
Release notes
Click here for release notes.
How to use
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:
{
"EFCoreSlowQuery": {
"ServiceName": "DemoApi",
"SlowQueryThresholdMilliseconds": 20
}
}
// will get configuration from config file
app.UseEFCoreSlowQuery();
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net8.0
- Microsoft.EntityFrameworkCore.Relational (>= 8.0.2)
- Microsoft.Extensions.Configuration.Binder (>= 8.0.1)
- Microsoft.Extensions.Logging.Abstractions (>= 8.0.0)
- Microsoft.Extensions.Options (>= 8.0.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.