Joe Albahari

Ever gone to SQL Management Studio and started accidentally typing a query in LINQ

Well now you can interactively query your databases in LINQ! LINQPad is small free utility for writing ad-hoc LINQ queries - requiring no typed DataContext. You can use it for learning LINQ as well as improving productivity when writing ad-hoc queries. Never struggle with a correlated subquery again!

LINQPad also runs LINQ to objects/LINQ to XML queries. Here's where to download it:

http://www.albahari.com/linqpad.html

This is LINQPad's first Beta - so I'm very interested in receiving feedback.

Regards

Joe





Re: LINQ Project General LINQPad is here!

Ramon Dures

I would like to leave my suggestions:


1) Intellisense
2) Click in the table and to have option to generate code of select using LINQ or to drag the same one for area of code and to generate code LINQ.
3) Possible integration with VS2008

thanks,

Ramon






Re: LINQ Project General LINQPad is here!

larrym

Thanks for the download. Is it supposed to work with Vista-32 It gets an error when I try to run it. I've disabled UAC.

Description:
Stopped working

Problem signature:
Problem Event Name: APPCRASH
Application Name: LINQPad.exe
Application Version: 1.0.0.0
Application Timestamp: 46bda7dd
Fault Module Name: KERNEL32.dll
Fault Module Version: 6.0.6000.16386
Fault Module Timestamp: 4549bd80
Exception Code: e0434f4d
Exception Offset: 0001b09e
OS Version: 6.0.6000.2.0.0.256.6
Locale ID: 1033




Re: LINQ Project General LINQPad is here!

Joe Albahari

Hi Ramon

(2) and (3) are on in the pipeline; (1) might be difficult Smile Intellisense would mean writing a full C# 3.0 language lexer and parser, right What makes this hard is that it must handle incomplete code as well. Nonetheless, integration with Studio might be an alternative.

Cheers, Joe





Re: LINQ Project General LINQPad is here!

Joe Albahari

Larrym: LINQPad works with Vista-32 and does not require admininistrative elevation. I presume you have FW 3.5 beta 2 installed, and have saved the executable to disk somewhere before running it





Re: LINQ Project General LINQPad is here!

larrym

Joe,

Sorry for the mixup, I didn't know where I was.

The development machine I should have run it on is an XP system with VS2008 and FW3.5. I tried running the LINQPad on that XP system from a network share and got a TypeInitializationException. Once I copied it to a local drive, it ran fine.

That was 2 strikes against me. Thanks for you patience, Larry




Re: LINQ Project General LINQPad is here!

Joe Albahari

Ramon: (2) has now been done. (Right-click on a table in the TreeView). Thanks for your suggestion.

Joe

P.S. Consider lack of Intellisense a feature - it's amazing how it reactivates your brain!!!





Re: LINQ Project General LINQPad is here!

Ramon Dures


Already I am testing the new functionality

(1) I do not know the deep o Visual Studio 2008 Shell, can be an alternative. (http://msdn2.microsoft.com/en-us/vstudio/bb510103.aspx

(2) CRUD - We can extend for Insert, Update, DeleteSmile

(4) Right-click on a table in the TreeView
[Products
- Category [Click] -> Generate code select Product + Category
- Supplier
- OrderDetails [EntitySet]

Thanks,

Ramon Duraes

http://blogs.2pc.com.br/ramonduraes




Re: LINQ Project General LINQPad is here!

Ramon Dures

(5) In case that it is possible in the window of results (grid) to select a register for Edit, Update, Delete
Simple edition, (http://www.scottgu.com/blogposts/linq5/step03.jpg)

tks,

Ramon Duraes
http://blogs.2pc.com.br/ramonduraes





Re: LINQ Project General LINQPad is here!

Joe Albahari

Thanks Ramon - these are all good suggestions. I didn't know about VS Shell - I've sent MS an e-mail to find out more.

Cheers, Joe