LINQPad

New and returning users may sign in

Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
  • Sign in
  • Sign up

LINQPad Feature Suggestions

More than 100 LINQPad features are a direct result of customer feedback! This is the official forum for posting and voting on ideas – we want to hear from you!

Feedback

10 10 votes

LINQPad Feature Suggestions

Categories

  • CATEGORIES
  • All ideas
  • My feedback

(thinking…)

  • Searching…

    No results.

    Clear search results
    • LINQPad Feature Suggestions 1,041 ideas

  • LINQPad

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

votes
Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Cancel Submitting...
  • or
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

  1. CTRL-E to execute a query (for those of us who are used to it from QueryAnalyzer days)

    User entering CTRL-E should execute a query justlike F5 does. I am in the habit of that keyboard combo from old queryanalyzer days

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  2. Create a SQL view in the database directly from a Dump() result

    Have the possibility to create a SQL view from the result of a dump() !
    Linq is create to quickly extract complex data. If after you have just to click a button to save this in database it will very useful.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  3. Make Dump() function in C# statement mode grey

    It's kinda getting into the way for samples. Not a very big deal though, but if there's an option to grey out the Dump() function, the main statement would be a little bit more clear.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  4. Add Random newid() support to TypedDataContext

    Super easy, add this method to your Program script:

    [System.Data.Linq.Mapping.Function(IsComposable=true)]
    public Guid NewId() => Guid.NewGuid();

    Then use like this:

    Users.OrderBy(o => NewId())

    This will translate to the usual sql statement for the server-side execution:

    select * from Users order by newid()

    Which is shuffling on the server side.

    The C# implementation is never used (Guid.NewGuid()) but is useful nonetheless if someone calls it from the application-side. You can replace it with throw new NotImplementedException() and it will still work just fine.

    Would be great if it was embedded into the TypedDataContext (or elsewhere) within LinqPad.

    Based on Marc's answer here: https://stackoverflow.com/questions/648196/random-row-from-linq-to-sql

    Super easy, add this method to your Program script:

    [System.Data.Linq.Mapping.Function(IsComposable=true)]
    public Guid NewId() => Guid.NewGuid();

    Then use like this:

    Users.OrderBy(o => NewId())

    This will translate to the usual sql statement for the server-side execution:

    select * from Users order by newid()

    Which is shuffling on the server side.

    The C# implementation is never used (Guid.NewGuid()) but is useful nonetheless if someone calls it from the application-side. You can replace it with throw new NotImplementedException() and it will still work just fine.

    Would be great if it was embedded into the TypedDataContext (or elsewhere) within LinqPad.

    Based on Marc's answer here: …

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  5. Load Schema as a separate function option. I am attaching to a very very large database and it is timing out loading the schema.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  6. F1 link to page in your books

    Assume that a user has a PDF of your book or Skeet's book. Think of using the Nutshell and In Depth (Skeet) books as help files by linking context help (F1) in LINQPad to topics in the PDF books. If manipulating the PDF is too difficult you could load the clipboard with the appropriate page number for the topic; the user could paste the page number in the upper left box of acrobat or PDF reader is used. I like LINQPad and I have the super-duper-expensive version but I use LINQPad as a C# and NET learning tool for my programs and rarely use LINQ per se.

    Assume that a user has a PDF of your book or Skeet's book. Think of using the Nutshell and In Depth (Skeet) books as help files by linking context help (F1) in LINQPad to topics in the PDF books. If manipulating the PDF is too difficult you could load the clipboard with the appropriate page number for the topic; the user could paste the page number in the upper left box of acrobat or PDF reader is used. I like LINQPad and I have the super-duper-expensive version but I use LINQPad as a C# and NET learning tool for my…

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  7. connection

    I am trying to creat connection but i am unable to connect.
    Let us know what exactly the parameter here for http://{MachineFQDNORMachineIP}/ Citrix/Monitor/OData/v1/Data
    MachineFQDNORMachineIP}/ --- Database server on which monitoring database is residing or Desktop director server name.
    Citrix---?????
    Monitor ---- is the instanse name

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  8. Bug: lprun stuck forever when the query has already finished

    The hang occurs when there is an unclosed external resource. The linqpad doesn't get stuck because it doesn't unload the application domain and therefore does not wait for the process to exit completely.

    There should be some sort of a timeout for the registration of the query exited event and the finilizers to finish their job. If they don't finish in a timely manner you need to kill the process forcefully.

    We were using https://github.com/sshnet/SSH.NET and didn't call .Exit() everywhere.

    This produces the hang of sorts:

    <Query Kind="Statements">
    <Reference Relative="....\SSH\Renci.SshNet.dll">C:\Users\User\Desktop\SSH\Renci.SshNet.dll</Reference>
    <Namespace>Renci.SshNet</Namespace>
    </Query>

    var sshClient = new SshClient("demo.wftpserver.com", 2222, "admin", "root");
    sshClient.Connect();
    var command = sshClient.RunCommand("test");
    command.Result.Dump();

    Then call:
    lprun ssh.linq

    <-- dreadful hang is right here

    The hang occurs when there is an unclosed external resource. The linqpad doesn't get stuck because it doesn't unload the application domain and therefore does not wait for the process to exit completely.

    There should be some sort of a timeout for the registration of the query exited event and the finilizers to finish their job. If they don't finish in a timely manner you need to kill the process forcefully.

    We were using https://github.com/sshnet/SSH.NET and didn't call .Exit() everywhere.

    This produces the hang of sorts:

    <Query Kind="Statements">
    <Reference Relative="....\SSH\Renci.SshNet.dll">C:\Users\User\Desktop\SSH\Renci.SshNet.dll</Reference>
    <Namespace>Renci.SshNet</Namespace>
    </Query>

    var sshClient = new SshClient("demo.wftpserver.com", 2222, "admin", "root"); …

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  9. public editable feature API for custom driver

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  10. support POCO methods and properties in LINQ to Entities

    Currently I get the following exception when accessing POCO methods and properties.
    NotSupportedException: The specified type member 'Language' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  11. 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
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  12. Add commas to the row count of results

    Add commas (or whatever the user's localization number delimiter is) to the number of rows returned that is displayed in the status bar under the DataGrid. When the number is large, like 849054, it's easier to read it in groups as 849,054.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  13. 'Add relation' menu item in database tree menu. This will help to add connections which are not excplicitly defined in database.

    On clicking Add connection sap bo sttle join dialog will appear where one may define relation with other tables. In many databasese relations may not be defined explicitly. This feature solves the priblem.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  14. Add buttons on query menu for Debugging optionss

    Add buttons on query menu for Debugging

    ie:

    Step into
    Step over etc

    configurable in preferences

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  15. take over the entire Microsoft Sql Management Studio Team?

    Just sayin...

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  16. BUG: FileLoadException when querying an EF Typed DataContext with a comma in the folder path

    When running a query against an EntityFramework Typed DataContext connection, and the assembly folder path has a comma in it, linqpad shows System.IO.FileLoadException "The given assembly name or codebase was invalid". The context connection and tables show correctly on the left, but queries fail to execute.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  17. Add codepage support to Util.Cmd

    Basically you need to change the ProcessStartInfo.StandardOutputEncoding with the supplied codepage, or get the default from registry. Localized versions of Windows will print gibberish with basic operations like Util.Cmd("ping localhost")

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  18. Add way to search datagrid contents

    Seems like it would be handy to have a way to search the datagrid contents.

    You can use ctrl-f in the standard results but that doesn't appear to work when viewing datagrids.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  19. Leave the time it took for the query to complete after completion.

    When the query is running there is a counter but after it completes the counter goes away, can you leave it up?

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  20. fix

    Is it possible to use linqpad 5 with odata driver using metadata stored on a local file ?

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
← Previous 1 2 … 43 44 45 46 47 … 52 53 Next →
  • Don't see your idea?
LINQPad
LINQPad Terms of Service Powered By UserVoice

Your password has been reset

We have made changes to increase our security and have reset your password.

We've just sent you an email to . Click the link to create a password, then come back here and sign in.