1182 results found

1. Preview SQL table content

   I often find myself using LINQPad to look at the latest data inserted into database tables. I keep a lot of tabs open with something like
   myTable.OrderByDescending(t => t.TableId).Take(10)

   I also spend a lot of time flipping through a bunch of tables to find the data I'm interested in.

   I think both use cases could be helped if LINQPad could open a temporary tab with the top 10 or 25 rows when clicking/navigating with the keyboard in the tables list in the left pane in LINQPad.
   Preferably the results should be sorted descending by the primary key (at least for identity columns).

   I'm looking for the experience in Visual Studio where you get a file preview when navigating among files in the solution explorer. You get a tab opened, but that tab is reused for the next preview.

   I often find myself using LINQPad to look at the latest data inserted into database tables. I keep a lot of tabs open with something like
   myTable.OrderByDescending(t => t.TableId).Take(10)

   I also spend a lot of time flipping through a bunch of tables to find the data I'm interested in.

   I think both use cases could be helped if LINQPad could open a temporary tab with the top 10 or 25 rows when clicking/navigating with the keyboard in the tables list in the left pane in LINQPad.
   Preferably the results should be sorted descending by the primary key (at least for… 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

2. Ability to sort files in "My Queries" tab

   Just a minor suggestion. I'll like to be able to sort files in the "My Queries" tab - by date modified, by date created, by name etc. I experience a little frustration having to remember the name of the last file I worked on.

   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. Automatically Select "SQL Azure" if connection string in clipboard's "Server" property ends with ".database.windows.net,1443"

   Given a SQL Connection String is in the clipboard:

   Server=tcp:my-sql-azure-sql-server-name.database.windows.net,1433;Database=my-initial-catalog;User ID=user@my-sql-azure-sql-server-name;Password=ALRh2AxHV6f8;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

   When the "Server" property of the connection string or equivalent ends with ".database.windows.net,1433" then the assumption that this database server is a SQL Azure connection string and automatically select the "SQL Azure" radio button at the top of the "LINQPad Connection" dialog box.

   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. Persist size and position of undocked results window

   When you click 'undock results to second monitor' the resulting window's size and position should be stored on close so that it opens in the same position next time (rather than being maximised, which is never what I want).

   Part of the problem is that the child window doesn't respond to WindowsKey + arrow to snap to one half or another even though dragging the titlebar does work (to the left hand side).

   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. Support foreign key columns ending with "Fk" instead of "ID"

   Currently entity navigation is optimized for table columns ending with the suffix "ID", for example a CustomerID will get a navigable "Customer" field created.

   In a database where the pattern is like CustomerFk, the navigable field would be named CustomerFkEntity, which is painful to write each time in queries.

   Please allow a more permissive foreign key naming detection or allow it to be configurable.

   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

6. tab focus

   After closing a tab the next tab to get focus should be in order of most recently used.

   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

7. AutoComplete object type filtering (Similar to ReSharper)

   Like many others, I've grown to love certain features of ReSharper. One such feature is the ability to filter the AutoCompletion list by object type using keyboard shortcuts or by clicking on the icon of the object type (such as namespace, class, interface, property, field, etc.). I think that this would be a really nice addition to 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

8. Save Query Custom Settings

   I would like the ability to save "settings" in the query. For example, if ask to select a file, I would like to save the file that was selected for the next time I run the query. This would be perfect if I could save the data inside the query file XML section.

   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. BUG: LINQPad's lprun.exe -format:html outputs invalid html

   I have a script that I run that generates some html I need to display, however, the output is not valid (missing body and html minimally).

   I changed my script that I run to look like this:

   void Main( string[] args )
   {
       "Hi".Dump();
       return;
   
       ... original code and Dump() and RawHtml calls...
   }
   

   And this is the output I get is the following:

   <!DOCTYPE HTML>
   <html>
     <head>
       <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
       <meta http-equiv="X-UA-Compatible" content="IE=edge" />
       <meta name="Generator" content="LINQ to XML, baby!" />
       <style type='text/css'>
   body {
       margin: 0.3em 0.3em 0.4em 0.4em;
       font-family: Verdana;
       font-size: 80%;
       background: white;
   }
   
   p, pre {
       margin:0;
       padding:0;
       font-family: Verdana;
   }
   
   table {
       border-collapse: collapse;
       border: 2px solid #17b;
       margin: 0.3em 0.2em;
   }
   
   table.limit {
       border-collapse: collapse;
       border-bottom: 2px solid #c31;
   }
   
   td, th {
       vertical-align: top;
       border: 1px solid #aaa;
       padding: 0.1em 0.2em;
       margin: 0;
   }
   
   th {
       text-align: left;
       background-color: #ddd;
       border: 1px solid #777;
       font-family: tahoma;
       font-size:90%;
       font-weight: bold;
   }
   
   th.member {
       padding: 0.1em 0.2em 0.1em 0.2em;
   }
   
   td.typeheader {
       font-family: tahoma;
       font-size: 100%;
       font-weight: bold;
       background-color: #17b;
       color: white;
       padding: 0 0.2em 0.15em 0.1em;
   }
   
   td.n { text-align: right }
   
   a:link.typeheader, a:visited.typeheader, a:link.extenser, a:visited.extenser {
       font-family: tahoma;
       font-size: 90%;
       font-weight: bold;
       text-decoration: none;
       background-color: #17b;
       color: white;
       float:left;
   }
   
   a:link.extenser, a:visited.extenser {
       float:right; 
       padding-left:2pt;
       margin-left:4pt
   }
   
   span.typeglyph, span.typeglyphx {
       padding: 0 0.2em 0 0;
       margin: 0;
   }
   
   span.extenser, span.extenserx { 
       margin-top:1.2pt;
   }
   
   span.typeglyph, span.extenser {
       font-family: webdings;
   }
   
   span.typeglyphx, span.extenserx {
       font-family: arial;
       font-weight: bold;
       margin: 2px;
   }
   
   table.group {
       border: none;
       margin: 0;
   }
   
   td.group {
       border: none;
       padding: 0 0.1em;
   }
   
   div.spacer { margin: 0.6em 0; }
   
   table.headingpresenter {
       border: none;
       border-left: 3px dotted #1a5;
       margin: 1em 0em 1.2em 0.15em;
   }
   
   th.headingpresenter {
       font-family: Arial;
       border: none;
       padding: 0 0 0.2em 0.5em;
       background-color: white;
       color: green;
       font-size: 110%;        
   }
   
   td.headingpresenter {
       border: none;
       padding: 0 0 0 0.6em;
   }
   
   td.summary { 
       background-color: #def;
       color: #024;
       font-family: Tahoma;
       padding: 0 0.1em 0.1em 0.1em;
   }
   
   td.columntotal {
       font-family: Tahoma;
       background-color: #eee;
       font-weight: bold;
       color: #17b;
       font-size:90%;
       text-align:right;
   }
   
   span.graphbar {
       background: #17b;
       color: #17b;
       margin-left: -2px;
       margin-right: -2px;
   }
   
   a:link.graphcolumn, a:visited.graphcolumn {
       color: #17b;
       text-decoration: none;
       font-weight: bold;
       font-family: Arial;
       font-size: 110%;
       letter-spacing: -0.2em; 
       margin-left: 0.3em;
       margin-right: 0.1em;
   }
   
   a:link.collection, a:visited.collection { color: green }
   
   a:link.reference, a:visited.reference { color:blue }
   
   i { color: green; }
   
   em { color: red; }
   
   span.highlight { background: #ff8; }
   
   code { font-family: Consolas }
   
   code.xml b { color:blue; font-weight:normal }
   code.xml i { color:maroon; font-weight:normal; font-style:normal }
   code.xml em { color:red; font-weight:normal; font-style:normal }
       </style>
   
     </head>
   <body>Hi<br />
   

   I have a script that I run that generates some html I need to display, however, the output is not valid (missing body and html minimally).

   I changed my script that I run to look like this:

   void Main( string[] args )
   {
       "Hi".Dump();
       return;
   
       ... original code and Dump() and RawHtml calls...
   }
   

   And this is the output I get is the following:

   <!DOCTYPE HTML>
   <html>
     <head>
       <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
       <meta http-equiv="X-UA-Compatible" content="IE=edge" />
       <meta name="Generator" content="LINQ to XML, baby!" />
       <style type='text/css'>
   body {
       margin: 0.3em 0.3em 0.4em 0.4em;
       font-family: Verdana;
       font-size: 80%;
       background: white;
   }
   
   p,

   … 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  ·  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. To support big data , such as Apache Spark

    Big data is hot and is becoming popular. The most popular platform is Apache Spark.

    There is an ODBC driver of Apache Spark at http://www.simba.com/drivers/spark-jdbc-odbc/.

    Another option is that Microsoft has a library to access Apache Spark at https://github.com/Microsoft/SparkCLR .

    Maybe it is not difficulty to support.

    If so, LINQPad can have "big" effect and have more market.

    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

11. Analyze SQL to allow option to open sql in editor of my choice

    Currently there are two options I can select

    1) Open as SQL Query in new tab
    2) Open in SQL Management Studio

    It would be nice to have it open in editor of my choice, eg Open in Toad or Open using PL/SQL developer, as these would give me option to further analyze the query.

    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 option of NOT navigating to empty datagrid when collection contains 0 items - just show placeholder immediately.

    I love linqpad and find it more useful than SSMS for many operations. One feature that I would find AWESOME, would be to provide an option to NOT navigate to an empty results grid when there are no entries in the grid.

    Kind of like when you click on a Collection in an object Dump datagrid and the collection is Null, it just says null immediately. I would love it if when I clicked a navigation collection from a linq-to-sql (or any datagrid query), and there are no items in the target collection, it would just show 0 items (which is now shown if you go BACK to the original grid). Clicking that again would then navigate like usual, so that you could use that to insert data in a linq-to-sql query.

    Use case: I'm half blind (or more), and routinely am checking child collections of grid of results. I hate when I click on the child collection property for a row, and then end up in an empty grid, and then have to find the tab to go to the grid I just had opened to try again with another property. If I have several dump grids open, this can become a chore.

    I love linqpad and find it more useful than SSMS for many operations. One feature that I would find AWESOME, would be to provide an option to NOT navigate to an empty results grid when there are no entries in the grid.

    Kind of like when you click on a Collection in an object Dump datagrid and the collection is Null, it just says null immediately. I would love it if when I clicked a navigation collection from a linq-to-sql (or any datagrid query), and there are no items in the target collection, it would just show 0 items (which… 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

13. Ability to compile using Roslyn Nuget packages

    For example, this one
    https://www.nuget.org/packages/Microsoft.Net.Compilers/2.0.0-beta1

    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 grid editing for 3rd party drivers

    By this the driver for postgresql could use the grid for editing as well

    https://github.com/fknx/linqpad-postgresql-driver

    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

15. Make Instant Share URL Configurable

    Allow us to configure the endpoint for Instant Share so we can create our own workflows for script sharing. Instant Share to a local folder, SMB share or Web API URL.

    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…)
    4 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

