Database specific extensions or base-queries
I have long considered the usefulness of this feature, and looked a few times, but either Linqpad doesn't support it, or I am not searching for the right things (totally possible).
Basically - what I'd love to do, is have a set of extension methods that can access connection specific context/members/etc that are available any time I'm querying a specific connection automatically.
I've thought of two ways that I thought this might have been implemented, but don't see any rigging for it - so wondering if it's done some other way, or it's not there:
1 - I considered one way might be that linqpad would have some type of implicit/explicit compiler symbol being set when you connect to a db, denoting the connections server/name or identifier in some form). This would then allow me to enter a block in my extensions wrapped with that symbol/directive, and it would be automatically included when I connect to that database. Not seeing anything that indicates this happens - or that I could set something like this.
2 - An alternative that would probably be cleaner, is a way to potentially set an "autoload/base" linq query on a database connection, so that any time you are executing a script against that connection, LP has treated it like a @load in the query, and loaded those functions/members to be available.
Granted neither of these are blockers for usage by any means, but I was thinking it'd be a nice ux improvement for certain use cases.
If anyone has any ideas/pointers for how this can be done I'd love to hear it! Else, I actually entered an item on user voice just in case it isn't there.