260 results found
-
include another .cs file(s) in a .linq file
in "C# Program" mode:
void Main()
{
...
}
// Define other methods and classes hereinclude MyClass.cs // <--- something like this
So that we can have MyClass defined in another file (MyClass.cs) and just include it instead of copy&pasting the code. This would allow better code separation and re-use.
811 votesThis is now available in the LINQPad 6 beta:
https://www.linqpad.net/LINQPad6.aspx -
save as .sql files
When I edit a .sql file, if I click save, it prompts me to save as a .linq file. This is annoying as I like to use LinqPad instead of SSMS in nearly all cases and editing stored procs is one of them ;).
9 votes -
Create an IRender plugin interface and create some additional default rendering engines for content
LINQPad is slow when returning large result sets due to it creating and having to render a lot of HTML. It would be nice if there were an option to use a ListView, DataGrid, or any other type of interface that can accept and render data via an IRender interface. It would be great if this were created so that 3rd parties could write Plugins. Additionally, a ComboBox that could be selected would update the results in a different view.
Of course, it would be difficult to render sub-data (Orders->Products) like is done now, but I think that is an…
98 votesThis is now complete. Go to Help | What’s New for info on how it works.
-
Allow to set query transaction isolation level
Most of our queries' transaction isolation level is ReadUncommitted. This is very important on our production db to minimize the impact.
I find myself surrounding my queries with TransactionScope all the time.
In addition, some of the queries requries Snapshot isolation's, etc.
It would be very helpful to allow to set the isolation level in the advanced query properties or something similar.
Thanks.129 votesThis feature is available in LINQPad 8.
-
Add tooltips on columns in schema view to indicate length
It would be nice to see a tooltip pop up over a column in the treeview on the left indicating the SQL type and maximum length (e.g 100 characters)
4 votesIt’s now in the latest release.
-
Support unsafe code blocks in C#
At the moment it won't let you run code with unsafe code blocks. Can this be changed?
1 vote -
Add a MRU to the File menu
Add the most recently used queries to the File menu.
1 vote -
Format 2-D arrays nicely in LINQPad
It would be nice if 2-dimensional arrays displayed as a table rather than a flat list.
1 vote -
Let us edit stored procedures within LINQPad
Can we please right-click on a stored procedure and choose edit
1 vote -
Add Smart Tags for importing additional namespaces
When you type a class such as Registry a smarttag should appear for autocompletion users allowing them to pick a namespace to import - like in Visual Studio.
1 vote -
Format the SQL translations so they can be pasted into Management Studio
The parameters should be be like this:
declare @x int
set @x = 5so we can paste the whole thing into SQL Management Studio to see the execution plan.
1 vote -
Support 1:1 relationships
1:1 relationships would be better represented with entity references on each side - rather than a EntitySet<> on one side.
0 votes -
Search all "My Queries" or Samples for a string
A "find all" dialog that lets you search all samples or "My Queries" for a string.
19 votesCheck out the latest build – a ‘Find All’ option is now on the Edit menu.
-
DumpHTML() to write Custom HTML to the Resultwindow
Would be a great addition imho.
This would enable the user to generate quick'n'dirty reports, add links for directing to (filesystemfolders/websites)
or mailto links to send an email20 votesCall Util.RawHtml, passing in either a string or an XElement.
-
Allow collapse/hide of connections/samples panels
Again thinking about screen real estate, it would be useful if I was able to collapse or hide (pin/unpin) the connections panel and the MyQueries/Samples panel - in the same manner that Toolbox, Solution Explorer etc can be hidden/collapsed in Visual Studio.
60 votes -
Allow results pane to be detached into a separate window
It would be useful if the results pane could be detatched into a separate window for easier viewing.
Since LINQPad now supports Programs as well Statements, the ability to make the most of screen real estate becomes more pertinent.
16 votes -
Make the output window show results as they're produced
For long-running queries that call Dump multiple times, it would be good to have the results from the earlier queries show immediately rather than waiting for the whole query to complete.
33 votesIt’s in V2.0
-
Support Oracle / MySql / SqLite Databases
What are people's thoughts on this? Which is more important: Oracle, MySql or SqLite? Should the support be through custom Entity Framework-driven DataContexts or via automatic DataContexts?
144 votesClick Add Connection and ‘View More Drivers’
-
Allow additional typed DataContext instances to be created
LINQPad automatically instantiates a typed DataContext whenever you run a query with a database. It would be great if we could instantiate additional DataContexts that connect to different databases (with the same schema).
1 voteYou can now go: var anotherDC = new TypedDataContex (“cx string…”)
-
Allow pasting of results into Excel without formatting
Pasting query results into Excel includes HTML formatting which is messy - could this be stripped away to get a more Excel-friendly output?
18 votesIt’s now available in V2
- Don't see your idea?