Never been able to run a linq query

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
KCarterSr
Posts: 5
Joined: Thu 11 Dec 2014 20:35

Never been able to run a linq query

Post by KCarterSr » Fri 09 Oct 2015 14:03

I've never been able to run a linq query when I first purchased this, so I just never used it. Well, I've have some time to revisit this and maybe get this resolved.

It doesn't work on any query but, here is a sample snippet. Keep in mind that I don't think it's related to this particular snippet. When I click on Run Linq Query in the context menu I get the error posted below.

Thanks
K. Carter Sr.

private static BidItemFixupResult
CheckQTypes3ForBidItemNumberDuplication(
ref MultiValueDictionary<string, string> workingSetOfRecords,
ref string bidItemNumber, int division, int qType)
{
string tempBidItemNumber = bidItemNumber;
System.Collections.Generic.IEnumerable<string> query = from p in workingSetOfRecords.Keys
where p == tempBidItemNumber
select p;

if (query.Any<string>())
{
return BidItemFixupResult.Failed;
}//End if (query.Count() > 0)
workingSetOfRecords.AddRange(bidItemNumber, new[]{division.ToString(),
qType.ToString()});
return BidItemFixupResult.Succeeded;
}


Message: Method not found: 'Void ICSharpCode.NRefactory.CSharp.BlockStatement.Add(ICSharpCode.NRefactory.CSharp.Expression)'.
Type: System.MissingMethodException
Source: ICSharpCode.Decompiler
Site: .ctor
Stack Trace:
at ICSharpCode.Decompiler.Ast.Transforms.PatternStatementTransform..ctor(DecompilerContext context)
at ICSharpCode.Decompiler.Ast.Transforms.TransformationPipeline.CreatePipeline(DecompilerContext context)
at ICSharpCode.Decompiler.Ast.Transforms.TransformationPipeline.RunTransformationsUntil(AstNode node, Predicate`1 abortCondition, DecompilerContext context)
at rkmV40y70C7oUyFW8Q.qYt7dColbAn1MfCFw1.g52W24hNpN(MethodDefinition )
at rkmV40y70C7oUyFW8Q.qYt7dColbAn1MfCFw1.tnxWqTZPVl()
at QeObaete7pcSjtdWM1.uNZsZDNINJitsQL2qT.PrepareInternal(SourceCodeInfo , CancellationToken , String )
at Devart.LinqInsight.Implementation.QueryExecutor.ppkI3JuHNk()
at Devart.LinqInsight.Implementation.QueryExecutor.aiAIPEqK6p()
at Devart.LinqInsight.Implementation.QueryExecutor.<>c__DisplayClassa.<StartNewTask>b__9()

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

Re: Never been able to run a linq query

Post by MariiaI » Mon 12 Oct 2015 08:30

Most likely, this issue is related to some conflicts with another Visual Studio add-ins.
Please try attaching one Visual Studio instance (Debug | Attach to Process) to the process of another Visual Studio instance with the project, where the error occurs and specify the path, from which the ICSharpCode.NRefactory.CSharp assembly is loaded when debugging, e.g. via Debug-> Windows-> Modules (perform this step in the VS instance with which you have attached to your solution).

Looking forward to your reply.

KCarterSr
Posts: 5
Joined: Thu 11 Dec 2014 20:35

Re: Never been able to run a linq query

Post by KCarterSr » Mon 12 Oct 2015 13:51

Mariial,

There are two entries,

ICSharpCode.NRefactory.CSharp.dll C:\USERS\KCARTER\APPDATA\LOCAL\MICROSOFT\VISUALSTUDIO\12.0\EXTENSIONS\BBE0GCAD.MLZ\ICSharpCode.NRefactory.CSharp.dll Yes N/A Cannot find or open the PDB file. 862 5.05.1.0 4/22/2015 4:08 PM 640D0000-64332000 [1988] devenv.exe [1] DefaultDomain

ICSharpCode.NRefactory.CSharp.dll C:\Users\Kcarter\AppData\Local\Microsoft\VisualStudio\12.0\Extensions\ezlmmz05.n3a\ICSharpCode.NRefactory.CSharp.dll Yes N/A Binary was not built with debug information. 830 5.05.0.0 12/11/2014 4:41 PM 4B240000-4B4A2000 [1988] devenv.exe [1] DefaultDomain

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

Re: Never been able to run a linq query

Post by MariiaI » Thu 15 Oct 2015 09:34

Thank you for the response.
Please also send us the list of Installed Products in Microsoft Visual Studio via Help-> About Microsoft Visual Studio menu.

In order to check whether it is a conflict between Visual Studio add-ins, it is necessary to disable the Visual Studio add-ins which use this assembly, too.
For example, one of such products is Xamarin.

Looking forward to your reply.

KCarterSr
Posts: 5
Joined: Thu 11 Dec 2014 20:35

Re: Never been able to run a linq query

Post by KCarterSr » Mon 19 Oct 2015 14:10

Microsoft Visual Studio Ultimate 2013
Version 12.0.40629.00 Update 5
Microsoft .NET Framework
Version 4.6.00081

Installed Version: Ultimate

Architecture and Modeling Tools
Microsoft Architecture and Modeling Tools

UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.

LightSwitch for Visual Studio 2013
Microsoft LightSwitch for Visual Studio 2013

Team Explorer for Visual Studio 2013
Microsoft Team Explorer for Visual Studio 2013

Visual Basic 2013
Microsoft Visual Basic 2013

Visual C# 2013
Microsoft Visual C# 2013

Visual C++ 2013
Microsoft Visual C++ 2013

Visual F# 2013
Microsoft Visual F# 2013

Visual Studio 2013 Code Analysis Spell Checker
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
Windows Phone SDK 8.0 - ENU

.NET Memory Profiler 4.6
.NET Memory Profiler Visual Studio Integration Package

ASP.NET and Web Tools 12.5.60814.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 Web Apps
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.30612.0
For additional information, visit http://www.asp.net/

Attachables 1.0
Contextual reminders in your IDE.

Bridge.NET 1.0
Bridge.NET

CodeLineage 1.0
Information about my package

CodeRush for Visual Studio 15.1.7.0
CodeRush for Visual Studio

Codinion 1.0.0.1409
Enhanced C# syntax highligthing.
Symbol searchbar for better navigation in files.
Solution file and symbol search dialog.
Visual Studio Banner for working with branches.

Color Theme Designer 1.0
Designer for creating new color themes

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

CreateLayoutWizard 1.0
Create layout wizard.

DataFactoryProject 1.0
Microsoft Data Factory Package

Devart dbForge Fusion for SQL Server, Standard 1.8.46
Devart dbForge Fusion for SQL Server, Standard
Copyright 2004 - 2014 Devart. All rights reserved.
Web: www.devart.com/dbforge/Sql/fusion
Support: www.devart.com/dbforge/Sql/fusion/support.html

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

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

DevExpress.DeploymentTool 1.0
A useful tool for deploying DevExpress assemblies.

DevExtreme.Design 15.1.3
DevExtreme Visual Studio integration package

Implementator 1.0
Adds Go To Implementation option

Indent Guides 14
Indent Guides

Adds visual guides at each indentation level.

JavaScript Parser 1.0
Add-In for Visual Studio for improve support for javascript

JetBrains ReSharper Ultimate 2015.2 Build 103.0.20150818.200216
JetBrains ReSharper Ultimate package for Microsoft Visual Studio. For more information about ReSharper Ultimate, visit http://www.jetbrains.com/resharper. Copyright © 2015 JetBrains, Inc.

LayoutsORama 1.0
Information about my package

LINQBridge 1.0
Enable/Disable the creation of a custom debugger visualizer and the transformation of the target project in a fully serializable library

LinqConnect 4.5.844.0
Devart LinqConnect
Copyright © 2010 - 2015 Devart. All rights reserved.
Web: www.devart.com/linqconnect
Support: support@devart.com

LocalHistory 1.0
Information about my package

Microsoft Advertising SDK for Windows Phone
Microsoft Advertising SDK for Windows Phone
Build

Microsoft Azure Data Factory Node Node 1.0
Azure Data Factory extension for Visual Studio Server Explorer.

Microsoft Azure HDInsight HQL Service 2.0.2600.0
Language service for Hive query

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

Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools

Microsoft Azure Tools 2.7
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.7.30818.1601

Microsoft Azure Tools 2.4
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.4.20730.1601

Microsoft Azure Tools 2.6
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.6.30508.1601

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

Microsoft Team Foundation Server 2013 Power Tools 12.0
Power Tools that extend the Team Foundation Server integration with Visual Studio.

Microsoft Visual Studio Process Editor 1.0
Process Editor for Microsoft Visual Studio Team Foundation Server

Multiline Search and Replace 1.6
Adds multiline search and replace functionality to Visual Studio.

NuGet Package Manager 2.8.60723.765
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.40814
Microsoft Office Developer Tools for Visual Studio 2013 ENU

Open Command Line 2.0.157
Opens a command line at the root of the project. Support for all consoles such as CMD, PowerShell, Bash etc.

Oracle Developer Tools for Visual Studio 12.1.0.1.2
Oracle Developer Tools for Visual Studio Copyright (c) 2005, 2013

OzCode 1.0
Your road to Magical Debugging. http://www.oz-code.com

PHP Tools for Visual Studio 1.18.8281.2013
PHP Tools extend Visual Studio with a set of features to build PHP applications more efficiently. It makes code more readable, easier to navigate, and clean.

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

ReopenStartPage 1.0
Reopens the Visual Studio start page after closing a solution.

ResXManager 1.0.0.62
Manage localization of all ResX-Based resources in one place. Shows all resources of a solution and let's you edit the strings and their localizations in a well-arranged data grid.

Runtime Flow v1.5.1
The control flow monitor for .NET developers. For more information about Runtime Flow, see the website at https://vlasovstudio.com/runtime-flow/.
Copyright (c) 2010 - 2015 Vlasov Studio.

SQL Server Data Tools 12.0.50730.0
Microsoft SQL Server Data Tools

Stay Frosty 1.0
Making Visual Studio a little more gooey!

TabsStudio11 1.0.6
Tabs Studio 2012 Helper

TextHighlighterPackage 1.0
Information about my package

TfsGoOffline 1.0
Go Offline command

ToastNotifier 1.0
Show Toast Notification when Bulid completed.

Trailing Whitespace Visualizer 1.0
Makes it easier than ever to identify and remove trailing whitespace in any code file

Visual Studio Restart 1.0
Restart visual studio with elevated rights

VS10x CodeMAP Package 1.1
Powerful Visual Studio code editor visualizer (C#, VB, C++).

VS10x Method Block Highlighter Package 1.2
Highlight entire methods with a colored background (green, yellow, cyan, magenta)

VSColorOutput 1.4.5
Color output for build and debug windows - http://blueonionsoftware.com/vscoloroutput.aspx

VsOpenIn 1.0
Visual Studio extension to open the current document in an external editor.

Web Essentials 2013 2.6.13.0
Adds many useful features to Visual Studio for web developers.

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.

Xamarin 3.8.150.0
Visual Studio extension to enable development for Xamarin.iOS and Xamarin.Android.

Xamarin.Android 4.20.0.28
Visual Studio plugin to enable development for Xamarin.Android.

Xamarin.iOS 8.4.0.0
Visual Studio extension to enable development for Xamarin.iOS.

XtraReports package 1.0
XtraReports package

Atomineer Pro Documentation
For more information about Atomineer, visit the website:
http://www.atomineerutils.com/
Copyright (c) 1996-2013 Atomineer - Written by Jason Williams.


Tabs Studio
For more information about Tabs Studio v3.6.5, see the website at https://tabsstudio.com
Copyright (c) 2009 - 2015 Vlasov Studio.

Visual Docs
For more information about Visual Docs, see the Visual Docs website at
http://visualdocs.net
Copyright (c) 2012-2014 Visual Docs

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

Re: Never been able to run a linq query

Post by MariiaI » Tue 20 Oct 2015 05:56

KCarterSr wrote:JetBrains ReSharper Ultimate 2015.2 Build 103.0.20150818.200216
...
Xamarin 3.8.150.0
...
Xamarin.Android 4.20.0.28
...
Xamarin.iOS 8.4.0.0
...
XtraReports package 1.0
These products can lead to conflicts with LINQ Insight. Please disable these VS add-ins and tell us about the results.
We are also investigating the possible solutions to avoid such conflicts.

soulfiremage
Posts: 1
Joined: Fri 22 Apr 2016 16:22

Re: Never been able to run a linq query

Post by soulfiremage » Fri 22 Apr 2016 16:27

Is there any update to this query guys?

I'm evaluating the product and cannot make it work either. I've tried with several different linq queries in different locations in VS 2015 but it is not having any of it.

I'm using Visual Basic and .net 4.6.1, Linq to SQL and SQL server 2014.

Code: Select all

Message: Queries not found in method 'CreateInvoiceDetails'.
Type: System.InvalidOperationException
Source: Devart.LinqInsight.Roslyn
Site: PrepareInternal
Stack Trace: 
	at Devart.LinqInsight.Roslyn.RoslynQueryExecutor.PrepareInternal(SourceCodeInfo sourceCode, CancellationToken token, String privateBinPath)
	at Devart.LinqInsight.Implementation.QueryExecutor.Prepare()
	at Devart.LinqInsight.Implementation.QueryExecutor.Execute()
	at Devart.LinqInsight.Implementation.QueryExecutor.<>c__DisplayClass59_0.<StartNewTask>b__0()
My colleague is using this but so far I'm in the "no" camp on this one as the error shown is too cryptic to fault find quickly.

We do use Devexpress winforms controls - I don't have the option to to not use them.

Thank you!

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Never been able to run a linq query

Post by Shalex » Tue 26 Apr 2016 07:20

1. Your current build of LINQ Insight is 3.5.909 Beta, isn't it? You can check your current version via the Help > About > Installed products menu of Visual Studio.

2. You have generated your model with Entity Developer (*.lqml), haven't you? Tell us the names of templates enabled via Tools > Entity Developer > Model Explorer > Templates.

3. Specify the exact LINQ to SQL queries not found ("Queries not found") by LINQ Insight.

Post Reply