WJChi.Net.EFCoreSlowQuery 3.0.0

.NET 9.0

dotnet add package WJChi.Net.EFCoreSlowQuery --version 3.0.0

NuGet\Install-Package WJChi.Net.EFCoreSlowQuery -Version 3.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="3.0.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="WJChi.Net.EFCoreSlowQuery" Version="3.0.0" />
                    

                            Directory.Packages.props

<PackageReference Include="WJChi.Net.EFCoreSlowQuery" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add WJChi.Net.EFCoreSlowQuery --version 3.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: WJChi.Net.EFCoreSlowQuery, 3.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.

#:package WJChi.Net.EFCoreSlowQuery@3.0.0

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=WJChi.Net.EFCoreSlowQuery&version=3.0.0
                    

                            Install as a Cake Addin

#tool nuget:?package=WJChi.Net.EFCoreSlowQuery&version=3.0.0
                    

                            Install as a Cake Tool

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	Compatible and additional computed target framework versions.
.NET	net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net9.0
- Microsoft.EntityFrameworkCore.Relational (>= 9.0.0)
- Microsoft.Extensions.Configuration.Binder (>= 9.0.0)
- Microsoft.Extensions.Logging.Abstractions (>= 9.0.0)
- Microsoft.Extensions.Options (>= 9.0.0)

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.