Best Of

I'm trying to use LinqPad with PostgreSql but I'm not able to specify the schema in the connection string so it is showing the tables in the 'public' schema, this using the driver provided by https://github.com/fknx/linqpad-postgresql-driver.

The driver from Devart I can set the schema but at the moment to perform the query it always states 'LinqCommandExecutionException: Error on opening DbConnection' just working if I click on SQL tab and perform standar sql queries like "Select * from table" instead of running "from t in Table select t", it doesn't work...

Any ideas on how to run queries from PostgreSql in LinqPad? would be appreciated any help.

Fair enough: I'll make this consistent for the next build.

I'm making heavy use of the #load directive to include classes from other linq files. This is great since it allows me to create organized libraries of reusable code within linqpad without throwing them all in my My Extensions file.

But currently, classes defined in a loaded file are treated as black boxes like other external references. We cannot step into the code for those classes but could jump to the definitions. It does seem to be aware of those files looking at the call stack, just can't debug it.

LINQPad doesn't convert from SQL to LINQ. There is a tool called Linqer which does this - let me know if you'd like a refund.

More info here:
https://linqpad.uservoice.com/forums/18302-linqpad-feature-suggestions/suggestions/194040-allow-conversion-of-sql-to-linq-where-possible

Your netcore 3.0 is incorrectly installed: that there's an entry for Microsoft.AspNetCore.App and Microsoft.WindowsDesktop.App, but not for Microsoft.NETCore.App.

Either completely remove netcore 3.0, or re-install its SDK.

Note that I plan to address this in the long term by enhancing LINQPad's .NET Core installer such that it detects and warns about this condition.

How and why are you adding Framework 4 references?
You shouldn't need any additional references, and just one namespace System.Net

See http://share.linqpad.net/tgfuie.linq

I had the same issue -- click the yellow exclamation point just to the left of the green "Execute" button:

https://forum.linqpad.net/discussion/2001/missingmethodexception-when-trying-to-print-a-string-in-f#latest

Right now, I would have to hire a team and budget as much as $500k for a good Linux/macOS/Windows solution. LINQPad is designed to look simple, but there's a lot going on underneath, and a big codebase to make it happen. Features such as "Results to Data Grids" look simple, but that alone took months of prototyping and refining - and considerable messing with Win32 API calls (its architecture also allows for other presentations, such as charting and custom visualizers). The integrated debugger is another hurdle - I seem to remember it was a big deal for JetBrains to make debugging work on Linux. The current LINQPad debugger (which I wrote in 2014) was 8 months' work, to give you an idea. Then there is the browser integration for the results window, which is non-trivial because of LINQPad's support for IObservable/IAsyncEnumerable/Tasks, dump containers, and interactive HTML controls. And integration with the custom editor, to which I've added numerous tweaks and extensions (such as vim emulation mode). All that would need to be completely rewritten (and we've not even got to the main UI yet). And then every subsequent new feature would need to be tested on Windows, macOS, and a variety of Linux flavors.

I'm not saying that it will never be done, but with the libraries and tools available right now, it doesn't seem viable, especially given that the entire investment could be wasted if a better x-platform model came along in the future.

I've just uploaded a new beta:
https://www.linqpad.net/LINQPad6.aspx#beta

This includes special support for the Office Interop COM libraries. Just press F4 and click Add Office Interop. This will add the references and namespaces to make Office interop work.

Let me know how you get along.

Thanks for reporting - there's now a beta that runs on netcore 3.1 RTM:
https://www.linqpad.net/LINQPad6.aspx#beta

I'll get this rolled out to production very soon if there are no issues.