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.
For databases with hundreds of tables, it would be great to filter tables and columns by having a textbox at the top of the connection panel. As you type, it would autofilter the currently selected connection.128 votes
It would be great if LinqPad would support scriptcs or Roslyn since it already has NuGet support. Another option would be to export the .linq project as scriptcs project.120 votes
F# 3.0 type providers seem like they would fit in quite well with the LINQPad-as-data-explorer mission.119 votes
It would be nice to have the ease-of-access of folders in different locations throughout your computer within the "My Queries" window.
Similar to WIndows 7 Libraries that allow you to add multiple music directories to "My Music" etc. This would be in case you have a folder that you store work queries that you share with others but also a personal folder for your own queries.115 votes
Reporting made easy...just write linq scripts and ship them with your app with the linqpad user control embedded in the app too. :)
I would prefer it in WPF but would settle for winforms.110 votes
I want to send a link to my team and have them test drive premium for a few days. If they like it, we want to buy a bunch of licenses. A trial offer that lets us use it in real development for a few days is critical.107 votes
I'd like to see a feature which allows users to create a 'query template' which can be used as a starting point for any new query .
A query template would have preset properties, references/usings, database connections, code, etc. and users can create as many templates as they like.
This is not much unlike using a saved query, but the difference is that users are not be making changes to the original when they create a new query from a template.92 votes
would be great if you could use Visual Studio Code as editor (IDE)86 votes
you're almost there -- give me the whole thing, baby!84 votes
I mean, come on... this is a brilliant idea! The beauty and power of VSCode, plus the beauty and power of LINQPad?
LINQPad could inherit the editor features of VSCode and output its results in a separate pane.
We do it now through a secondary dll and machine.config for configuration. Would prefer to reference the service directly. This would also include the ability to use configuration files.75 votes
Exposing the internal to Linqpad is a great idea, it would be nice if this work for signed assembies too.
For now the 'LINQPadQuery' is unsigned (PublicKeyToken=null).
LINQpad itself is signed, but this key is not used when signing LINQPadQuery.75 votes
I'd created an idea for LINQPad to offer a REPL experience already (since I can't use language features like LINQ comprehension syntax or the like from PowerShell scripts), but now that Roslyn CTP is out and csx / C# script is alive, I'm hoping that the effort required would be much lower in LINQPad to offer a REPL. If it only works when Roslyn is installed, then that's fine with me, and it helps bridge the functionality gap for those of us that love LINQPad but want to use it as a REPL so we can keep results/objects/graphs in memory and not have to re-generate them each time.
An alternative that just keeps the same 'context' around each time (same instance of UserQuery subclass, I guess?) such that the local vars (or at least instance vars) stick around between queries (in the same tab, in the same running process, not persisted anywhere) would be a useful fallback if a 'real' REPL isn't viable. :)
I'd created an idea for LINQPad to offer a REPL experience already (since I can't use language features like LINQ comprehension syntax or the like from PowerShell scripts), but now that Roslyn CTP is out and csx / C# script is alive, I'm hoping that the effort required would be much lower in LINQPad to offer a REPL. If it only works when Roslyn is installed, then that's fine with me, and it helps bridge the functionality gap for those of us that love LINQPad but want to use it as a REPL so we can keep results/objects/graphs in memory…73 votes
Use Ctrl D for duplicate: copy the line that the cursor is on to the line below. Currently it isn't doing anything as far as I can see.67 votes
I keep double clicking on text in the results pane when viewing results in the rich text format and expect the string to be selected.
Instead it's somewhat unintuitive and requires a click and drag, which take a fair bit longer if I'm only after the text in a single cell.66 votes
An Oracle user may have access to multiple schemas with table definitions. It would be nice to specify the schema in the query.
E.G. I have a user that can see two schemas ,users and customers. Currently I have to specify the schema I want to use when setting up the connection. So, I can only query one schema per session. It would be great if I could do something like the following:
var customers = from c in customers.sometable
var users = from u in users.sometable
in a single session65 votes
I want to create a JSON file for use as part of a simple web prototyping exercise. LinqPAD is perfect for accessing the data from my DB in just the shape I need, however I cannot get it out as JSON very easily.
It wold be great if it ran on the Mac natively. OTOH it works fine in Parallels. Thanks! And long time no see.62 votes
- Don't see your idea?