16. Support INotifyPropertyChanged for Dumped objects

    Support INotifyPropertyChanged in the same way as IObservable, i.e. update the value when the property changes

    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  ·  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. Allow Action<T> as input to Dump()

    Sometimes you don't need to Dump() the entire object graph, but instead just a portion thereof. Of course, you can (if in Statements or Program mode) assign a variable, and them Dump() something derived from the variable currently. But wouldn't it be nice, for example if you could do this:

    /* some really complex query / .Dump(x => x.Select(y => y.EmailAddress, "Email Addresses")
    ./ some other operations on the complex query */

    This wouldn't be hard to code:

    public static T Dump<T>(this T toDump, Func<T> filter, string description)
    {
    toDump.filter().Dump(description);
    return toDump;
    }

    Of course, you'd want to have other overloads as well to match the existing Dump() overloads with the additional second parameter.

    Sometimes you don't need to Dump() the entire object graph, but instead just a portion thereof. Of course, you can (if in Statements or Program mode) assign a variable, and them Dump() something derived from the variable currently. But wouldn't it be nice, for example if you could do this:

    /* some really complex query / .Dump(x => x.Select(y => y.EmailAddress, "Email Addresses")
    ./ some other operations on the complex query */

    This wouldn't be hard to code:

    public static T Dump<T>(this T toDump, Func<T> filter, string description)
    {
    toDump.filter().Dump(description);
    return toDump;
    }

    Of course, you'd want to have other… 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…)
    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

