Can't get SQL in Linq to Entities

[msawczyn]

I'm running Visual Studio Premium 2012 Update 1. While trying LINQInsight, my LINQ queries execute fine, but won't show SQL unless results are returned. The SQL tab stays blank.

That doesn't seem right. Is there anything I can do to change that?

Thanks.

-- Michael

[maubuso]

Same problem here. I'm using linq to entities, EF 5.0.0, .NET 4.5 in VS2012, with Firebird ADO.NET Data Provider .

[MariiaI]

Sorry for the delay. This is the intended behavior. The SQL will be shown only after the LINQ query is performed. The second version of LINQ Insight will not have such restrictions on receiving SQL.

When working with Entity Framework there is a LINQ Insight peculiarity: the SQL is get for queries like this only

Code: Select all

var query = from c in context.Categories where .. join ... select c;

if the query contains ToList/First/Last, etc., there will be no SQL generated

Code: Select all

var query = (from c in context.Categories where .. join ... select c).ToList();

[maubuso]

Hi Mariial,

I almost always use the .ToList() due to a pattern of development that we use.
There is a plan for a new version that supports use with .ToList() and others?

This is more than essential to the daily use of the tool.

[MariiaI]

Since version 2.0 of LINQ Insight, there will be no such restrictions with ToList()/First()/Last(), etc. We will inform you when the new version is available for download.

[maubuso]

I´am awaiting for version 2.0! Any release date?

[MariiaI]

We plan to release the new version of LINQ Insight in about 1-2 weeks. We will post here when it is available for download.

[maubuso]

Any news about new release?

[MariiaI]

We plan to release the new version of LINQ Insight this week.

[MariiaI]

New version of LINQ Insight 2.0 is released!
It can be downloaded from http://www.devart.com/linqinsight/download.html of from Registered Users' Area (provided that you have an active subscription).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=50&t=25769