Hi all, I’ll try to describe my situation before asking my question: my customer has a sql server with 5 databases (one for each internal company department).
I have to develop a webapp on top of these databases to allow employees to work with a single tool but my customer is worried about every change on his server.
These databases need to remain separated, my customer allowed me to just add the minimum tables I need for the users authentication on each db; so my question: could be possible to initialize the db server connection just after I get the db name (server ip/user/password are always the same) from the auth/credentials request?
I didn’t see anything about it… in every example that I’ve seen the db connection is initialized in the AppHost class; are there any pitfalls to initialize it from a “service”?
Where can I initialize the connection in way to correctly propagate it on every service?
I hope I have clearly explained my problem, thank you!