18. Keep Original Column Names in Generated types

    When you generate a model for Linq to SQL, provide an option to not autoformat the property names with upper case first letters. Instead preserve the original field name and use that.

    Use case: I have several customers who use LINQ Pad for query prototyping and then copy the results from queries into their programs (I know, I know - not the best of ideas, but that's what they do). The problem is because the names don't match all sorts of fixups have to be done. An option to generate entity properties with the same casing as the underlying fields would help a lot in this case.

    Preferrably this should be an option.

    When you generate a model for Linq to SQL, provide an option to not autoformat the property names with upper case first letters. Instead preserve the original field name and use that.

    Use case: I have several customers who use LINQ Pad for query prototyping and then copy the results from queries into their programs (I know, I know - not the best of ideas, but that's what they do). The problem is because the names don't match all sorts of fixups have to be done. An option to generate entity properties with the same casing as the underlying fields… 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  ·  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. Add an overload to Util.Run and Util.Compile/CompileAsync that accepts a QueryLanguage

    At the moment it's possible to change the query lang via lprun using the -lang flag. It'd be awesome to be able to do the same when using Util.Run and Util.Compile/CompileAsync from other assemblies.

    It'd also be super useful to be able to pass a Stream to the same methods, but that's secondary :).

    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. Ability to have a multiple WCF calls and/or multiple DB connections

    Ability to have a multiple WCF calls and/or multiple DB connections in same opened query.

    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