1187 results found

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

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

3. "Show all nestings levels" works only for the first items!

   "Show all nestings levels" works only for the first items! Not for all. Please fix!

   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. BUG: automatic intellisense occuring on single letters

   When typing something like
   .Where(x => ....)
   pressing space after the x fills in the intellisense menu choice which pops up automatically.

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

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

6. NuGetPackageFolder

   <NuGetPackageFolder>C:\packages</NuGetPackageFolder>
   is not effective when it is placed in (RoamingUserOptions.xml nor UserOptions.xml) the same path as LINQPad.exe

   6 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

7. Bug: IOException on first run with 2 piped lprun's because of building shared Extensions

   Setup:

   a.linq:
   "a".Dump();

   b.linq:
   "b".Dump();

   Delete all *.dll, *.pdb in plugins folder (for example, LINQPad Plugins\Framework 4.6), leave the MyExtensions.FW46.linq file for compilation;

   Then run: lprun a.linq | lprun b.linq

   This is the output:

   c:\users\user\Documents\LINQPad Queries>lprun a.linq | lprun b.linq
   IOException: The process cannot access the file 'C:\Users\User\Documents\LINQPad Plugins\Framework 4.6\MyExtensions.FW46.dll' because it is being used by another process.
   at LINQPad.TaskExtensions.GetResult[T](Task`1 t)
   at LINQPad.MyExtensionsManager.CheckForStaleExtensions()
   at LINQPad.CmdLineAppHost.Run()
   at LINQPad.Cmd.LPCmd.Run(String[] args)

   b

   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

8. Automatic proxy detection not working

   Hello,
   First of all: LINQPad is a GREAT productivity tool and in our company we have many users, using it on a daily base. I love the new feature to great simple chart in the Dump output!

   Here is a little issue. The automatic proxy detection of LINQPad is not working properly. In our environment with a NTLM based authenticating proxy and a proxy.pac file in use it is not working.
   This is most likely due to not setting the HttpWebRequest.Proxy.Credentials property before sending a request.

   Here is a sample C# code where it works and is explained step-by-step:

   // create some HTTP web request, e.g. www.microsoft.com
   // CAREFUL: some special URLs like www.google.com might be accessible without any proxy credentials as EVERYBODY should be able to use them
   // so we use something more special, e.g. "https://www.bundesbank.de"
   var url="https://www.bundesbank.de";
   HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);

   // force the request to be executed without using any cache, for our testing scenario
   // in a productive scenario this SHOULD NOT be changed without having mature reason, e.g. a web site handles caching wrongly and deliever
   // false results if caching is activated
   // CAREFUL: the proxy authentication request is STILL cached. So if you want to test you MUST exit LINQPad after each successful proxy authentication attempt
   HttpRequestCachePolicy noCachePolicy = new HttpRequestCachePolicy(HttpRequestCacheLevel.NoCacheNoStore);
   request.CachePolicy = noCachePolicy;

   // usually .NET uses the system web proxy
   // so the next if line is redundant
   // request.Proxy = WebRequest.GetSystemWebProxy();

   // or define an explicit proxy
   // this shouldn't be necessary except if the proxy handles the request not properly or some exceptional proxy should be used
   // that is configured in a special way
   // request.Proxy = new WebProxy("proxy.somedomain.com:8080", true)

   // !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
   // here is what needs to DONE
   // settings proxy credentials in the code is MANDATORY.
   // if you do not set credentials in the code none will be use and hence an anonymous request is sent
   // This ALWAYS fails if you have an authenticating proxy server

   request.Proxy.Credentials = CredentialCache.DefaultNetworkCredentials;
   // !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

   // alternative: create network credentials based on user name and password
   // this has to be used if e.g. the applications execution environment uses credentials that have no internet access over the proxy server
   // request.Proxy.Credentials = new NetworkCredential("username", "password");

   // if you comment the next line it still works
   // the request.Credentials are credentials used to access the web site. Those are usually not the default network credentials but some credentials
   // for on an Internet authentication protocol, e.g. basic authentication
   // request.Credentials = credential;

   // do the request
   using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
   {
   using (var stream = response.GetResponseStream())
   {
   using (StreamReader reader = new StreamReader(stream))
   {
   reader.ReadToEnd().Dump();
   }
   }
   }

   If would be great if this could be fixed.
   CAREFUL once again. To test restart LINQPad after each attempt. Else you will see cached results.

   Hello,
   First of all: LINQPad is a GREAT productivity tool and in our company we have many users, using it on a daily base. I love the new feature to great simple chart in the Dump output!

   Here is a little issue. The automatic proxy detection of LINQPad is not working properly. In our environment with a NTLM based authenticating proxy and a proxy.pac file in use it is not working.
   This is most likely due to not setting the HttpWebRequest.Proxy.Credentials property before sending a request.

   Here is a sample C# code where it works and is explained step-by-step:

   //… 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

9. Edit and debug Cake files

   Would've been really cool if you could edit and debug Cake build scripts in LINQPad.

   23 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

10. seek White Listing status with Symantec EndPoint Protection

    The latest SEP virus definition update has flagged LINQPad.exe as a virus and Quarantined it.

    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. Include the current query name (if saved) to the title bar

    The time tracking software I use, TimeSprite, uses the window title to track time and assign to tasks. LINQPad always just shows as "LINQPAD" - but when a query is saved, including the file name in the title bar (like Word, Excel, etc. does) will let users identify the current query, and will facilitate time-tracking apps such as TimeSprite to assign queries to projects.

    16 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

12. Foreach loop directly to progress

    void Main()
    {
    // You can also make custom inline progress bars as follows:
    foreach (var element in Enumerable.Range(0, 100).DumpProgressBar("Most common usage of progress"))
    {
    
    Thread.Sleep (30);
    }
    }

    public static class Extension
    {
    public static IEnumerable<T> DumpProgressBar<T>(this IEnumerable<T> valuesList, string title = null)
    {
    int total = valuesList.Count();
    int position = 0;

        var progressBar = new Util.ProgressBar(title).Dump();
        progressBar.HideWhenCompleted = true;
    
        foreach (var element in valuesList)
        {
            progressBar.Percent = (++position * 100) / total;
            yield return element;
        }       
    }
    

    }

    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. sharing scripts, using sharepoint or something similar to teams sharing documents

    sharing scripts, using sharepoint or something similar to teams sharing documents

    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

14. Remove "asterisk" indicator in the file tab when unsaved changes are canceled using "Undo" feature

    LINQPad adds * (asterisk) indicator char to the current tab when saved script is changed (char removed/added, etc). It would be great if this * (asterisk) indicator is removed as soon as changes are undone by multiple CTRL+Z commands. As for now, even if file is restored to the original state, the asterisk is still displayed and it's difficult to tell if the file was really changed or not (safe to resave or not?).

    Please consider implementing this feature, it should be a piece of cake! :)

    Thanks!

    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. Edit and debug CSX files

    I have been playing with scriptcs and csx files. It would be awesome if LinqPad could edit and debug csx files just like linq ones. With Roslyn being the future, seems like it would be an important feature for LinqPad (which is awesome!! by the way)

    62 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. Have a version of LINQPad with a notebook UI ala IPythonNotebook

    I'd really love a version of LINQPad along the lines of IPythonNotebook or Mathematica. Ideally it would be hosted in the cloud. I'd use such a thing from every one of my computers all day every day and would happily pay a monthly subscription for the privilege.

    6 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. Show Color and Image when Dump()

    I like Xamarin Workbook,
    but i prefer Linqpad more, please integrate it with SkiaSharp, when Dump, to have an option to see Colors and Image

    4 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

18. Add Connections using Data Context from a NuGet Package

    It would be great to be able to package up custom DbContext assemblies and app.configs (e.g. dev, uat, prod) in a NuGet package then reference the package from the "Add Connection" dialog.

    7 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

19. Enable non-prerelease package to download pre-release

    The nuget package Microsoft.Azure.CosmosDB.Table package version 1.1.3 relies on the prerelease 9.0.0.1-preview of Microsoft.Azure.Storage.Common.

    If I enable include pre-release it doesn't install failing saying that it can't find it.

    Even if I pre-install the pre-release dependency it doesn't allow it.

    A non-prerelease package being a depedency is a documented issue: https://github.com/Azure/azure-cosmosdb-dotnet/issues/385 and the workaround suggests installing the pre-release which suggesting the workaround should work as normal when using nuget.

    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

20. Press F2 key to rename a saved query in MyQueries

    When in MyQueries - pressing F2 key allows rename

    Linqpad is a really fantastic product - thank you!

    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