1182 results found

1. make SQL output so I can run it in SSMS

   in the SQL output window instead - the parameters emitted as coments are not executable.
   Putting them on separate lines with a declare in-front and the appropriate type in-front would be very useful

   e.g. instead of

   -- Region Parameters
   -- @year_0='2024' (DbType = Int16), @period_1='5' (DbType = Int16)
   -- EndRegion

   output:

   -- Region Parameters
   -- declare @year_0 int ='2024' -- (DbType = Int16)
   -- declare @period_1 int ='5' -- (DbType = Int16)
   -- EndRegion

   3 votes

   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

2. Support GeneratedRegex

   Hi Joseph. You may already do this, but can LinqPad support .Net Regular Expression Source Generators?

   https://learn.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-source-generators

   I'm interested in the Regex side of things, ge.g

   [GeneratedRegex("abc|def", RegexOptions.IgnoreCase, "en-US")]
   private static partial Regex AbcOrDefGeneratedRegex();
   
   private static void EvaluateText(string text)
   {
       if (AbcOrDefGeneratedRegex().IsMatch(text))
       {
           // Take action with matching text
       }
   }
   

   3 votes

   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

3. Close AI Assistant Settings Window Also Closes Preferences

   When I close the AI Assistant Settings window, I except to be returned to the main Preferences window. Instead, both are closed. Is this a bug?

   3 votes

   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

4. OnInit functionality for F#

   The void OnInit() hook, used for for example starting Avalonia before running and dumping UI elements, does not work for F# (Or, rather, I struggle to figure out how).

   The twitter discussion on Avalonia and F# with some creenshots are here https://twitter.com/bjartnes/status/1717422836250271800

   It would be nice with a feature similar to the OnInit hooks but for F#.

   3 votes

   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

