Program.cs

using Microsoft.Data.SqlClient;
using Microsoft.EntityFrameworkCore;
using Nest;
using Serilog;
using Serilog.Events;
using SQLServerVsElastic.Data;

Log.Logger = new LoggerConfiguration()
    .MinimumLevel.Override("System", LogEventLevel.Warning)
    .MinimumLevel.Override("Microsoft", LogEventLevel.Warning)
    .MinimumLevel.Override("Microsoft.EntityFrameworkCore", LogEventLevel.Warning)
    .MinimumLevel.Override("Microsoft.AspNetCore", LogEventLevel.Warning)
    .MinimumLevel.Override("Microsoft.Hosting.Lifetime", LogEventLevel.Information)
    .WriteTo.Console()
    .CreateLogger();

try
{
    var builder = WebApplication.CreateBuilder(args);

    builder.Services.AddControllers();
    builder.Services.AddSerilog();

    var connectionStringBuilder = new SqlConnectionStringBuilder(builder.Configuration.GetConnectionString("SqlServer"))
    {
        Encrypt = true,
        TrustServerCertificate = true,
        IntegratedSecurity = false
    };

    builder.Services.AddDbContext<TestDbContext>(options =>
        options.UseSqlServer(connectionStringBuilder.ConnectionString));

    builder.Services.AddSingleton<IElasticClient>(new ElasticClient(
        new ConnectionSettings(new Uri("http://localhost:9200"))
    ));

    var app = builder.Build();

    using (var scope = app.Services.CreateScope())
    {
        var dbContext = scope.ServiceProvider.GetRequiredService<TestDbContext>();
        dbContext.Database.Migrate();
    }

    app.UseSerilogRequestLogging(options =>
    {
        options.IncludeQueryInRequestPath = true;
    });
    app.UseRouting();
    app.MapControllerRoute(
        name: "default",
        pattern: "api/{controller}/{action=Index}/{id?}");

    app.Run();
}
catch (Exception ex)
{
    Log.Fatal(ex, "Application terminated unexpectedly");
}
finally
{
    Log.CloseAndFlush();
}