Page 1 of 1
Can't get SQL in Linq to Entities
Posted: Thu 27 Dec 2012 21:13
by 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
Re: Can't get SQL in Linq to Entities
Posted: Wed 02 Jan 2013 23:57
by 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 .
Re: Can't get SQL in Linq to Entities
Posted: Tue 08 Jan 2013 09:47
by 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();
Re: Can't get SQL in Linq to Entities
Posted: Tue 08 Jan 2013 19:08
by 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.
Re: Can't get SQL in Linq to Entities
Posted: Wed 09 Jan 2013 09:03
by 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.
Re: Can't get SQL in Linq to Entities
Posted: Wed 09 Jan 2013 15:24
by maubuso
I´am awaiting for version 2.0! Any release date?
Re: Can't get SQL in Linq to Entities
Posted: Thu 10 Jan 2013 07:42
by 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.
Re: Can't get SQL in Linq to Entities
Posted: Fri 25 Jan 2013 11:32
by maubuso
Any news about new release?
Re: Can't get SQL in Linq to Entities
Posted: Mon 28 Jan 2013 09:18
by MariiaI
We plan to release the new version of LINQ Insight this week.
Re: Can't get SQL in Linq to Entities
Posted: Thu 31 Jan 2013 08:17
by 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