StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>you could try the <a href="http://hibernatingrhinos.com/products/Entity-Framework-Profiler" rel="nofollow">Entity Framework Profiler</a> (its own site is <a href="http://efprof.com/" rel="nofollow">here</a>), although this is not a free product, it does however have a 30 day free trial. And its written by <a href="http://ayende.com/blog/" rel="nofollow">one of the smartest guys around</a></p> <p>It will however flag up issues, such as Select N+1 issues and warn you about bad practices.</p> <p>From the blurb:</p> <blockquote> <p>Entity Framework Profiler is a real-time visual debugger allowing a development team to gain valuable insight and perspective into their usage of Entity Framework. The product is architected with input coming from many top industry leaders within the OR/M community. Alerts are presented in a concise code-review manner indicating patterns of misuse by your application. To streamline your efforts to correct the misuse, we provide links to the problematic code section that triggered the alert</p> </blockquote> <p>again from the blurb (in response to the comment):</p> <blockquote> <p>Using the Entity Framework Profiler is easy. First, we need to make the application that we profile aware of the profiler. Then, just start the profiler.</p> <p>Preparing an application to be profiled</p> <p>Add a reference to the HibernatingRhinos.Profiler.Appender.dll assembly, located in the downloadable zip. In the application startup (Application_Start in web applications, Program.Main in Windows / console applications, or the App constructor for WPF applications), make the following call:</p> </blockquote> <pre><code>HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.Initialize(); </code></pre> <p><strong>EDIT</strong></p> <p>seems that you can initialize the profiler for offline profiling. use this to initialize it instead (from <a href="http://efprof.com/Learn/Usage/OfflineProfiling" rel="nofollow">here</a>):</p> <pre><code>HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.InitializeOfflineProfiling(filename); </code></pre> <p>then load the resulting file into the profiler.</p> <p>This seems like it should give you what you want.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload