1206 results found

1. Query result shown as rich text when run from stored file - default setting = data grids

   My default for an SQL-result is "data grids". But when running a script from a saved SQL-file, the result is shown as rich text (html).

   Please apply the default in this situation as well. Thx

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Option to auto run script on change

   A technique I use to quickly test an idea is to have a dummy "test" method that calls a method I'm working on. Used in conjunction with NCrunch, and Console.WriteLine(), I can make changes to the method and immediately see the results without having to save/recompile/run (continuous testing).

   I think it would be great if LInqPad also allows for this kind of cycle. Being able to see the progress of a script without have to stop and run every time making a change can be a huge productivity booster - especially when incrementally building an algorithm.

   I think it would make sense to only enable this on a per query basis.

   A technique I use to quickly test an idea is to have a dummy "test" method that calls a method I'm working on. Used in conjunction with NCrunch, and Console.WriteLine(), I can make changes to the method and immediately see the results without having to save/recompile/run (continuous testing).

   I think it would be great if LInqPad also allows for this kind of cycle. Being able to see the progress of a script without have to stop and run every time making a change can be a huge productivity booster - especially when incrementally building an algorithm.

   I think it would… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

3. Name User License for Linqpad

   Name User License so I log on for use software with same attual restriction (6 user for license activated). So I can use the software without active/deactive but limit of connection for user

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

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: … more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. 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 Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. My Extensions are ignored when using Ctrl+, (Navigate to Query)

   Add "My Extensions" to search results of the Navigate to Query dialog

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

7. Cross-server and cross-domain queries

   It is time to move to the next level: cross-server or cross-domain queries, for a truly great orchestration experience.

   I have experimented with this and it's working nicely:

   dynamic odata = Activator.CreateInstance(Type.GetType("LINQPad.User.DemoService, odata", true), new Uri("https://services.odata.org/V3/OData/OData.svc/"));
   ((object)odata.Persons).Dump();
   dynamic a = Activator.CreateInstance(Type.GetType("LINQPad.User.TypedDataContext, a", true));
   ((object)a.Persons).Dump();
   dynamic db = Activator.CreateInstance(Type.GetType("LINQPad.User.TypedDataContext, db", true));
   ((object)db.Products).Dump();

   I'm specifically referring to this line in the FAQ (https://www.linqpad.net/FAQ.aspx):
   "The databases that you query must reside on the same server."

   That's a major limitation.

   Possible solutions:
   1. Unique data context class names in the LINQPad.User namespace.
   2. extern alias functionality?
   3. Uniquely nest all classes with respect to their connection name (for example, in the db.dll all classes will reside in LINQPad.User.db.* as opposed to the current LINQPad.User.* namespace)
   4. With odata you named the resulting class DemoService, perhaps the same could be done with the sql connections

   It is time to move to the next level: cross-server or cross-domain queries, for a truly great orchestration experience.

   I have experimented with this and it's working nicely:

   dynamic odata = Activator.CreateInstance(Type.GetType("LINQPad.User.DemoService, odata", true), new Uri("https://services.odata.org/V3/OData/OData.svc/"));
   ((object)odata.Persons).Dump();
   dynamic a = Activator.CreateInstance(Type.GetType("LINQPad.User.TypedDataContext, a", true));
   ((object)a.Persons).Dump();
   dynamic db = Activator.CreateInstance(Type.GetType("LINQPad.User.TypedDataContext, db", true));
   ((object)db.Products).Dump();

   I'm specifically referring to this line in the FAQ (https://www.linqpad.net/FAQ.aspx):
   "The databases that you query must reside on the same server."

   That's a major limitation.

   Possible solutions:
   1. Unique data context class names in the LINQPad.User namespace.
   2. extern alias functionality?
   3. Uniquely nest all classes… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

8. DumpIf

   Dump if predicate is true

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

9. Expose Program.IsAutomated via Util class

   Currently we resort to reflection on the LinqPad internal classes to extract some very useful properties. One of these features is IsAutomated property of the internal static Program class, which is similar to #if CMD but is more practical because you can pass it around. Besides it's impossible to determine if a script it running under lprun inside MyExtensions using the said #if CMD directive. Because it is a compilation directive.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

