1194 results found

1. Add a filter feature for stored procedures and tables etc.

   Allow the user to be able to select filter parameters when trying to search for or find tables or stored procedures in the connection panel.

   0 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. 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

3. 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

4. Show elapsed time per executed line

   While running through a script I can already see the yellow arrow jump from line to line at execution. It would be awesome to see how much time elapsed for each line after a run.

   If this has too much of a performance impact it could be made toggleable. A similar feature that's already present in Visual Studio: Show the elapsed time between two breakpoints being hit.

   Currently the only way to get this information (as far as I'm aware) is to add Stopwatches all over the code (C# Statements).

   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

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

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

8. Add option to close results rather than just hide results tab

   Despite using LinqPad nearly every day, I can never seem to remember that the X at the top right of results tab means hide and does NOT mean "close results and free up memory". And yes I know the tooltip says 'Hide Results' and not 'Close Results' , but this never seems to stick in my memory.

   Can't think of a single time when I have used the Ctrl-R Show Results option.

   Would be possible, either to have another button to close, or an option to configure what the X button does?

   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

9. 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

10. Show more file types in the My Queries tab

    By default, LINQPad seems can only shown *.linq, *.json, *.csv and *.txt files in a folder. I'd like to show more file types especially some other text file types such as *.md.

    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

11. 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

12. Allow users to add UI scripts as menu options

    It would allow users to include interactive scripts in a dropdown menu, similar to the interactive regex utility. Clicking on a script would run it in the background, and the result area would automatically maximize, displaying interactive controls.

    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

13. 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

14. Add support for HierarchyId

    Please add support for HierarchyId, I was expecting this to be available in LINQpad 8, as it was included in the latest version of EF Core.

    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

15. linqpad8 open in excel file name append random

    linqpad8 open in excel file name append random

    0 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

16. Add an option to disable auto-recovery

    Sometimes scripts can contain information that you do not want to be saved to disk. You write the script with a placeholder for that information and then when you come to use it later you overwrite the placeholder, run the script and close it without saving... except it turns out that LINQPad 7's auto-recovery is saving copies of the sensitive information to disk every 10 seconds. If you're running from an SSD then its wear-levelling mechanism makes it tricky to remove that information from the SSD, simply overwriting and then deleting the file is not enough.

    I know that LINQPad offers mechanisms for storing passwords but they can be overkill and you are relying on DPAPI securing those passwords properly. I also know that the sensitive information is in RAM - I can live with that. I just don't want it on disk.

    It's not the most important thing in the world, LINQPad 5 does not write auto-recovery files so it can be used for these kinds of scripts, but it would be nice if LINQPad 7 could be used as well at some point in the future. Perhaps a boolean in the advanced settings that controls whether auto-recovery is enabled or not?

    Sometimes scripts can contain information that you do not want to be saved to disk. You write the script with a placeholder for that information and then when you come to use it later you overwrite the placeholder, run the script and close it without saving... except it turns out that LINQPad 7's auto-recovery is saving copies of the sensitive information to disk every 10 seconds. If you're running from an SSD then its wear-levelling mechanism makes it tricky to remove that information from the SSD, simply overwriting and then deleting the file is not enough.

    I know that LINQPad… 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

17. Use a Newer File Type When Exporting to Excel

    Currently, LINQPad v5 and v7 both use the "Web Pages and Excel 2003 XML Spreadsheets" file type (format) when exporting data to Excel from the LINQPad Results pane. Under non-regulated conditions, it is possible to open Excel's Trust Center and authorize the "Web Pages and Excel 2003 XML Spreadsheets" file type (Trust Center -> File Block Settings). However... many companies must abide by security posturing in today's environment. As such, security policy auditors such as Tenable have identified that this file type format should be BLOCKED from opening in Excel (https://www.tenable.com/audits/items/CIS_Microsoft_Office_Excel_2016_v1.0.1.audit:29268ad4a1c7bb369b13db79d95af0ef). Unfortunately (or fortunately, however you look at it), many corporations are REQUIRED to implement standard policies such as this.

    Needless to say, we are such a corporation and Excel is blocked from opening this file type. Because of this, when exporting to Excel from LINQPad, you may or may not get an Excel error/info box pop up telling you that the file type is blocked and how to manually edit Trust Center to allow. Often, the box does not appear and you are left wondering why LINQPad is "hung" and the only work around (if you can't click "OK" to clear the Excel info box) is to manually kill LINQPad using Task Manager (or, if you understand the issue, you can hunt for the process from Excel in Task Manager, kill it, and LINQPad will resume and in doing so, LINQPad pops up its own error reporting "crash" box identifying that a System.Reflection.TargetInvocationException has been thrown).

    Would sure love to provide amplifying screenshots, but can't do that here in this "post your idea" feature.

    Regardless... cybersecurity threat vectors are constantly evolving and for security reasons, as holes or implications are found, they must be closed. If LINQPad continues to use communication vectors (i.e. with Excel) that are no longer viable from a security standpoint, we'll suffer loss of LINQPad functionality.

    Respectfully request that LINQPad use a more modern file type (format) when exporting to Excel. Thank you.

    Currently, LINQPad v5 and v7 both use the "Web Pages and Excel 2003 XML Spreadsheets" file type (format) when exporting data to Excel from the LINQPad Results pane. Under non-regulated conditions, it is possible to open Excel's Trust Center and authorize the "Web Pages and Excel 2003 XML Spreadsheets" file type (Trust Center -> File Block Settings). However... many companies must abide by security posturing in today's environment. As such, security policy auditors such as Tenable have identified that this file type format should be BLOCKED from opening in Excel (https://www.tenable.com/audits/items/CIS_Microsoft_Office_Excel_2016_v1.0.1.audit:29268ad4a1c7bb369b13db79d95af0ef). Unfortunately (or fortunately, however you look at… 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

18. 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

19. 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

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