Define linq to sql query source

Question

In our code, we get many linq to sql queries. We started to focus more on performance and are starting to see queries that we think come from linq. They have values ​​t1, t2 ... tN, so we are sure that they are generated by linq. However, it is difficult for us to determine the location in the code that is the source of the request. Obviously, we have a general idea based on the requested tables and columns.

Is there a way to “tag” or “name” a request so that it appears in the trace to make it easier to identify the request?

Answer 1

I still have not found a way to do this.

Answer 2

Linq-to-SQL; db-side I/O, , , , , ( , / ..).

, , , . . , : I/O-wise, , , , .. , , , prod.

: http://huagati.blogspot.com/2009/06/profiling-linq-to-sql-applications.html

45 : http://www.huagati.com/L2SProfiler/