5. Excel File Integration with Intelligent Structure Recognition

   I frequently utilize Linqpad for processing Excel files by reading data through the FileInto method. My workflow typically involves manipulating this data and subsequently storing it in a database. To streamline this process, I propose an enhancement to the user experience with the following capabilities:

   Keyboard Shortcut for File Selection: Implement a shortcut key that prompts the user to select an Excel file. This would enable quick and direct access to data files without navigating through menus.

   Automatic Structure Discovery: Upon file selection, Linqpad could automatically analyze and ascertain the basic structure of the Excel file. This functionality should include:

   Detection of columns and rows
   Identification of data types within cells
   Recognition of table names and ranges
   Intellisense Integration: Leverage the discovered structure to enrich the Intellisense feature. This would allow users to:

   Autocomplete column and row references
   Preview data types and values on hover
   Navigate through tables and ranges efficiently
   By incorporating these features, users would benefit from a more intuitive and efficient way to interact with Excel files within Linqpad, greatly enhancing productivity for database-related tasks.

   Sample code
   FileInfo fi = new FileInfo(@"D:\DataFiles\data.xlsx");
   using (ExcelPackage excelPackage = new ExcelPackage(fi))
   {
   ExcelWorksheet data = excelPackage.Workbook.Worksheets[0];
   var start = data.Dimension.Start;
   var end = data.Dimension.End;
   for (int row = start.Row + 1; row <= end.Row; row++)
   {
   var column1 = data.Cells[row, 1].Text.Trim();
   // do something
   }

   I frequently utilize Linqpad for processing Excel files by reading data through the FileInto method. My workflow typically involves manipulating this data and subsequently storing it in a database. To streamline this process, I propose an enhancement to the user experience with the following capabilities:

   Keyboard Shortcut for File Selection: Implement a shortcut key that prompts the user to select an Excel file. This would enable quick and direct access to data files without navigating through menus.

   Automatic Structure Discovery: Upon file selection, Linqpad could automatically analyze and ascertain the basic structure of the Excel file. This functionality should include:

   … more

   3 votes

   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

6. Excel File Integration with Intelligent Structure Recognition

   I frequently utilize Linqpad for processing Excel files by reading data through the FileInto method. My workflow typically involves manipulating this data and subsequently storing it in a database. To streamline this process, I propose an enhancement to the user experience with the following capabilities:

   1. Keyboard Shortcut for File Selection: Implement a shortcut key that prompts the user to select an Excel file. This would enable quick and direct access to data files without navigating through menus.

   2. Automatic Structure Discovery: Upon file selection, Linqpad could automatically analyze and ascertain the basic structure of the Excel file. This functionality should include:

   Detection of columns and rows
   Identification of data types within cells (if possible)
   Intellisense Integration: Leverage the discovered structure to enrich the Intellisense feature. This would allow users to:

   Autocomplete column and row references
   Preview data types and values on hover
   Navigate through tables and ranges efficiently
   By incorporating these features, users would benefit from a more intuitive and efficient way to interact with Excel files within Linqpad, greatly enhancing productivity for database-related tasks.

   I frequently utilize Linqpad for processing Excel files by reading data through the FileInto method. My workflow typically involves manipulating this data and subsequently storing it in a database. To streamline this process, I propose an enhancement to the user experience with the following capabilities:

   1. Keyboard Shortcut for File Selection: Implement a shortcut key that prompts the user to select an Excel file. This would enable quick and direct access to data files without navigating through menus.

   2. Automatic Structure Discovery: Upon file selection, Linqpad could automatically analyze and ascertain the basic structure of the Excel file. This functionality should include:

   … more

   3 votes

   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

7. Gather and visualize DOTNET_Jit* dumps.

   Allow user to switch on gathering of JIT dumps (DOTNET_JitDump and rest) and visualize and/or save them.
   Provide UI (or at least suggestions/help) for building filter patterns.

   3 votes

   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

8. Add ability to undo accidental language switch.

   During rapid prototyping, I have been using CTRL+- to navigate to previous location in my C# code. However, once in awhile I accidentally hit CTRL+0 instead, which seems to switch to F# program. This results in destructively modifying the entire source file, which cannot be undone. Even if you manually switch back to C# program, the code is still broken. At this point the only choice is to restore the file from backup or hand-edit back to corrected for the language switch.

   It really should be possible to simply hit 'Undo' and it should restore the file as it was prior to the accidental language switch.

   During rapid prototyping, I have been using CTRL+- to navigate to previous location in my C# code. However, once in awhile I accidentally hit CTRL+0 instead, which seems to switch to F# program. This results in destructively modifying the entire source file, which cannot be undone. Even if you manually switch back to C# program, the code is still broken. At this point the only choice is to restore the file from backup or hand-edit back to corrected for the language switch.

   It really should be possible to simply hit 'Undo' and it should restore the file as it was… more

   3 votes

   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

9. Displaying custom EF property <summary> doc in the results view then hovering over title bar.

   LinqPad is great! I use it nearly every day.

   One single thing I'm missing is displaying my custom EF property <summary> docs in the results view then hovering over title bar.

   3 votes

   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

10. Add "Folder mapping"

    When working from multiple locations, the folder structure often does not match. Currently, when libraries are referenced from the file system, the location is an absolute path. There could be multiple approaches to addressing this. The most user-friendly would be to have a set of "roots" on the machine and project level (a dictionary of names to paths). Query level would override the machine level. These could be also read from within the query using a utility method also, and editable from the UI. When a library is opened from such a mapped path, it would be stored relative to the mapping name. Adding a mapping later on, or opening a query with absolute library paths could also result in reevaluating these and suggesting to the user to use the maps instead. If a map name is not set on a machine where the query is opened, or the path associated with it in the query file does not exist, the app could ask the user to select it. Hence, the queries would become easily portable between machines.

    When working from multiple locations, the folder structure often does not match. Currently, when libraries are referenced from the file system, the location is an absolute path. There could be multiple approaches to addressing this. The most user-friendly would be to have a set of "roots" on the machine and project level (a dictionary of names to paths). Query level would override the machine level. These could be also read from within the query using a utility method also, and editable from the UI. When a library is opened from such a mapped path, it would be stored relative to… more

    3 votes

    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

11. Add quote autocompletion to other autocompletion functions

    When I'm writing code and need to define a string, I find it quite discomforting that I have to type two quotes. This is because many current IDEs and editors automatically complete double and single quotes. When I define a string, I only need to type one quote and the other is automatically filled in.
    The summary of functions is as follows.：
    1. Automatically complete double and single quotation marks. When you input a quotation mark, it will automatically add the matching one after the cursor position. Pressing the tab key inside the quotation marks allows you to exit them. This feature can also be disabled.
    2. Automatically add the matching right parenthesis when you input a left parenthesis, similar to the auto-completion feature for quotes.

    When I'm writing code and need to define a string, I find it quite discomforting that I have to type two quotes. This is because many current IDEs and editors automatically complete double and single quotes. When I define a string, I only need to type one quote and the other is automatically filled in.
    The summary of functions is as follows.：
    1. Automatically complete double and single quotation marks. When you input a quotation mark, it will automatically add the matching one after the cursor position. Pressing the tab key inside the quotation marks allows you to exit them.… more

    3 votes

    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

12. Add support for the automatic code formatter `csharpier`

    I have gotten used to my code editors having automatic code formatting via prettier and csharpier in VSCode, Visual Studio, and Rider. When I use linqpad, I find myself spending a bunch of time formatting code to make it easier to read. I would love to be able to enable csharpier to run on save in linqpad.

    They have a public API which is documented here: https://csharpier.com/docs/API

    Thanks for making my favorite tool LINQPad! 🧡

    3 votes

    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

13. Adding support for "Referencing other .linq files" in Linqpad 5

    It would be great to add "#load" functionality to LINQPad 5 , which is currently only available in LINQPad 6 and later versions.

    3 votes

    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

14. Flag read-only properties in output

    I really would like to see for each property whether it's a readonly or a writable property. Maybe you could give the gray background of the headings some red touch for RO ones?

    2 votes

    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  ·  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

15. Boo support would be nice

    Like Python and Ruby, this feature could be integrated with no pain. There is an hosting interface for boo. It's all about syntax coloring and intellisense.

    2 votes

    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

16. b able 2 specify references assemblies & namespaces in linqpad.config

    I use linqpad to execute scripts on servers on the cloud. I copy linqpad.exe plus a few useful .net assemblies onto each server via script.

    I dont want to have to manually add in the references each time I load linqpad onto a server. It would be much more useful ( and mistake proof) if I can simply do a deploy to my server which included a linqpad.config with the references to my utility assemblies as well as extra namespaces. Please comment if this is not clear and I'll elaborate further.

    2 votes

    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

17. Tab Icons

    It would be nice if the tabs had icons showing if they were SQL or code files. If you have mixed tabs of both, it would be much faster to find the query you're looking for.

    2 votes

    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

18. Command-line LINQPad

    like interactive shell, or csharp(1) on Mono, would be nice I think!

    2 votes

    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  ·  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

19. Autocompletion is Incomplete

    Make it clearer that autocompletion does not work with VB, before one commits to a purchase.

    2 votes

    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  ·  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

20. Non-blocking UI

    Don't block the UI thread when doing some expensive work. I'm using LINQPad at work and at home (ironically I paid for my home license but am using the unregistered version one at work) and at work I connect to large databases with thousands of tables and LINQPad takes a long time to "deal" with scripts connecting to these kinds of databases but it would help with a progress bar or at least some notion of "I'm busy" rather than the ghost whitening of the UI.

    Otherwise thanks for a superb product. :-)

    2 votes

    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