Search code examples
mysqlentity-frameworkado.net-entity-data-model

Multiple Databases in Ado.net Entity framework for Mysql Provider

I want to have access to 2 different databases in Ado.net Entity framework. I created one .edmx file in project, how can i access two different database in single .edmx file Database provider is MySQL.

Regards, venkateswararao

Solution

  • Are two databases are same or different?

    If same than you can use one emdx against both, you just have to create 2 dabase context objects with 2 different connection strings.

    If they are different than you have to create 2 different emdx files.