Click here to Skip to main content
15,908,173 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have a project already with ms sql DB where I need to create a few my sql DBs also for some reasons for the same project and connect both DBs interactively. Can anyone tell me how to create and connect MY SQL DB with MS SQL DB, with the same project which is in asp.net C# (VS 2010 and SQL Server 2008 R2) with MS SQL DB.
Posted

1 solution

You can use oledb provider for connect mysql database. Few mysql dataprovider also exists for connect mysql datababase. Please visit following links for mysql data providers.
mysql data providers
Now if you want to use multiple database simultaneously then your dataaccess/repository layer should be ready for that. You can use factory design pattern when will be responsible for provide db connection object based on your parameter. You can use that connection in your dal/repository layer for communicate with database.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900