Question - Connection settings for context from assembly about linq2db.linqpad HOT 7 CLOSED

There is no built-in support for json-based configuration, only app.config connectionStrings supported out-of-box. Not sure if it will work with .net core

from linq2db.linqpad.

Probably we need to redesign this configuration screen for linqpad6 (or even v5 too)

from linq2db.linqpad.

app.config doesn't work either.

Is it a big job to add functionality to load connection strings settings? I'm happy to have a go if it is likely to be possible?

from linq2db.linqpad.

Issue is that compared to app.config's configuration/connectionStrings being a standard mechanism for connection configuration, there is no standard declarative replacement for .net core, so it is not clear what should be implemented.

I think as quick fix we should add connection string field to configuration dialog. Should be an easy task:

• add ui field
• Add configuration using field value to DataConnection in code

from linq2db.linqpad.

PRobably we should add support for json configuration schema from here https://docs.microsoft.com/en-us/ef/core/miscellaneous/connection-strings#aspnet-core

but this is task for linq2db (still could be done in linqpad as quick fix)

from linq2db.linqpad.

If we add a connection string to the configuration dialog then we will also need to specify the provider somehow and, in my case, the name. It might be easier to actually load a config file to do this if there is a suitable hook from LinqPad.

I'll have play over the next few days.

from linq2db.linqpad.

@RoyChase , I've added support for json, but as you said - now to detect provider, connection string name should be in form, recognized by <DB>Tools.ProviderDetector() method

from linq2db.linqpad.