5.3 SQL追踪-EFCore

简介

支持对ORM框架EFCore生成并执行的SQL语句进行跟踪与分析，以方便开发人员优化程序性能。

安装依赖包

示例5.4(点击查看完整示例代码)

dotnet add package Wing.Consul

dotnet add package Wing.APM.EFCore

dotnet add package Wing.Persistence

dotnet add package FreeSql.Provider.SqlServer

Install-Package Wing.Consul

Install-Package Wing.APM.EFCore

Install-Package Wing.Persistence

Install-Package FreeSql.Provider.SqlServer

Program代码

using Wing;

var builder = WebApplication.CreateBuilder(args);

builder.Host.AddWing(builder => builder.AddConsul());

// Add services to the container.

builder.Services.AddControllers();

builder.Services.AddDbContext<EFCoreDemoContext>(options =>
        options.UseSqlServer(builder.Configuration.GetConnectionString("Wing.Demo")));
builder.Services.AddWing()
            .AddPersistence(FreeSql.DataType.SqlServer)
            .AddAPM(x => x.AddEFCore());

var app = builder.Build();

// Configure the HTTP request pipeline.

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

查看运行结果

• 运行示例5.4，浏览器访问 http://localhost:5410/weatherforecast ，可以看到该http请求追踪信息和SQL的相关信息，如下图：