Re: About System.Text.Json Dump
wish add Ctrl+D to Duplicate Line
wish add Ctrl+D to Duplicate Line
GitHub Copilot integration?
I will admin I am starting to rely on GitHub Copilot more and more in my day to day use of Visual Studio and Visual Studio Code. I would love some integration with Linqpad if possible. I searched the forms and was surprised to see it not mentioned yet.
Re: Editing Cells in query results. Some cells can edit others not.
It could be because the text exceeds the textbox limit of 10,000 characters. You might like to try the 5.47 beta - it extends the limit to 60,000.
LP7 Upgrade: Could not obtain startup pointer
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:
- Run LINQPad7Setup.exe to install 7.5.14 (x64).
- After finishing the install, allow it to launch LinqPad.
- 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...".
- Exit LinqPad.
- 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.
Mapping PostgreSQL custom enum columns
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?
Deactivate running of selected code
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
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.
Re: Can I use free license in my job?
Yes, you can use the free version of LINQPad for commercial purposes.
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