1205 results found
-
Compact (and name) the amount of SQL Parameters
The amount of duplicate SQL Parameters are too damn high :-)
eventhough i in C# declare the inputs as variables, the SQL parameters are duplicated pr use of the paramenter.
eg:
var DS = 127;
var genart = "00402";
var critno = 100;becomes :
-- Region Parameters
DECLARE @p0 Int SET @p0 = 100
DECLARE @p1 VarChar(1000) SET @p1 = '00402'
DECLARE @p2 NVarChar(1000) SET @p2 = '-1'
DECLARE @p3 Int SET @p3 = 100
DECLARE @p4 Int SET @p4 = 2
DECLARE @p5 VarChar(1000) SET @p5 = '00402'
DECLARE @p6 NVarChar(1000) SET @p6 = '-1'
DECLARE @p7 Int…4 votes -
4 votes
-
Add support for Failover Partner when creating a SQL connection
We have 2 SQL servers set up with mirroring. Some databases are live on one and passive on the other and vice versa. It would be handy if I could put Failover Partner in the connection string to save me having to have 2 different connections.
4 votes -
4 votes
-
Allow Column Names in a Table to be Sorted
We are using the IQ "driver" to connect to an Oracle database. When expanding a table, the list of columns in the table is displayed. It would be a huge help if this list could be sorted. We have several tables each with over a 100 columns and it becomes very difficult to find the column we're looking for.
We'd liek to see an option (perhaps in Preferences) that allows us to see the list of columns sorted alphabetically (or reverse alphabetically).
Thanks
4 votes -
Snapshot saving
Due to the nature of Linqpad, I'm often using it for handling one-off processes or experimenting. It would be nice to be able to quickly step through all the saved states of a particular snippet, etc. Could marry with an advanced Undo system.
4 votes -
Enhancement of autcomplete on subqueries
When writing for example:
from u in Users
select new
{
UserDetails = (from ud in ....
}When I press "u" I would expect u as the alias for Users in the outer query, but it picks up everything.
4 votes -
Query Properties Profiles
Query Properties - Profiles
Set and save different Profiles for query properties. We have different code branches for development and release cycles. It would be great if I could setup and switch between different profiles for a LINQ script.
4 votes -
SQL table direct editing: Leave mode, and ask before saving row changes
I like the ease of directly editing SQL tables in the premium edition. However, it's a little too "eager" to save for my taste. I'd like to suggest a couple related changes to make it safer for a klutz like me to use without accidentally nuking things:
1) LP has the new "Edit" button, but not an "End Editing" button.
2) When clicking between rows, any changes to the row being "blurred" (moved away from) are automatically saved. It seems like it should be asking first, at least once.Combined, these two things would make it much safer.
4 votes -
Save As.. = Ctrl+Alt+S
New shortcut for "Save As" command.
4 votes -
Make it possible to call WinRT APIs from LinqPad
As explained here: http://www.hanselman.com/blog/HowToCallWinRTAPIsInWindows8FromCDesktopApplicationsWinRTDiagram.aspx
I often use LinqPad to test small pieces of code, but I can't do it when this code depends on WinRT APIs...
4 votes -
Dump collections as each item is processed
Every so often, I would be running a long running query that yields many results. And every once in a while, when dumping the results, there is a failure because of some exception (e.g., OutOfMemoryException, NullReferenceException, etc.) and you never see any of the results because of that. The dump method only writes to the results until the entire collection has been processed and renders them all at once.
It would be nice if LINQPad would dump each item as the collection was being processed so in the event of a failure, we could see the results that have been…
4 votes -
Step by step wizard to create linq query
Most of the times Pivot tables are used for Data Visualization/Graph. Would like to see wizard that can help you creating pivot table.
4 votes -
As a driver developer, I want to include 16x16 icons that override the default ExplorerIcons.
For example, if I am working on (hypothetical) HTTP/REST-based driver, I would l like icons that read GET, HEAD, POST, etc. next to the url path that would be displayed as the ExplorerItem text.
4 votes -
Interop among queries (and languages) inside LINQPad
For example, I have a query with code written in F#. Then I can reference this query in a C# query and use the functions that I wrote in the F# query. So, that is not necessary to open Visual Studio, create a F# project write the code then compile it to a .dll and then reference that assembly in a C# query in LINQPad,
4 votes -
Column Mode and status bar informations
Add support to Column Mode ("Shift + Alt" in Visual Studio) and show the Ln, Cols and Ch information in status bar like in Visual Studio.
When I need do a substring in a line of text, I need use other editors (like Notepad++ or even Visual Studio himself) to know which position of chars.
4 votes -
Include additional databases (linked) servers INFORMATION_SCHEMA
When including additional databases from (linked) servers, the INFORMATION_SCHEMA views from the linked database should be included.
We can then use LINQPad to compare schemas between databases.4 votes -
Support Console output e.g. Backspace /b etc
int updateCount = 343;
for( int i = 0 ; i < updateCount ; i++ ){
string msg = string.Format( "Update Progess:{0:p}" , (double)i/(updateCount-1) );
Console.Write( msg );
Console.Write( new string( '\b' , msg.Length ));
}
Console.WriteLine();4 votes -
feature
I'd like linqpad to save all open queries when closed. Similar to how it recovers unsaved queries after crashing. If I've changed 'Named' queries it would prompt to save changes, but unnamed queries are just saved without a dialog.
I often have numerous ad-hoc queries I've written over the course of a day and are specific to what ever issue is the daily crisis.
Also auto language detection would be nice as well; C# Vb ect.
4 votes -
Add option to open Data Grids in Edit Mode
When cleaning up a lot of data by hand, it gets very tiresome to have to click 'Edit Data' on every table. It would be very useful, and save a lot of time and stress on one's wrist, to be able to have tables open already in edit mode.
4 votes
- Don't see your idea?