I'm trying to debug Entity Framework, and I can see the DB calls, but parameter values are not shown. I tried a bunch of options, but was not able to see any of the parameters. Is it possible? If not, it would be a total let down.
Asked
Active
Viewed 1,992 times
2 Answers
8
As I know IntelliTrace doesn't show parameters for queries. It shows only command text. You need some external profiler to see queries with parameters. You can use SQL Profiler directly or try tools like:
- EF Tracing Wrapper
- Huagati Query Profiler
- EFProf
- ORM Profiler
- In case of ASP.NET MVC you can also use MVC mini profiler
More about profiling options can be also found in this article.
Ladislav Mrnka
- 360,892
- 59
- 660
- 670
-
And not forgetting you can profile at the DB level too. ie) SqlProfiler for MSSQL. – Dave Hogan Oct 05 '11 at 14:55
-
Perfect, thanks. MVC mini profiler might be the winner for me – Greg R Oct 07 '11 at 03:19
-1
If you have your IntelliTrace settings configured to collect call information - Tools -> Options -> IntelliTrace -> Events and Call Information then IntelliTrace will collect the values of parameters passed into methods in your code.
If the values that you are interested in are passed as method parameters at some point you should be able to step back through your code to inspect those values. Keep the locals window open and you can see the historical values that IntelliTrace collects as you navigate backward.
Larry Guger
- 64
- 3
-
2The question is about parameters in SQL queries, not method parameters. SQL parameter values are not collected by IntelliTrace even if you turn on Call Information – sinelaw Aug 21 '13 at 15:36