Embedding/Attaching/Linking LINQPad inside another application like VBA for desktop app automation?
Is it possible to embed LINQPad as a scripting solution similar to VBA inside Excel?
In other words load LINQPad (In-Process) in such a way that LINQPad code can script another application via its API. I tested several solutions but each either causes the debugger not to work or I have to load my app inside LINQPad's process which works but requires my code to be attached to a query/process (.linq file). Also any changes to the code will require me the rerun the query killing my app's active process or create a new instance with the new code changes while continuing to run the older instances.
COM works well but COM support in dotnet core and 5+ is not complete and many older desktop apps require raw COM for automation and some without Interop assemblies. This limits me to LINQPad 5 (.net 4.8) for COM based solutions.
I have written plugins and extensions that integrates LINQPad with 3rd party desktop apps and my own tools but I want an experience closer to VBA in Excel with all the features especially debugging. My next and maybe final idea is to build a code editor I can embed anywhere and integrate LINQPad as a library compiling queries with my own toolchain. This maybe the only way.