Alex
Alex

Reputation: 628

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

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

Upvotes: 0

Views: 162

Answers (2)

Craig Stuntz
Craig Stuntz

Reputation: 126547

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

Upvotes: 0

4imble
4imble

Reputation: 14416

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. Is there a SQL Server Profiler for SQL Server 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.

Upvotes: 1

Related Questions