Best Of

LINQPad occasionally hangs when switching between it and Chrome (Webview problem?)

Haven't found a pattern to this but it has been happening a lot of times lately. The query results page (and all of LINQPad really) becomes completely unresponsive when switching between apps (usually Chrome). Not even trying to close linqpad through the close button doesn't work. I found that it becomes responsive again if I minimize then restore LINQPad usually.

It seems like the UI thread hung on something when I switched out then whatever it was doing completed when I minimized.

JeffMercado

1 ·

Re: Can I use free license in my job?

Yes, you can use the free version of LINQPad for commercial purposes.

JoeAlbahari

1 ·

Pin code or other security for production connections

I am a careful person who does not like to have connections to production environments beyond the exact time scope I need them.
But it also sucks to constantly set up and delete connections.

Currently I have set up a read only user on sql server which partially solves this but for any third party managing to access my computer it still means they can read and query data.
But at least it solves me writing to a production database by accident.

However, if we could have a connection that required authentication something like pin, fingerprint or similar and that times out somewhat quickly would solve both my annoyance at setting up and then removing a connection every time I want to write to the db manually and also that it does not need to leave connections open long term even in read only mode, mitigating the risk somewhat if someone accesses my computer.

I can imagine many solutions, such as "unlocked until screensaver" or timeout or similar

RickardL

1 ·

Re: Custom config file with separate configs sections

There is A LOT of other configuration: I'm pointing to the web.config of my application.
The LINQPadQuery.dll.custom.config is identical to the web.config itself and yes, there are binding redirects, but in the temp folder there are just: LINQPadQuery.cs LINQPadQuery.dll, LINQPadQuery.dll.custom.config and LINQPadQuery.pdb.
And as the config is pointing to different external source:

<appSettings configSource="configs\AppSettings.config" />
<cacheSettings configSource="configs\CacheSettings.config" />
<connectionStrings configSource="configs\ConnectionStrings.config" />
<ServiceBusQueueProvider configSource="configs\Messaging.config" />
<imageServerSettings configSource="configs\ImageServer.config" />
<StoreManagerConfiguration configSource="configs\StoreManagerConfiguration.config" />

and no one of them is there, is giving me error...
If needed I can send you all the web.config.
Also I want to point that all this thing stopped to work just with the 5.22.02, before it was pretty ok.

Thanks for take a look into this!

Tanathos

2 ·

Custom config file with separate configs sections

Hi, I'm using the version 5.22.2, and I'm referencing a config file with several external configSource (in a subfolder, like "Configs\AppSettings.config") through the option "Custom path".

This was working pretty well until some days ago, but now the query is not able to access the other configSources, and if I check on AppDomain.CurrentDomain.SetupInformation.ConfigurationFile I see this path:
C:\Users\[MY USER]\AppData\Local\Temp\LINQPad5\_dlwmmfdx\faaqrc\LINQPadQuery.dll.custom.config

and not the real path I setted in "Custom path".

Clearly inside the LINQPadQuery.dll.custom.config there are the references to the other configs files but as the references are relative it's not able to find them (the Config folder is not copied in the Temp folder).

Sounds like a bug to me...

Tanathos

2 ·

Status of Language preview feature Null-checking parameters !!

Not sure if this is a bug or just because it is a preview feature but the following throws a System.NullReferenceException when compiling

void Main()
{
    System.Environment.Version.Dump();
    Test(null); 
}

private void Test(string x!!)
{
    x.Dump(); 
}

'Enable C#/F# Preview Features' in preferences is checked.

sgmoore

1 ·

Re: VirusTotal has 5 hits

Have they downloaded the wrong program?

As far as I know Linqer has nothing to do with LinqPad, so you are unlikely to get an authoritative answer here and it might be better to ask at https://sqltolinq.com/forum

sgmoore

2 ·

Re: LinqPad7 runtime identifier win10-x64 vs win-x64

It looks like the file \runtimes\win10-x64\nativeassets\net6.0-windows10\e_sqlite3.dll in the sqlitepclraw.lib.e_sqlite3\2.0.7 package is corrupt. If you overwrite it with the version from runtimes\win-x64\native, it works. Perhaps they could fix the corrupt file (or just remove it)?

JoeAlbahari

1 ·

Re: LINQPad 7 is now available!

Hi Joe,

Can't i buy LINQPad 5 anymore?
(I'm still going to use .NET Framework for a while!)

kmu

1 ·

Util.Pivot

This probably a dim question, but if I have a table with a LOT of columns, is there anyway, if I've used Util.Pivot to order the subsequent rows (ie the fields from the table) alphabetically?

Love the Pivot option anyway, but there is always something else, right?

StuartHemming

1 ·