236 results found
-
clickable foreign keys in result pane
for results from database, make clickable the value of the column, which is foreign key (for example Table.Take(x) -> results to [TableID, ForeignID] - clickable values from ForeignID column -> on click runs ForeignTable.Where(i => i.ID == Table.ForeignID).Take(x)
1 voteCompleted in v4.37. Click the ‘Results to Grids’ button to enable this feature.
-
Enable LinqPad to release its lock on a referenced DLL
Any referenced DLLs cannot be overwritten by another application (Visual Studio in this case) when LinqPad has referenced them and the query has been executed at least once. The query window has to be closed and reopened for the file to be overwritten.
6 votesCompleted in 4.37. By default LINQPad now shadows DLLs referenced into memory.
-
I would like a place to place dll's into a custom folder for use, while using LinqPad.
The idea here would be that I can create custom dll's other than just extensions to make reference to in my LinqPad.
For example I would like to create my own Asserts dll in C# to kinda act like a quick unit test on an Idea I have.
3 votesDrop any DLL into the plug-in folder and it will be referenced automatically by LINQPad. Another solution (from 4.37) is to click on the ‘My Extensions’ query and hit F4. Any references that you add here will apply to all queries.
-
Provide a format statement option context menu item
This function would clean up the statement by providing tabs where necessary (align and indent).
115 votesThis was completed in LINQPad 5
-
Limit of Graph
When executing a query with nested queries in it the result are limited to a depth of 2 levels. and the remaining levels are not displayed properly (instead a "Limit of Graph" error is displayed).
Would it be possible to increase this depth? Or are there other ways to achieve this with a minimum of code?
Here's an example of what I'm doing:
from level1 in Level1Table
…
select new {
Level1Obj = level1,
Children = (from level2 in level1.Level2Children
select new {
Level2Obj = level2,
Children = (from level3 in level2.Level3Children
select new {
Level3Obj = level3,
Children = level3.Level4Children})12 votesThis is now complete. In addition to the workarounds mentioned, recent versions of LINQPad display hyperlinks which allow expansion to any desired depth.
-
Give control over Option Strict for VB.NET queries
Apparently VB.NET queries are compiled with Option Strict Off. This is very annoying, because it often causes runtime errors that could have been detected at compile time if Option Strict had been On.
3 votesCompleted in 4.35
-
persistent query results and refine locally
The idea is enable the following:
- let me run a query, it brings down the results
- I call .ToList() on the result in order to run client side queries on the results without hitting the db.
- I add some more statements that query the results even further, but hitting F5 will not go back query the db, but rather the results are presisted between F5 executions.in other words I get a dataset once locallly and can then slice and dice and query it to my liking until I get the query/data pivoting I need.
This would…
8 votesThis is now supported via the Cache method. Go to Help | What’s New and search for ‘caching’ for an example
-
put 'executing' status in tab (spinner, etc)
If I have a long-running query in one tab and switch to a different tab to do other work, I would like the non-active tab to visually show that it's still busy somehow. This way I can tell when it finishes and switch back to check the results.
The workaround is to open a new instance of LINQPad, but sometimes I have 2 or 3 long-running queries and would rather just stick with tabs if I could get them to communicate their 'still running' status even when inactive. :)
0 votes -
Support IntelliSense for F# too!
Please add F# support in this area! In a language where the types are almost always inferred (rather than almost always declared), something to show currently inferred typing would be a huge plus! Not to mention the usual autocomplete on library elements etc.
1,028 votesA LINQPad beta with F# autocompletion and tooltips is now out! Please report any bugs that you find. Download here: www.linqpad.net/download.aspx#beta
-
Add widescreen support to the UI
Add an option to display the query and results in separate columns.
1 voteFrom v4.35, this layout option is supported (Query menu)
-
Add Table.Where(...) to context menu
When you right-click a table on the connection tree on the left, it gives the following options: [Table].Take(50), [Table].Take(...), [Table].Count(), and from x in Table where ... select x.
It would be nice to add a [Table].Where(...) option there to short-hand a standard Where() command start in the query window.4 votesCompleted in 4.37
-
Increase Maximum rows returned beyond 10000
Please make the number of rows returned user configurable beyond the current limit of 10,000. As a sql management console replacement tool, this is a firm requirement for me.
8 votesDone. Click the new ‘Results in Grid’ icon. The result count is then limited only by memory.
-
Maximum Result Greater Than 10000
As it is with SSMS, I'd like the option to return ALL the results of a query. For example, I'm currently trying to execute a query that should return over 46k rows and I'm only seeing 10k because of the limit imposed by LINQPad.
0 votesDone. Click the ‘Results in Grid’ icon
-
#if for LINQPad
It would be great if LINQPad could use #if (http://msdn.microsoft.com/en-us/library/4y6tbswk.aspx) and #define for LINQPad queries .
For example, to avoid nested classes I add two closing braces after the Main() function and omit closing the last class in my LINQPad file (http://solutionevangelist.com/discussion/12/linqpad-and-ef-code-first-ado.net-entity-framework-ctp5)
In fact, we wouldn't have to use #define either if there was just a default #define LINQPAD for all queries. Then we could bypass Util.ReadLine() methods, etc.
6 votesYou can now define symbols and use conditional compilation directives in LINQPad.
-
Database Dropdown Width
Sometimes I have my window sized a little smaller in width and when I hit the drop down I am unable to read the database name. It would be nice if the dropdown content window would size to the data being displayed rather than retaining the width of the dropdown control. This would make it easier to read and select the item from the list expecially when there are several databases with the same name but different indexes at the end of them which currently cannot be viewed unless the whole application window is resized.
3 votesCompleted in 4.35. Note that another way to set the connection is to drag a database from the Schema Explorer to the query editor.
-
Interface implementation
How difficult would it be to implement an interface in a class using autocompletion to create the method stubs? Similar to CTRL+. in VS, which lets you choose implicit or explicit implementation.
The issue is that if you create class using IDisposable interface, you have to manually create the Dispose method, for instance, and while this is easy, some others have more complex signatures, etc...
Thank you.
38 votesThis is available from Version 5.24
-
List of tips to save on LINQPad memory usage
I've found LinqPad so useful that I leave it open for days at a time, and it fairly quickly reaches significant memory usage, right now 850mb private. Closing a few tabs it goes down to 600mb private.
On startup for me it uses 130mb private.I'm wonder what is preventing the memory from being freed, and what could I do to allow it to free some?
Perhaps you could add a small 'X' on the result set to be able to close that when I want to save the query in an open tab for a longer time? Or a…3 votesDone: LINQPad should now consume significantly less memory (particularly when you have lots of open queries).
Let me know if there are still any problems!
-
add reflection support, so that I can explore assemblies and play with reflected code inside linqpad
Since a certain software vendor announced that a certain reflection tool is no longer going to be free, I'd love it if I were able to browse assemblies, just underneath database tree and expand an assembly and a method, see reflected code, and then be able to single click copy the code into linqpad code editor window so that I can explore the code "hands on", something that current reflection tools dont allow you to do.
10 votesI’m marking this as complete, because LINQPad now includes an integrated ILSpy.
-
Allow OData connections to have names as credentials can change and affect query resutls
Allow OData connections to have names so more than once conenction to the same URL can be created. When credentials change this can affect query resutls.
3 votesRight-click on the connection and click ‘rename’.
-
2 votes
From v4.37, there’s now a ‘Results to Grids’ mode with always-visible headers.
- Don't see your idea?