Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

IntelliTrace and ADO.NET parameter values

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.

like image 899
Greg R Avatar asked Oct 05 '11 03:10

Greg R


People also ask

What is IntelliTrace?

IntelliTrace always records events that happen in the Visual Studio debugger. For example, starting your application is a debugger event. Other debugger events are stopping events, which cause your application to break execution.

How to enable IntelliTrace?

Enable IntelliTrace events and snapshots modeOpen Tools > Options > IntelliTrace settings, and select the option IntelliTrace events and snapshots.

How to step back while debugging in Visual Studio?

Visual Studio takes snapshots of each breakpoint while debugging and allows us to take a step back with the previous state of data. You can check out the Snapshot events captured during debugging inside Diagnostic tools and navigate to the specific breakpoint by selecting the event as well.


1 Answers

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.

like image 157
Ladislav Mrnka Avatar answered Oct 22 '22 01:10

Ladislav Mrnka