1185 results found
-
Ability to turn off the automatic query-finder in My Queries when you switch tabs
When I switch tabs, I don't want the Query-tree to update to find the query I'm currently editing. When you have lots of folders it gets rather irritating after a while.
1 vote -
Show username in title bar when impersonating (RUNAS)
I often have multiple LINQPad windows open under different credentials, required for operations against remote servers, but I loose track of which is which. I'd be handy for me to show the username in the title bar (perhaps only if impersonating via RUNAS)
1 vote -
Fix the tab button so that it doesn't add a newline (or allow you to turn that off)
Occasionally, when I press tab, it adds another newline instead of indenting. I can't always recreate it, but it seems to do it at the most inopportune times. It might be an attempt to auto-align method parameters or anonymous type members.
Sometimes, if I press tab enough times, it will start indenting again but, again, I can't tell when it will or won't...
11 votes -
Support SQL Server synonyms in the object explorer
Currently, there is no way to browse the synonyms that are set up for a specific database in the object explorer.
A view of all synonyms for a database would be useful.
4 votes -
show current connection database name for ef db context
When working with curom assembly and connection string coming from config it's not clear which database and server working with as name of the connection will be name of the db contesxt in particular assembly.
It would be really useful to find out which server and database names and also allow different color code base on the name of database or server to distinguish between dev/test/prod.
1 vote -
Automatically name scripts based on first line comment
Sometimes I'm working on 10-15 scripts at a time, using LINQPad as a true scratch pad for C#. I don't necessarily want to save the scripts, but having a visible name for them - instead of Query N - while they aren't the active tab would be extremely useful.
My idea is to use the first line of the script as this temporary name, as long as the first line is a comment. As an example, see how Sublime Text works.
4 votes -
Generate SQL without Execution
Due to work requirements, I cannot use linqpad in our production environment. Instead I will need to generate a SQL script. This is possible right now, however it requires that you include a SaveChanges call to the context to generate a real script which will also execute the change. It would be nice to generate the script without actually executing the script, this way I can test the SQL script against my test environment without having to reset the data that was changed by executing the script in linqpad.
4 votes -
Special insert datetime.now
Just as I use alt + g daily to insert a Guid, I miss a shortcut to make a datetime.now when inserting data.
6 votes -
Dump of enumeration of inherited objects should display actual classes
If I have an enumeration of nodes that can be of type text/html/custom I get the class specific properties in their own columns but there is not indication on the actual class of each line.
When debugging or investigating deep class hierarchies knowing the exact class each line was would be very helpful.
Now one have to determine this through the properties which is not always easy, especially with library code that you have no internal knowledge of.
1 vote -
easier Date/Time data entry in grid
Our database has an audit field:
[ActionDateUtc] DATETIMEOFFSET NOT NULL CONSTRAINT DEFAULT (SYSDATETIMEOFFSET()),
When I click "Add Row", this field is defaulted blank rather than null, and annoying since the only way to enter a date at this point is to manually key it in.
Save fails due to SQL overflow, and since save happens when you move off the record, it's not easy to copy/paste an existing one.
Ideally it would be fantastic if LINQPad would recognize that the value will be supplied by the DB, failing that a right click menu to enter 'now' or 'utc now' would…
1 vote -
Create a way to associate .sdf-Files (SQL CE) with LinqPAD
For using LinqPAD for everyday work it would be extremely helpful to have a file association set to open .sdf-Files with LinqPAD directly. Up to now I do not think this is possible. Maybe you could consider a command line option to pass a filename (or connection string) to LinqPAD at start - this would be perfectly sufficient for us by enabling us to write a wrapper providing the desired functionality.
3 votes -
Stop linqpad from querying __MigrationHistory on each call
EF queries the __MigrationHistory each time the DbContext is opened to ensure the DB context is in sync with the DB. This can be very expensive. Can LinqPad provide an option to skip this check by doing Database.SetInitializer<UserQuery>(null)?
UserQuery seems to be the class that gets derived from the user created DbContext.
4 votes -
Add Alt+Enter shortcut to pop up the auto-suggestion drop down (a la Resharper)
When I enter a class name from a namespace that isn't referenced, a little auto-suggestion hint appears. In VS+R# I would hit Alt+Enter to open this menu, and then Enter to accept.
In LinqPad I have to use the mouse to do this.
4 votes -
Don't automatically populate the connection when creating a new query
Sometimes when I start up a new query, I type a single C# expression like "Environment.OSVersion" and then hit run. It doesn't execute instantly and I look at the status bar and see "Fetching Schema...". Then I see that LINQPad automatically assumed that I was going to use the connection I used last time I wrote a query and added it for me. Although this may be useful for someone who uses LINQPad exclusively for querying a single database, this is annoying for others who use it as a C# scratchpad or frequently query different data sources.
3 votes -
SQL format
Have an option that formats the sql statements just like in sql management studio
11 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 -
LINQPad, handy scretch pad.... Why not share?
I keep coming back to LINQPad to write few lines, execute ...verify, then go back to implement the small bit I just wrote and I am sure everyone does that and some would save those random scratch for later use or reference. So I wonder, why not a code snippet share feature directly from LINQPad? It would increase awareness and allow us share or persist some of the quick code written every now and then.
Cheers.
Biniam0 votes -
Add additional database option in menus
I feel like the 'easy' way to add additional databases to a query is way too cryptic: holding down Ctrl while dragging the additional db to the query.
There should be a menu option when right-clicking a database in the connections pane, or in the Query menu. Just somewhere where you can discover it intuitively, in stead of having to check the FAQ.1 vote -
Navigate To/Control- to Search and Create New Query for Connection
Using Navigate To (Control+,), allow us to type name of connection as well and if we select it, it automatically makes a new query against that connection. I'm pretty much 'mouse' free on LINQPad except for this scenario.
3 votes -
Allow playing a sound (or flashing the window or whatever) when a long-running query completes
I often have to run scripts that take a lengthy amount of time (between 3 and 30 minutes, and it's not known ahead of time exactly how long it'll take). Currently I have to remember to keep checking back to see if it's finished yet as I switch over to another app to work on something else.
It would be much more useful to switch that 'polling' to 'interrupt-driven'. :) Specifically, I'd love to be able to set an option similar to "if a query runs longer than X seconds (X = 30 would be what I set it for,…
6 votes
- Don't see your idea?