Linq to Entity, query sql

[Davide Lo giudice]

I'm using C#, Linq to Entity and Sql Server 2005 Express.

I need to see the queries created by linq. What do I have to use?

Thaks.
sorry, but I'm a new VS developer. I have developed with delphi all my live.
Davide

 

[Marc Gravell]

I need to see the queries created by linq. What do I have to use?

To repost something from a few days ago (look for ****), see below.
There is also a drop-in visualizer dll you can add to VS pro to see
the command from a query by hovering on the query in a breakpoint, but
last time I checked this was unsupported.

Marc

using (pubsDataContext dc = new pubsDataContext())
{
var query = dc.authors.StartsWith("au_lname", "b")
.OrderBy(x => x.au_lname).ThenBy(x => x.au_fname)
.Select(x => new { Forename = x.au_fname, Surname
= x.au_lname });
// **** THIS BIT ****
Console.WriteLine(dc.GetCommand(query).CommandText);
// SQL
foreach (var auth in query) // Results
{
Console.WriteLine("{1}, {0}", auth.Forename,
auth.Surname);
}
}

 

[Marc Gravell]

Ahh, sorry, that was LINQ-to-SQL; but I think there is a similar plug
in LINQ-to-entity.

Marc

 

[Davide Lo giudice]

Thank you very much,

but I still havent found anything.

 

[Mark Dykun]

Davide,

On the context object there is a Log property. Set the Log property to
Console.Out to see the built up query in the console window.

For more information you can review Charlie Calverts blog that shows how
this works.

http://blogs.msdn.com/charlie/archive/2007/12/09/deferred-execution.aspx

Mark

 

[Davide Lo giudice]

sorry,
but not in Linq to Entity.