10. Ctrl+Backspace should delete a word rather than print the backspace character on the "Additional Namespace Imports" page
    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

11. 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");… more

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

12. Drag-n-drop CSVs into an instant table

    Drag-n-drop a CSV file to the LINQPad window to silently create an IQueryable object populated with its values and insert a code reference at the cursor point where the drop operation completes.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

13. Add XML Documentation Helper

    Add a helper to the editor so that when /// is typed on the line before a property or method, the summary and param blocks are added similar to how it works in Visual Studio per this article:

    https://docs.microsoft.com/en-us/visualstudio/ide/reference/generate-xml-documentation-comments?view=vs-2017

    OR

    Enable intellisense for /// < to template the common options:

    /// <summary
    /// <param
    /// <returns
    /// <see

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

14. Give option to disable encryption of the Connection

    Give a checkbox option to disable encryption of connection string and database password. Or some ways to dynamically change like password from system variables. Because the portable version connections doesn't work by copying x-copying everything to other system in automation.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

15. Bug(?): IQ Driver generates invalid SQL when a column name is a keyword or reserved word

    I don't know if this is an issue with other connection types in the IQ driver, but using MariaDB, if I have a table with a column name like "Character", the generated SQL does not escape this column name, leading to a syntax error.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

16. Add option to rename connection when cloning an existing connection

    When creating a similar connection there is no option to change the name along with the other connection parameters. The new connection is created with the same name.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

17. Fix Bug: Dump(), Console.WriteLine() adding line breaks in long string output

    When outputting a long string, LinqPad outputs line breaks not in the string after each block of 100,000 characters.

    This impacts string.Dump() (with no description), Console.Write(string), and Console.WriteLine(string).

    This is not just a visual issue with the output window. If you copy and paste from the output window into a text editor, the line breaks are present in the data.

    string.Dump("any text") does not exhibit the problem.

    Console.Write and Console.WriteLine when used in a C# console application (Visual Studio compiled) do not exhibit this behavior.

    LinqPad C# Program demonstrating the behavior:

    void Main()

    {
    "".Dump("Console.Write() has breaks at 100K chars (three lines displayed):");
    Console.Write(new string('.', 250000));
    Console.WriteLine();

    "".Dump("Console.WriteLine() has breaks at 100K chars (three lines displayed):");
    Console.WriteLine(new string('.', 250000));
    
    "".Dump("Dump() has breaks at 100K chars (three lines displayed):");
    (new string('.', 250000)).Dump();
    
    "".Dump("Dump(\"\") has breaks at 100K chars (three lines displayed):");
    (new string('.', 250000)).Dump("");
    
    (new string('.', 250000)).Dump("No breaks with Dump(\"something\") (one line displayed)");
    

    }

    Tested on:

    Windows 10 Pro
    LinqPad 5 Premium v5.36.03(AnyCPU)

    When outputting a long string, LinqPad outputs line breaks not in the string after each block of 100,000 characters.

    This impacts string.Dump() (with no description), Console.Write(string), and Console.WriteLine(string).

    This is not just a visual issue with the output window. If you copy and paste from the output window into a text editor, the line breaks are present in the data.

    string.Dump("any text") does not exhibit the problem.

    Console.Write and Console.WriteLine when used in a C# console application (Visual Studio compiled) do not exhibit this behavior.

    LinqPad C# Program demonstrating the behavior:

    void Main()

    {
    "".Dump("Console.Write() has breaks at 100K chars… more

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

18. Hide things correctly.

    If a Dump(caption) method was called on an object, and later that object was hidden, the green Dump envelope with the caption stays visible.
    Also, DumpContainer cannot be easily hidden, I had to use Style="display:none".

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

19. BUG: Virtual nav prop in child entity (TPT) is eager loaded and causes MARS error

    I'm writing some sample code for a class using AdventureWorks 2012. I created POCO's for the Person.BusinessEntity and Person.Person tables setup for TPT inheritance. The Person entity has a nav prop for phone numbers to the PersonPhone entity. When I run this in a C# program, it works perfectly. I've verified with DbContext.Entry(...).Collection(...).IsLoaded that the nav prop is not being eager loaded. When I access it in a LINQPad query (eg from person in Persons) it crashes with a MARS error. I have sample code.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

20. 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… more

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating