How do I output/log the sql being executed behind the scenes by the Entity Framework?

Question

How do I output/log the sql being executed behind the scenes by the Entity Framework in an asp .net mvc application? In my case I'm using a Sql Server 2005 database.

I found this question Linq to Sql logging, but I'm trying to figure out how to do this with the entity framework v1 and asp .net mvc 1.0. Any one have any ideas on how?

Answer 1

http://efprof.com/

Answer 2

I answered this here: http://stackoverflow.com/questions/2218370/round-trip-logging-in-entity-framework/2218387#2218387

Or you can use Ayendes: http://efprof.com/

Answer 3

You may take a look at this article and especially the EFTracingProvider.