Search Wiki:
Resource Page Description

Visual LINQ Query Builder is an add-in to Visual Studio 2008 Designer that helps you visually build LINQ to SQL queries. Functionally it provides the same experience as, for instance the Microsoft Access Query Builder, but in the LINQ domain. The entire UI of this add-in uses Windows Presentation Foundation. The goal of this tool is to help users become more familiar with the LINQ syntax. The tool may also demonstrate to users how to create their own Visual Studio 2008 add-in using Windows Presentation Foundation.

This project is an academic project developed during a Microsoft France internship in collaboration with Microsoft Corporation. You can find the french description of the project here: http://msdn.microsoft.com/fr-fr/vcsharp/default.aspx

Requirements

You will need to have Visual Studio 2008 installed. You can use the Visual Linq Query Builder in any kind of project that supports Linq to SQL.

Visual Linq Query Builder is only supported with C# and VB.Net projects.

User documentation

You can download the user documentation from the 'Releases' tab.

Installation

Download the VLinqSetup.msi file from the 'Releases' tab and follow the instructions.
Last edited Mar 21 2008 at 7:12 PM  by ddicpe, version 14
Comments
jankerson wrote  Apr 7 2008 at 7:05 PM  
This thing works fine in visual studio 2008, the version I have only supports C# (no problem), and must be added a new product type, This is a nice way to generate and store queries that will be reused.. I've used it, and it works fine. The only thing is I woud like the ability to add it to existing objects as a partial class.. currently it adds it to its own class, and I would like to be able to extend my objects generated by the LINQ interface by selecting the object to extend via the VLINQ tool. OTherwise great work! Can't wait to see a polished version!!!!

Mitsu wrote  Apr 18 2008 at 2:08 AM  
Jankerson, yes we thought about a way to extend a current partial class. I will talk later about a possible solution

ziros wrote  Apr 18 2008 at 7:32 PM  
Hi Mitsu,
I downloaded the new version, my environment [windows vista, vs2008 , framework 3.5]
while running the setup, it couldn't install until I uninsalled the prev version.

anyway I still dont see the vlinq icon when adding new item

I'm opening a new Project (ASP.NET web application c#)

(at wrok the same environment with XP all is ok) hope for help
TIA

ziros wrote  Apr 19 2008 at 9:31 AM  
as for my messages above, I do have the Vlinq queries.zip in
c:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033\VLinq queries.zip

FrankDzaebel wrote  Apr 19 2008 at 1:52 PM  
As last time, this version is not installable on Windows Vista German (in my case). The following error occured (translated to english) :
"Error 1001. A part of the path c:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033\VLinq queries.zip could not be found."
For info, I only have a 1031 folder in CSharp. But even, i would create one, the installation would fail.
- the previous version of "VLinq Query builder" was deinstalled before.

Anyway, thanks for the try to correct the localization bugs.

Mitsu wrote  Apr 19 2008 at 9:16 PM  
A new setup version is available from now (4/17/2008) that is fixing previous version bugs.

Just to remind:
- if you currently have vlinq working on your machine, keep it ! the new version is just fixing the setup.
- make sure you have VS 2008 installed before installing VLinq.
- you can not use VLinq with VS Express editions.
- you can not use VLinq with ASP.Net web site but you can with ASP.Net Web Application project
- it's NOT localized for the moment

Thanks for all of you for you feedbacks. You can keep on writing your comments here if you meet any trouble

RolandZerche wrote  Apr 20 2008 at 8:07 PM  
Hi,
I have the same problem as FrankDzaebel, I couldn't install it on german VS. I tried to fix the msi file with Orca. I created a mst file with changes in the msi sections Directory, File and Property. I replaced all 1033 with 1031, but I couldn't fix it. However, there must be another location in the setup where the 1033 folders are linked.
Roland

Klaus wrote  Apr 22 2008 at 7:47 PM  
Hi together

I am from Germany and tried to install Vlinq.
Everything seems to work fine, but the installation was disrupted near the end with Error
Error 1001. Ein Teil des Pfades C:\Programme\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033\VLinq queries.zip konnte nicht gefunden werden.
For english-people: a part of the Path ...... could not be found.
that's clear because path 1033 is not on a german system. Their you find 1031.
Is anybody outthere who can tell me how to install ?
Klaus

Edgar wrote  Apr 23 2008 at 6:06 PM  
I am using Visual Studio 2005 and i need use linq. who i get it. Or some people say me other libraries to implement very good the query builder !

bswrchrd wrote  Apr 26 2008 at 12:43 AM  
Can someone update the digital signature for the MSI as it is preventing installation? Better yet why did Microsoft revoke the certificate in the first place???

raffaeler wrote  May 9 2008 at 9:05 PM  
Using VS via terminal services (Win2008) don't let you press "." character in where clause (cannot write the dot in c.City)

raffaeler wrote  May 9 2008 at 9:07 PM  
The Vlinq Query item in "add new item" appears even if the project is Framework 2.0. Querys should appear only to the suitable fx versions.

