1182 results found
-
Map char(1) to string, as sqlmetal does
When I generate a DataContext through sqlmetal, it converts all char fields to strings. Not what I'd expect it to do, but not a bad idea.
When I generate my entities through LinqPad, char fields are left as char, making my sqlmetal generated code incompatible with LinqPad.Just as there are options on pluralizing and capitalisation, It would be useful to have a "convert char to string" option as well.
9 votes -
Export Query Option
I have been using LinqPad for a while and have created a lot of extensions and other helpful utilities in My Extensions. When I go to share a LinqPad query with someone else, I forget that I am using my extensions and so they cannot compile or run it.
It would be great if there was an "Export Query" function that would detect calls into "My Extensions" and copy applicable (or all) code to the bottom of the query (query would have to be forced to C# Program Mode). Then the query would be ready to send to someone else,…
9 votes -
Make the Production flag user configurable
I love the idea of annotating a database session with a flag similar to the colors in the SSMS Tools for SQL Server. I never connect to a production system, but I connect to many remote databases and would love to be able to discern the connection quickly.
9 votes -
Add support for InternalsVisibleTo on assemblies with a strong name
I know that I can use the option to enable InternalsVisibleTo in LinqPad (https://linqpad.uservoice.com/forums/18302-linqpad-feature-suggestions/suggestions/513533-add-support-for-internalsvisibleto), but this only works if the assembly does not have a strong name.
It would be good if there was a way to add LINQPadQuery with a strong name as a friend.
9 votes -
Detect Oracle VirtualBox as a VM When Checking Licensing
The Licensing conditions say: "three computers ... plus 3 virtual machines running MS VPC, Hyper-V or VMWare". Does anyone else use Oracle's Virtual Box to run VM's in a development environment? Whenever I install LinqPad on a VBox VM, it counts against my PC installs and is not detected as a VM. VM's are for tearing down and setting up quickly and so the "six transfers per year" doesn't cut it either. I actually bought a second license to have to stop deactivating from my non-VM hardware so often.
9 votes -
Allow users to specify table relations in DB schema on LinqPad side
I have a back end DB for an ERP system which has thousands of tables but all the relations between those tables are serviced by ERP itself.
When I need to write a query to that DB I have to make all the joins explicitly, which makes query ugly and must be repeated in each query. I cannot touch the DB itself - it is governed by ERP, but if I could specify relations between tables on LinqPad side, then I could use full power of Linq queries every time. The relations should be addable ad hoc, one at a…9 votes -
Export Connection Strings of Saved Connections
It'd be great if we could quickly get a properly formatted connection string for any of our database connections.
9 votes -
Enable Excel export without having Excel installed
I often run Linqpad on a server where I don't have Excel installed (due to the SQL server being behind a firewall).
It would be nice if the Excel export could work regardless of Excel beeing installed on the machine or not.
Perhaps using a library like ClosedXML or similar.9 votes -
sort database names
When I connect to a server which has a lot of databases (Azure in my case), it would be nice if the list of databases could be sorted alphanumerically in the connection window.
It's possible this option exists, but I have yet to find it!
9 votes -
Make it possible to define aliases for the SQL results.
When we create a Linq expression or whatnot, the SQL generated aliases our tables to "t0", "t1" - etc. There are many times it would be nice if the alias either maintained the variable we used in our query (table=> table.ColName) or allowed us to define aliases in some other, metadata file.
Thanks!
9 votes -
Dump Roslyn SyntaxNode variables in the "Tree Visualizer"
I really love the "Roslyn Syntax Tree" visualizer, and use it a lot to inspect how the code looks like a tree.
However, I also do a lot with Roslyn, analyzing code, and writing code fixers. I'd really love it when I have a SyntaxNode, to be able to dump that to the Tree visualizer, and see it's tree there.
9 votes -
allow extensions that act on the linqpad editor itself
It would be cool if you could write extensions or plugins for LinqPad which act specifically on your LinqPad selection or clipboard. Then configure shortcuts to call them.
Some examples:
Uppercase or Lowercase current selection.
Take current clipboard input and format it before pasting it into the LinqPad text editor view.
etc...
9 votes -
date modified navigate to query
Add Date Modified column to the Navigate to Query screen and allow column sorting.
9 votes -
To be able to search/filter in connection combo box
with the shortcut Alt+C one is able to drop down the connection combo box. However, when you have several databases it gets too long to scroll using the arrow key. It would be really good if it is possible to do a fuzzy search and shorten the list of choices just as who the intellisense is working today.
9 votes -
Save All option (like Ctrl + A + S) to save changes in all opened query files.
Save All option (like Ctrl + A + S) to save changes in all opened query files.
9 votes -
Allow login with windows authentication with other user credentials
Please add an option for logging in to MS SQL Server with other user credentials than currently logged in windows user ("Windows authentication")
9 votes -
Ctrl+[ to exist insert mode
Any of the following key combinations will exit insert mode: Escape, Shift+Enter, Ctrl+Enter. Typing 'kj' quickly will also exit insert mode if you enable that option in Preferences.
Ctrl+[ is a common alternative to escape in vim. A lot of vim users do not use the Esc key directly as it means taking your hand of the home row. Specially if you have Caps lock mapped to Ctrl. It would be nice to have it as an option.
9 votes -
Close queries to the right, similar to Chrome, Edge, etc.
When right-clicking on a query, add an option to close queries to the right of currently selected query. Dialog-wise when handling unsaved queries is at your discretion, but I can see something as follows:
-If there's no unsaved queries, don't prompt asking to save.
-If there's one unsaved query, do a prompt asking to "Save Query X?".
-If there are multiple unsaved queries, do a prompt asking to "Close all unsaved queries to the right of [currently selected query name]9 votes -
Allow column exclude / filter (Temporal Tables)
When working with temporal tables there is no way to use LinqPad to alter / insert entites because it attempts to set values on AsRowStart columns -- and so the insert/updates will fail.
It would be nice to be able to exclude a column from consideration in a context / entity as this would solve this problem.
9 votes -
Support EF6 in LINQPad 6
EF6 supports .NET Core 3 with the 6.3 release.
We've since been able to port our existing .NET applications to .NET Core. The only regression we're still suffering is that the LINQPad experience is degraded due to there being no EF6 provider.
9 votes
- Don't see your idea?