linq-to-sqlvisual-studio-2008-sp1

How and where in VS2008 I can see my Linq commands being translate into Transact-SQL statements?

Linq commands are translated into transact-sql statements. I've VS2008 professional. How and where can I see how this majic happens? (by debugging?)

EDIT

Let's say I have this

var allProducts = db.Products;

I guess this will be translate by

SELECT * FROM Products

Where can I look at to see that? For instance, when I debug my code, I can see on the bottom are changing value each time I press f10. Is there something like that in vs2008 for linq command?

Solution

  • You can use the Log property on the DataContext object.