In Link-2-SQL, I can use the DataContext.Log property to see the exact queries that are getting thrown to SQL Server.
Is there an equivalent to this in Entity Framework?
Thanks Daniel
Hmmmm, now, I have a table called Posts and one called Sites.If I take the result from "db.Posts", that has a ToTraceString() method. However, I want to look at the SQL that results from making a more complex query, in this case: from site in db.Sites orderby site.Order descending, site.Title select new SitePosts() { Site = site, Posts = site.Posts.OrderByDescending(p => p.PublicationTime) }How do I get the TraceString of that?
Daniel Magliola
2009-09-09 19:54:12
Cast it as ObjectQuery.
Craig Stuntz
2009-09-09 20:34:49
I'm getting a "Cannot convert type Models.Site to System.Data.Objects.ObjectQuery" cast error.I'm doing this:Site site = (the query I mentioned before); ObjectQuery oq = (ObjectQuery) site;What am I missing here?Thanks for your help!
Daniel Magliola
2009-09-14 13:53:18
Cast the query, not the results. So if you have site = (query).First() change it to q = (query); sql = ((ObjectQuery)q).ToTraceString(); site = q.First();
Craig Stuntz
2009-09-14 14:22:27
A:
Since Entity Framework supports multiple backends (as opposed to Linq-to-SQL which is SQL Server only), you can't really get the actual SQL being sent to the backend server from EF.
In order to really see what's going on, I'd recommend firing up SQL Profiler on the SQL Server backend, and see what queries get sent its way.
See this article on Simple-Talk and possibly this video series on becoming a SQL Profiler master if you're not familiar with the SQL Profiler tool.
Marc
marc_s
2009-09-09 20:29:04