Track down queries called from Entity Framework code

Question

Is there a way in entity framework to track down or determine where the ad hoc queries were called from in code? This query is from the Activity Moniter in SQL Server, however I can't tell where it came from in our code, we have a ton of calls. Is there a way to figure this out easily?

SELECT 
    CASE WHEN ( EXISTS (SELECT 
        1 AS [C1]
        FROM [Test].[DT] AS [Extent1]
        WHERE  EXISTS (SELECT 
            1 AS [C1]
            FROM  [Test].[D] AS [Extent2]
            INNER JOIN [Test].[ME] AS [Extent3] ON [Extent2].[EId] = [Extent3].[EId]
            WHERE ([Extent1].[DId] = [Extent2].[Id]) AND ([Extent3].[MId] = @p__linq__0)
        )
    )) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C1]
    FROM  ( SELECT 1 AS X ) AS [SingleRowTable1]

stackoverflow.com/q/41414784/861716

Gert Arnold
– Gert Arnold

2021-05-07 20:52:23 +00:00
Commented May 7, 2021 at 20:52 — Gert Arnold
– Gert Arnold, Commented May 7, 2021 at 20:52

David Browne - Microsoft · Accepted Answer · 2021-05-07 17:27:22Z

1

For EF Core this is the reason the Query Tags feature was added, or you can always use logging. For EF6 you can use logging and interception.

answered May 7, 2021 at 17:27

David Browne - Microsoft

90.8k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Flynn Over a year ago

Awesome but this isn’t EF core

Collectives™ on Stack Overflow

Track down queries called from Entity Framework code

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related