tags:

views:

20

answers:

2
Q: 

How to see LINQ generated SQL in Visual Web Developer 2008 Express Edition?

Hi all,

can someone explain me how to check LINQ generated SQL queries in VWD 2008?

I just have not enough time for figuring it out by myself, so any help is appreciated

Thanks

EDIT: I am using SQL Server 2008, Entity Framework and ASP.NET MVC

+1  A: 

You could buy Linq to Sql profiler.

It's pretty steep (imo) but looks like a great tool if you can afford it or justify the costs.

There are free ways to do what you ask but I cant remember off the top of my head.

I am assuming you are also using SQL Server Express. Check this thread out. http://stackoverflow.com/questions/760321/is-there-a-sql-server-profiler-for-sql-express

Addendum, just noticed you are actually using Linq to Entities. The same guy sells this for that framework.

http://efprof.com/

Sorry for the rather vague options but I hope they help. You orginally said you was pressed for time (before editing) so i helped you do the groundwork for some reasearch.

Kohan  2010-07-07 14:59:19
Thank you for the options, but i really can't go with buying something, as i am on summer practice, and i'll be gone from this place in less than two months :)
Sasha  2010-07-07 15:15:45
A: 

Use SQL Server Profiler (free with SQL Server, which you say you already have) or LINQPad.

Craig Stuntz  2010-07-07 17:45:01

related questions

Linq to Entities and concatenated properties
Entity framework: One big model or a set of smaller models?
LinqToEntities not retrieving child objects of an entity
Entity Framework & LINQ To SQL - Conflict of interest?
How do I put business logic in my ADO.NET Entity Framework classes?
How do I extend ADO.NET Entity Framework objects with partial classes?
How do I use LINQ to Entities in Visual Basic?
How to check for the presence of an OrderBy in a ObjectQuery<T> expression tree
Linq to Entities with WCF
Filter EntityDataSource on Association value
Persistence framework?
Entity framework and queries' SQL logging
Best Practices for Entity Framework and ASP.NET
Using Linq with WCF
Has anyone used lucene.net with Linq-to-Entities?
Is there a DataContext in LINQ-to-Entities (NOT Linq-to-SQL)?
SQL tracing LINQ to Entities
How to do a "where in values" in LINQ-to-Entities
Linq to Entity with multiple left outer joins
How to Implement Database Independence with Entity Framework
Why all the Linq To Entities Hate?
How to implement Repository pattern withe LinqToEntities?
Linq to Entities vs ESQL
Learning about LINQ
Expression.Invoke in Entity Framework?