cconner100 wrote  May 10 2008 at 8:49 AM  
Thanks for the tool. We are trying to use it with tables that contain uniqueidentifiers (System.Guid) and it fail on the parsing of the where comparison. Looking at the code it seems that you dont support this data type, why?

thanks

pcavacas wrote  May 12 2008 at 4:21 PM  
One simple improvement that I think you should add is a way to change the Namespace of the generated code. You could simply add a property to the query called namespace and if anything is in there use that as the namespace and if not use the default generated namespace.

zarbogi wrote  May 14 2008 at 11:20 AM  
Hi, I have a problem when I test a query, I obtain this error "connection failed" if I select the ConnectionString that already are used in VS, and if I specify the ConnectionString I always obtain a message for recompile the project. Could someone help me?

Rashun wrote  May 16 2008 at 4:53 AM  
Great Application. Are there any thoughts to support Parallelism through PLinq, also the ability to return IParallelEnumerable from the generated methods?

Thanks

qingxingmeng wrote  Jun 4 2008 at 10:10 AM  
as for my messages abelow, I do have the Vlinq queries.zip in
d:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033\VLinq queries.zip

qingxingmeng wrote  Jun 4 2008 at 10:15 AM  
This error is from chinese,Visual Studio 2008 edition is simple chinese.

fmorriso wrote  Jul 1 2008 at 3:22 PM  
Hey everyone who is having trouble with VLINQ, why not use the free LINQPad tool available at www.linqpad.net ? It doesn't require Visual Studio and comes with tons of good examples that help you learn LINQ.

daive wrote  Jul 18 2008 at 8:37 PM  
It is a machine translation from Japanese to English.
VLINQ is installed according to folder 1033 of English version VS2008.
The installation ends if folder 1033 is put in the place from which the error message
comes out.
However, it is not registered to the template.
Is there what done besides the copy of folder 1033?

FredericDruilhet wrote  Oct 23 2008 at 12:28 PM  
There is one way to solve the installation proble (Had the same with my FR install)
- Launch the installer and wait for the error message
- go to <VS2008InstallRoot>\Common7\IDE\ItemTemplates\VisualBasic\1033
- copy the file "VLinq queries.zip"
- go to <VS2008InstallRoot>\Common7\IDE\ItemTemplates\VisualBasic\Web
- create a folder "1033" and paste the file in
- relauch installer
worked fine here

EnderLi wrote  May 10 2009 at 1:18 PM  
I got this message, too.

"Error 1001. A part of the path c:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033\VLinq queries.zip could not be found."

SSSikora wrote  May 29 2009 at 7:25 PM  
Is there any chance of getting a copy of VLinq that works in VS 2010. I know it's early but I'd like to start preparing ports of my existing application and I have made fairly extensive use of this great little tool.

-Scott

gbozarth wrote  Jun 10 2009 at 2:40 PM  
When I add a VLinq queries to my project I get the following Error

Error 1 Custom tool error: Unable to initialize the Query Formatter C:\Program Files (x86)\Microsoft Visual Studio 9.0\VB\VBProjects\ConsoleApplication2\ConsoleApplication2\Queries1.vlinq 1 1 ConsoleApplication2

I'm running Visual Studio 2008 Standard Edition on Vista Home Premium
Version 6.0.6002 Service Pack 2 Build 6002
Any ideas on how to fix this?

-Gary

SoumitraBajpai wrote  Aug 5 2009 at 5:21 PM  
Hi,
I am getting the error Error "Custom tool error: Unable to initialize the Query Formatter", the same as Gary. If I double click on it says "No such interface supported"

-Soumitra

vbost wrote  Oct 16 2009 at 2:57 PM  
Bonjour,
Still no way to install the tool Visual Linq? The little French knows the same problems
c:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1033\VLinq queries.zip could not be found."
Localization problem? Eager to test the tool Best regards
PS : Remerciements particuliers pour Mitsu dont les supports nous sont très utiles en formation

taboufaaa wrote  Oct 28 2009 at 11:25 PM  
bonjour, Hello;

is not working i dont know but is not working i wish that's in future has a new version can be integreted easly in VS for any versions.

PS: thanks for all coordinators ; merci pour toutes les personnes qui ont réaliser ce template.

btravers wrote  Jun 15 2010 at 11:11 PM  
i am using vs 2010 on windows 7 ultimate 64bit and i cannpt get the installer to run. i get "error 1001. object reference not set to an instance of an object".

is there something else i should try? by the way i am installing the latest build.

thanks
bruce

matthew wrote  Jun 30 2010 at 3:58 AM  
why not it create the 1033 folders at where it needed when the user's edition not have the language folders.
we can create some '1033' folders at item templates in csharp and vb folders. and it's installation will be ok!

shootermv wrote  Aug 17 2010 at 11:22 AM  
hi Mitsu (and all who can help with this strage problem),
I followed instructions to add Vlinq to my project, everything was good.
The problem is that I can't get querey results:
a. "Preview" button return "No data, if you have parameters... "
b. "Launch Data" button alert 1. "The project must be compiled beforerunning a querey preview"
2. After i Build solution the message is "Connection Failed".

What I miss?
Thank all.

Updating...
Page view tracker