1185 results found
-
add grouping to result view
It would be great to be able to group results into a tree view by dragging columns to a grouping pane (just like in Qutlook).
For investigating data grouping is one of the most powerful tools.
So if you have a result with columns col1, col2, col3 you would drag e.g. col1 to the grouping pane and then see a list of distinct values of col1. Each value is a tree node. Once you expand the tree node you will see the result items belong to that value of col1. Certainly nested grouping (col1+col2) should be supported as well :-)…6 votes -
organization
Support authentication using Azure Active Directory. This is necessary for OData endpoints in services tied to Office 365 such as CRM Online and Microsoft Dynamics Marketing. Please see http://community.adxstudio.com/blogs/shan/2014-12-10-using-odata-feeds-with-mdm/ and how Power Query authenticates against OData using Microsoft Organization Account for authentication.
15 votes -
Allowing adding associations between tables.
I work at a company where (a) only DBAs can change the DB, and (b) the DBAs avoid adding foreign keys. So, when LinqPad builds the table objects, they lack the association properties. I'd like to be able to add them when working with LinqPad. (in-memory only is fine for now; persisting them can wait for some future suggestion....)
11 votes -
Allow one 'MyExtensions' class per query sub folder
I'm starting to have a big folder hierarchy in My Queries, using each sub folder for a specific purpose.
The MyExtensions class is growing huge, if I could have one extension class per sub folder I would organize my extensions in a much clearer way.
I also hit a wall when I wanted to use a dll from a previous version that was already included in the global extensions. My query failed with exception: "Assembly 'MyExtensions.FW40 ...' uses 'MyAssembly, Version 2.0.0.0' which has a higher version than referenced assembly 'MyAssembly, Version 1.0.0.0'.
8 votes -
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
- Don't see your idea?