Best Of

I upgraded my LinqPad to 7.5.14 (x64) today, but I'm having a lot of issues with it. After some experimenting, I have these reproducable steps:

1. Run LINQPad7Setup.exe to install 7.5.14 (x64).
2. After finishing the install, allow it to launch LinqPad.
3. Run a script that uses a library that references System.Data.SqlClient. This script ran yesterday just fine, but today it does not. It gives the error: "Could not load file or assembly 'System.Data.SqlClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the...".
4. Exit LinqPad.
5. Click the LinqPad icon in the system tray. LinqPad doesn't launch, and instead gives you a dialog that says: "Could not obtain startup pointer (-21470248941).".

In order to run LinqPad again, I have to install it again.

I have a table that has a column of a custom enum type defined as follows:
CREATE TYPE mcat.model_applicability AS ENUM ('Project-specific', 'Local', 'Global', 'Miscellaneous');
and a table with a column of the above custom type:

CREATE TABLE IF NOT EXISTS mcat.model ( id bigint NOT NULL, applicability mcat.model_applicability NOT NULL, project_idp character varying(20) COLLATE pg_catalog."default", first_seen_utc_timestamp timestamp without time zone NOT NULL, model_metadata jsonb, CONSTRAINT model_pkey PRIMARY KEY (id) )

In LinqPad 6.14.10 with EF Core 5.0.7/Npgsql driver, the applicability column is not mapped onto a property in the auto-generated Model class, so it's not visible in the db connection visualization tree and not accessible programmatically via the ORM. Is there any way to expose columns of custom enum types when using EF with Npgsql in LinqPad?

Is there a possibility to deactivate the running of the selected code. LinqPad should just run all the code everytime (imho)

It really annoys me to have to deselect after commenting out some code

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.

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

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

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.

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