236 results found
-
provide an option to hide EntityState and EntityKey properties
Doing a simple EF query:
this.BaseEntitySet.Include("NavProp1.SubNav").Include("NavProp2.ManyMany.OtherDetail")
then there is soooooo much space=width wasted by EntityState and EntityKey columns in which I most of the time don't have any interrest in.3 votesFrom v4.37, these properties are hidden by default. To see them, click the right-arrow on the top of the table to explore in grid. Or just click the ‘Results to Data Grids’ option and re-run the query.
-
1 vote
Completed in v4.35
-
SQL Azure connection should not allow Windows Auth
The current SQL Azure connection does not disable Log on with Windows Auth (never allowed in SQL Azure).
1 voteCompleted in v4.37
-
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.
-
odata 3.0 support
OData 3.0 Ctp is released and we are using it in our site. can linqpad please support it?
9 votesOData 3 support is available in latest beta: www.linqpad.net/beta.aspx
-
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.
-
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
-
Ability to add nuget packages to linpad
Ability to add NuGet packages to linpad just like you can in visual studio 2010
15 votes -
Autoimplementation of Interfaces and Abstract Classes
Add the ability to autoimplement an interface or abstract class like in Visual Studio. LINQPad already has the namespace importing like VS, so the UI for it exists.
53 votesAvailable from v5.24
-
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 writing unit tests
Allow us to create unit tests using NUnit or similar (either needs a new option in the Language dropdown or a one-liner you could put in your Main function to kick off a test runner). Running it would run all the Unit Test methods it finds. Taking this one step further, you could even support an auto-test mode, where every time you saved, if it compiles it runs all the unit tests it finds, making it the ideal for doing code katas in
69 votesLINQPad now has special xunit support as of 6.9.12, via new options on the Query menu. ‘Add XUnit Test Support’ adds the necessary dependencies + creates a customizable xunit runner. “Run Tests” (shortcut Alt+Shift+R) invokes the RunTests() method.
-
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)
-
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
-
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
-
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.
-
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
-
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.
-
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.
-
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!
-
nuget integration
Nuget integration into linqpad for automatically adding dll in a folder and embed them in a query
122 votesNuGet integration is now available for LINQPad Premium users in latest beta: www.linqpad.net/beta.aspx
- Don't see your idea?