首页 > 数据库 > > ef 输出sql 怎么一起吧对应的方法位置一起打印
ef 输出sql 怎么一起吧对应的方法位置一起打印
比如
2019-07-24 09:05:56,888 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - Opened connection at 7/24/2019 9:05:56 AM +08:00
2019-07-24 09:05:57,123 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - SELECT
[Project1].[Account] AS [Account],
[Project1].[UserId] AS [UserId],
[Project1].[Page_Name] AS [Page_Name],
[Project1].[Preference_Type] AS [Preference_Type],
[Project1].[Column_Name] AS [Column_Name],
[Project1].[Group_ID] AS [Group_ID],
[Project1].[History] AS [History],
[Project1].[Is_Hidden] AS [Is_Hidden],
[Project1].[Page_Number] AS [Page_Number],
[Project1].[Create_Date] AS [Create_Date],
[Project1].[Create_User] AS [Create_User],
[Project1].[Update_Date] AS [Update_Date],
[Project1].[Update_User] AS [Update_User]
FROM ( SELECT
[Extent1].[Account] AS [Account],
[Extent1].[UserId] AS [UserId],
[Extent1].[Page_Name] AS [Page_Name],
[Extent1].[Preference_Type] AS [Preference_Type],
[Extent1].[Column_Name] AS [Column_Name],
[Extent1].[Group_ID] AS [Group_ID],
[Extent1].[History] AS [History],
[Extent1].[Is_Hidden] AS [Is_Hidden],
[Extent1].[Page_Number] AS [Page_Number],
[Extent1].[Create_Date] AS [Create_Date],
[Extent1].[Create_User] AS [Create_User],
[Extent1].[Update_Date] AS [Update_Date],
[Extent1].[Update_User] AS [Update_User]
FROM [dbo].[User_Grid_Preferences] AS [Extent1]
WHERE ([Extent1].[Account] = @p__linq__0) AND ([Extent1].[UserId] = @p__linq__1) AND ([Extent1].[Page_Name] = @p__linq__2)
) AS [Project1]
ORDER BY [Project1].[Preference_Type] ASC, [Project1].[Column_Name] ASC
2019-07-24 09:05:57,124 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] -
2019-07-24 09:05:57,127 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - -- p__linq__0: 'S_Acct_90001555' (Type = AnsiString, Size = 8000)
2019-07-24 09:05:57,128 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - -- p__linq__1: 'U_User_00000001' (Type = AnsiString, Size = 8000)
2019-07-24 09:05:57,129 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - -- p__linq__2: '.ProductResearch.index' (Type = AnsiString, Size = 8000)
2019-07-24 09:05:57,130 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - -- Executing at 7/24/2019 9:05:57 AM +08:00
2019-07-24 09:05:57,356 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - -- Completed in 224 ms with result: SqlDataReader
2019-07-24 09:05:57,357 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] -
2019-07-24 09:05:57,358 [13] INFO BigZata.Models.BigZata_Entities [<.ctor>b__0] - Closed connection at 7/24/2019 9:05:57 AM +08:00
怎么把linq 所在的位置一起打印
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2752/viewspace-3139297/ ,如需转载,请注明出处,否则将追究法律责任。