How can connect 10 databases on single system?

sampath tharanga

I have to connect 10 databases in the same windows form application.so, What are the best way and how can do it? Is it good idea (10 databases with same system).

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Accepted answer
Hell Sampath,
With Single Vender databases: Ok, You just need 10 connections strings and 1 ADO Connection object if your using only one backend MySQL or MS SQL or Oracle etc.

With Multiple Vender Databases : if your application trying to connect multiple vender databases MySQL, MS SQL, Oracle etc then you just need 10 connections strings and 10 ADO Connection objects. In this case,If you want them to execute multiple queries at once, you'll need to make asynchronous queries or use threads. Hope you understand.

Refer these guide lines
http://www.guidanceshare.com/wiki/ADO.NET_2.0_Performance_Guidelines_-_Connections
https://www.progress.com/tutorials/ado-net/designing-performance-optimized-net-applications
https://www.itprotoday.com/sql-server/adonet-checklist
sampath tharanga6y ago
Hi, thanks all. I'll try this method to achive my goal and if any problem comes then ask again. So, thanks again guys.
Vinay Singh6y ago
Hi Try this this may help you

https://www.c-sharpcorner.com/UploadFile/7d3362/various-ways-to-specify-connection-string-in-Asp-Net-web-app/
Rajanikant Hawaldar6y ago
Yes sampath like that also possible, check this thread, there just passing database name to connection string
https://stackoverflow.com/questions/53685534/c-sharp-sql-server-connection-string-with-multiple-databases-on-same-server
sampath tharanga6y ago
Then, how can choose manually which database is select?. Change selected database using combobox or something. So, why we can't create singale connectionstring commonly for 10 database. Only changing "Database Name".
Vinay Singh6y ago
Hi use 10 different connection string to connect to the database with the application. And most important. Use db as per requiremtn when ever the DB is required use it.. After user close the conenction.