1215 results found
-
Recognize type when exporting to excel
Currently when you have a dataset and you export it to excel, it works great except for field types. Excel likes to assume what data type is in each cell, and in cases where there are string values with padded zeros (e.g. 0012345) excel thinks it's a number and drops the padding.
Is there any way you can apply column formatting (even the most primitive like Double=>Number, String=>Text, Decimal=>Money, etc.)? This would preserve data during the transition to excel making the export a true 1:1.
14 votes -
Ability to sort files in "My Queries" tab
Just a minor suggestion. I'll like to be able to sort files in the "My Queries" tab - by date modified, by date created, by name etc. I experience a little frustration having to remember the name of the last file I worked on.
3 votes -
Paste as comment
Paste as a comment block
Just like the paste as escaped string is great, i think paste as comment block would be just as useful.
1 vote -
Export to Visual Studio 2015 Snippet
Allow for LINQPad Query to be exported as a Visual Studio 2015 XML Snippet file.
1 vote -
Allow user names for results grids
Simpley allow the usr to rename the grids, or perhaps to provide a comment in the sql to name the results grid for each query when doing multiple queries.
1 vote -
4 votes
-
Allow remote execution of scripts with lprun
We use lprun with teamcitry to generate various statistics and post them to our wiki every week. However today it is not possible to execute these scripts with lprun, without first manually enter the credentials on the particular machine first.
Lprun should be able to execute remotely, without having to manually configure it on every machine. A really simple way, would be to let users disable encryption of the password. Another possibility, is to let users specify a certificate to use for encryption.
1 vote -
Date picker on data grid
It would be handy to have some sort of date picker and/or perhaps auto-insert of the current datetime in the data grid.
5 votes -
Allow Results To Be Screen Captured To Image Hosting Service
Ability to right click on the results area to do a screen capture (image) of the result(s) to be taken and sent to a predefined image hosting site.
Then provide access the image URL in the clipboard in either raw html or in StackOverflow format.
[Title Here](http://{Image Hosting Addy to image})
1 vote -
Preview SQL table content
I often find myself using LINQPad to look at the latest data inserted into database tables. I keep a lot of tabs open with something like
myTable.OrderByDescending(t => t.TableId).Take(10)I also spend a lot of time flipping through a bunch of tables to find the data I'm interested in.
I think both use cases could be helped if LINQPad could open a temporary tab with the top 10 or 25 rows when clicking/navigating with the keyboard in the tables list in the left pane in LINQPad.
Preferably the results should be sorted descending by the primary key (at least for…3 votes -
GridView results should use full width of pane if needed, instead of ellipsissing cell values
Using grid view, the column widths are currently set for the minimum to handle the header text, often visually truncating cell values even if there is unused width available in the grid UI.
If nothing else, divide the available space by the available columns to compute a minimum initial column width. Even better would be if it takes the retrieved values into account and make narrow valued columns narrower.
1 vote -
Avoid DevArt assembly collisions with user query references
Not sure how viable this is, but I spent all day today trying to find the source of an assembly collision that prevented some code compiling in Linqpad, only to find that the stray version originated from Linqpad itself!
If possible, I suggest you avoid injecting Devart.Data / Devart.Data.Oracle assemblies into the query app domain if later versions of those assemblies are already being (directly) referenced by the query. Otherwise you create assembly binding issues for the compiler.
Failing that, Linqpad.config should probably have some binding redirects for DevArt.Data / DevArt.Data.Oracle
(Linqpad 4.55 references DevArt.Data.Oracle 7.9.333.0, my query references assemblies…
1 vote -
1 vote
-
Support Edit Table Definition (schema) like in SSMS
LINQPad supports editing of function/view definitions. It would be great if we could also edit table definition, like SSMS offers (script table as...).
That feature is the only reason I'm using SSMS.
4 votes -
DumpLatest - highligh differences after dump refresh.
Add to DumpLatest option similar to what 'watch' command does with flag '--differences'.
This would allow nice&easy visual monitoring of changes in any data.
I use for example code like this to visually monitor changes in DB:
Observable.Interval( System.TimeSpan.FromSeconds(2) )
.Select(x => this.GetSomeDBTable )
.DumpLatest();Having any changes in dump output highlighted with for example yellow background would be nice.
6 votes -
Add support to paste clipboard JSON as classes
It would be great if LINQPad could create classes from a JSON object in the clipboard (Just like the WebEssentials extension for VisualStudio can do)
29 votes -
when I call " Console.writeline(Obj); " with overridden ToString in my Obj then LinqPad does not show the simple String Output but some kind
when I call " Console.writeline(Obj); " with an overridden ToString in my Obj then LinqPad does not show the simple String Output but some kind of formatted object structure of Obj. I did not find a switch for that behaviour anwhere. I can work around with using Debug.WriteLine instead of Console, but a simple switch in the UI or Preferences would be nicer.
3 votes -
Add a sortable date column to the MyQueries' Organize and GoTo tabs
I'm usually looking for the last time I used the thing I'm looking for. I'd like to be able to sort the found files in reverse date order.
2 votes -
Autocomplete lambda expression on adding event handlers
myForm.Activated += // then, suggestion like "(sender, e) =>" is shown
3 votes -
Add more code formatting options to LINQPad 5
It's great we can control where braces go (on their own lines of course), but needs option for spaces inside non-empty parentheses etc. Auto-formatting is awesome (and I don't want to turn it off), but removing my spaces is just rude :)
6 votes
- Don't see your idea?