由实体框架 DbContext 执行的日志查询 [英] Log Queries executed by Entity Framework DbContext

问题描述

我在 MVC 5 项目中使用 EF 6.0 和 LINQ.我想记录 Entity Framework DbContext 执行的所有 SQL 查询，以用于调试/性能测量目的.

I'm using EF 6.0 with LINQ in MVC 5 project. I want to log all the SQL queries executed by the Entity Framework DbContext for debugging/performance-measurement purpose.

在 Java/Hibernate 中，可以通过设置属性 hibernate.show_sql=true 来实现等效的行为.在实体框架中是否有可能有类似的行为?

In Java/Hibernate, equivalent behavior can be achieved by setting the property hibernate.show_sql=true. Is it possible to have a similar behavior in Entity Framework?

推荐答案

记录和MSDN 上的拦截数据库操作文章正是您正在寻找的内容.

Logging and Intercepting Database Operations article at MSDN is what your are looking for.

DbContext.Database.Log 属性可以设置为任何接受字符串的方法的委托.最常见的是，通过将其设置为该 TextWriter 的Write"方法，它与任何 TextWriter 一起使用.当前上下文生成的所有 SQL 都将记录到该编写器中.例如，以下代码会将 SQL 记录到控制台:

The DbContext.Database.Log property can be set to a delegate for any method that takes a string. Most commonly it is used with any TextWriter by setting it to the "Write" method of that TextWriter. All SQL generated by the current context will be logged to that writer. For example, the following code will log SQL to the console:

using (var context = new BlogContext())
{
    context.Database.Log = Console.Write;

    // Your code here...
}

这篇关于由实体框架 DbContext 执行的日志查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！