I am a VB6 programmer. I had several VB6 programs that run on users computers which needed to use a database connection. With over 300 users, this was not reasonable to have each program that each user started create a new connection.
I created an ActiveX exe that would only let one instance of itself start and it created and held the ado connection object. Any program the user would start would get the same reference to the connection ActiveX exe.
I need to recreate this in C#. I would also like to convert a VB6 project that is basically a DAO pattern implementation that programs can use to get objects from.
How can I recreate the ActiveX exe environment in C# where I can pass references to public classes from out of process programs?