How can connect 10 databases on single system?

Question

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).

Rajanikant Hawaldar · 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 y ou 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 tharanga · Answer

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".

sampath tharanga · Answer

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 Singh · Answer

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 Hawaldar · Answer

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

Vinay Singh · Answer

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.