让Ef.DbContext输出SQL

1、在YourDbContext构造函数中配置Database.Log。

public partial class XxxEntities: DbContext
    {
        public XxxEntities()
            : base("name=XxxEntities")
        {
            System.Diagnostics.Debug.WriteLine("--实例化DbContext--");
            Database.Log = x => { System.Diagnostics.Debug.WriteLine(x); };
        }
    }

 

2、在Debug(F5)环境下测试，才能在output窗口中输出SQL信息。

--实例化DbContext--
已于 2015/6/2 12:51:38 +08:00
 打开了连接
SELECT 
    [Extent1].[CoSetID] AS [CoSetID], 
    [Extent1].[BeginTime] AS [BeginTime], 
    [Extent1].[EndTime] AS [EndTime], 
    [Extent1].[CreateTime] AS [CreateTime], 
    [Extent1].[CreatorID] AS [CreatorID], 
    [Extent1].[Creator] AS [Creator], 
    [Extent1].[LastUpdateTime] AS [LastUpdateTime], 
    [Extent1].[LastEditorID] AS [LastEditorID], 
    [Extent1].[LastEditor] AS [LastEditor], 
    [Extent1].[IsEnabled] AS [IsEnabled], 
    [Extent1].[IsDeleted] AS [IsDeleted], 
    [Extent1].[Timestamp] AS [Timestamp]
    FROM [dbo].[CourseSet] AS [Extent1]
    WHERE 0 = [Extent1].[IsDeleted]
    ORDER BY [Extent1].[BeginTime] ASC


-- 正在 2015/6/2 12:51:39 +08:00
 执行
-- 已在 25 毫秒内完成，结果为: SqlDataReader



已于 2015/6/2 12:51:39 +08:00
 关闭了连接

默认情况下，VS会输出许多其它类型的消息，但是可以在output窗口中右击选择需要输出的消息类型。