在ASP.NetCore中使用MiniProfiler的方法

dotnet add package MiniProfiler.AspNetCore.Mvc

 // This method gets called by the runtime. Use this method to add services to the container.
    public void ConfigureServices(IServiceCollection services)
    {
      services.AddControllersWithViews();

      services.AddMiniProfiler(optiOns=> options.RouteBasePath = "/profiler");
    }

 public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ILoggerFactory loggerFactory)
    {
      app.UseMiniProfiler();

      app.UseEndpoints(endpoints =>
      {
        endpoints.MapControllerRoute(
          name: "default",
          pattern: "{cOntroller=Home}/{action=Index}/{id&＃63;}");
      });
    }

@using StackExchange.Profiling
@addTagHelper *, MiniProfiler.AspNetCore.Mvc

 public class HomeController : Controller
  {
    ILogger logger;

    public HomeController(ILogger logger)
    {
      this.logger = logger;
    }

    public IActionResult Index()
    {
      var miniProfiler = MiniProfiler.Current;
      List authors = new List();

      miniProfiler.RenderIncludes(this.HttpContext);

      using (miniProfiler.Step("Get Authors"))
      {
        authors.Add(new Author() { Id = 1, FirstName = "Joydip", LastName = "Kanjilal", Address = "Hyderabad, India" });
        authors.Add(new Author() { Id = 2, FirstName = "Stephen", LastName = "Smith", Address = "NY, USA" });
        authors.Add(new Author() { Id = 3, FirstName = "Anand", LastName = "Narayanan", Address = "Chennai, India" });
        authors.Add(new Author() { Id = 4, FirstName = "Steve", LastName = "Jones", Address = "London, UK" });
      }
      return View(authors);
    }
  }

  public class Author
  {
    public int Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Address { get; set; }
  }

using (MiniProfiler.Current.Ignore())
{
 // Write code here that you don"t
 // want MiniProfiler to profile
}

   public IActionResult Index()
    {
      using (SqlConnection cOnnection= new SqlConnection(@"Data Source=.; Initial Catalog=PYZ_L; Trusted_COnnection=Yes"))
      {
        using (ProfiledDbConnection profiledDbCOnnection= new ProfiledDbConnection(connection, MiniProfiler.Current))
        {
          if (profiledDbConnection.State != System.Data.ConnectionState.Open)
          {
            profiledDbConnection.Open();
          }

          using (SqlCommand command = new SqlCommand("Select * From Clothes", connection))
          {
            using (ProfiledDbCommand profiledDbCommand = new ProfiledDbCommand(command, connection, MiniProfiler.Current))
            {
              var data = profiledDbCommand.ExecuteReader();
              //Write code here to populate the list of Authors
            }
          }
        }
      }

      return View();
    }