连接MY SQL DB [英] connecting MY SQL DB with

问题描述

我有一个已经使用ms sql DB的项目，我需要创建一些我的sql DB，这也是出于同一项目和连接的某些原因这两个DB都是交互式的。任何人都可以告诉我如何创建和连接MY SQL DB与MS SQL DB，使用与SQL SQL DB相同的项目在asp.net C＃（VS 2010和SQL Server 2008 R2）中。

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.

推荐答案

您可以使用oledb提供程序连接mysql数据库。连接mysql数据库也很少有mysql dataprovider。请访问以下mysql数据提供商链接。

mysql数据提供商

现在，如果您想同时使用多个数据库，那么您的dataaccess / repository层应为此做好准备。您可以根据您的参数负责提供数据库连接对象时使用工厂设计模式。您可以在dal / repository层中使用该连接与数据库进行通信。

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.

这篇关于连接MY SQL DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！