no SQL showing

Discussion of issues, suggestions and bugs of LINQ Insight, Visual Studio add-in for design-time executing LINQ statements, that simplifies debugging LINQ
Post Reply
LucidCoder
Posts: 11
Joined: Thu 05 Feb 2015 19:24

no SQL showing

Post by LucidCoder » Thu 05 Feb 2015 19:27

Hello;

Not sure if I am doing something wrong, I did search the forum first.

The following Linq produces results but nothing in the SQL. I am using the trial with 30 days left:

Code: Select all


from stops in context.DistributionStopInformations
join items in context.DistributionLineItems on stops.UniqueIdNo equals items.UniqueIdNo
where stops.CustomerNo == (decimal?)97808m && DbFunctions.TruncateTime(stops.DatetimeCreated) == (DateTime?)DateToCheck1.Date
select new {
	createdDate = stops.DatetimeCreated,
	stopName = stops.StopName,
	uniqueID = stops.UniqueIdNo,
	item = items.ItemNumber
}
Thank you!

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: no SQL showing

Post by MariiaI » Fri 06 Feb 2015 07:29

The following Linq produces results but nothing in the SQL.
Please specify the following details:
- the version and edition of Visual Studio;
- the version of EF, DbContext or ObjectContext;
- the type of the project;
- if possible, send us a small test project with which the issue could be reproduced, etc.

LucidCoder
Posts: 11
Joined: Thu 05 Feb 2015 19:24

Re: no SQL showing

Post by LucidCoder » Fri 06 Feb 2015 12:32

It does it on every project.
Visual studio 2013
Version 4.5.51641
well...here:
Microsoft Visual Studio Professional 2013
Version 12.0.31101.00 Update 4
Microsoft .NET Framework
Version 4.5.51641

Installed Version: Professional

LightSwitch for Visual Studio 2013 06177-004-0444002-02794
Microsoft LightSwitch for Visual Studio 2013

Team Explorer for Visual Studio 2013 06177-004-0444002-02794
Microsoft Team Explorer for Visual Studio 2013

Visual Basic 2013 06177-004-0444002-02794
Microsoft Visual Basic 2013

Visual C# 2013 06177-004-0444002-02794
Microsoft Visual C# 2013

Visual C++ 2013 06177-004-0444002-02794
Microsoft Visual C++ 2013

Visual F# 2013 06177-004-0444002-02794
Microsoft Visual F# 2013

Visual Studio 2013 Code Analysis Spell Checker 06177-004-0444002-02794
Microsoft® Visual Studio® 2013 Code Analysis Spell Checker

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.

Windows Phone SDK 8.0 - ENU 06177-004-0444002-02794
Windows Phone SDK 8.0 - ENU

ASP.NET and Web Tools 12.4.51016.0
Microsoft Web Developer Tools contains the following components:
Support for creating and opening ASP.NET web projects
Browser Link: A communication channel between Visual Studio and browsers
Editor extensions for HTML, CSS, and JavaScript
Page Inspector: Inspection tool for ASP.NET web projects
Scaffolding: A framework for building and running code generators
Server Explorer extensions for Microsoft Azure Websites
Web publishing: Extensions for publishing ASP.NET web projects to hosting providers, on-premises servers, or Microsoft Azure

ASP.NET Web Frameworks and Tools 2012.2 4.1.21001.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.21010.0
For additional information, visit http://www.asp.net/

AutoHistory 1.0
Information about my package

Common Azure Tools 1.3
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Devart dotConnect for PostgreSQL 7.3.313.0
Devart dotConnect for PostgreSQL
Copyright 2002 - 2014 Devart. All rights reserved.
Web: www.devart.com/dotconnect/postgresql
Support: support@devart.com

Devart Entity Developer 5.7.510.0
Devart Entity Developer
Copyright © 2008-2014 Devart. All rights reserved.
Web: www.devart.com/entitydeveloper
Support: support@devart.com

Devart LINQ Insight Express 3.2.610.0
Devart LINQ Insight Express
Copyright © Devart 2012-2014. All rights reserved.
Web: www.devart.com/linqinsight
Support: support@devart.com

Microsoft Azure HDInsight HQL Service 1.0.0000.0
Language service for Hive query

Microsoft Azure HDInsight Tools for Visual Studio 1.0.0000.0
An integrated development environment for HDInsight application development.

Microsoft Azure Mobile Services Tools 1.3
Microsoft Azure Mobile Services Tools

Microsoft Azure Tools 2.5
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.5.21104.1601

NuGet Package Manager 2.8.50926.663
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Office Developer Tools for Visual Studio 2013 ENU 12.0.30626
Microsoft Office Developer Tools for Visual Studio 2013 ENU

PowerShell Tools 1.3
Provides file classification services using PowerShell

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Data Tools 12.0.41012.0
Microsoft SQL Server Data Tools

Telerik Data Access 2014.3.1027.1
Telerik Data Access Copyright © 1996–2014 Telerik AD
Telerik Data Access is the ultimate data access layer solution for Microsoft .NET database applications.
www.telerik.com/orm

Telerik Reporting
For more information please visit http://www.telerik.com/reporting. Copyright © 2005–2015 Telerik AD

Telerik WinForms VSExtensions 2014.6.1128.0
Telerik UI for WinForms VSExtensions

Windows Phone 8.1 SDK Integration 1.0
This package integrates the tools for the Windows Phone 8.1 SDK into the menus and controls of Visual Studio.

Workflow Manager Tools 1.0 1.0
This package contains the necessary Visual Studio integration components for Workflow Manager.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: no SQL showing

Post by MariiaI » Mon 09 Feb 2015 07:45

Thank you for additional information. However, it is not enough for reproducing the issue.
Please provide us with a small test project with which the issue could be reproduced, so that we are able to investigate it in more details.
This will significantly speed up the process of finding the solution for you.

maubuso
Posts: 30
Joined: Wed 02 Jan 2013 23:53

Re: no SQL showing

Post by maubuso » Tue 10 Mar 2015 11:08

Hi . I'm having the same issue.
Any linq query do not produce the SQL Statement .

I'm using 3.2.610 Linq Insight Version with VS 2013.4 / Entity Framework 6.1.2 / Windows 8.1 Update 1 X64 , connecting on a SQL Server 2008 R2.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: no SQL showing

Post by MariiaI » Tue 10 Mar 2015 13:26

Please specify the following details:
- whether you are using DbContext or ObjectContext;
- the type of the project;
- the LINQ query you are executing (if it ends with .ToList/.Single/.First, in such cases the SQL is not shown), etc.;

JIC: similar issue has been discussed here.

LucidCoder
Posts: 11
Joined: Thu 05 Feb 2015 19:24

Re: no SQL showing

Post by LucidCoder » Tue 24 Mar 2015 19:57

I purchased the product, did a uninstall and a reinstall and everything is working correctly as far as this issue is concerned.

Thank you

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: no SQL showing

Post by MariiaI » Wed 25 Mar 2015 06:46

LucidCoder wrote:I purchased the product, did a uninstall and a reinstall and everything is working correctly as far as this issue is concerned.

Thank you
Glad to see that the issue was resolved.
If you have any further questions, feel free to contact us.

Post Reply