CODEWITHSUNDEEP
mysqlentity-frameworkado.net-entity-data-model
User
User

Reputation: 11

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

Upvotes: 1

Views: 688

Answers (3)

Wais
Wais

Reputation: 1759

Preparing an Entity Framework model for multi provider support

Look To This Go To Link

Upvotes: 0

Sharique
Sharique

Reputation: 4219

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.

Upvotes: 1

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364369

It is not possible. You must have separate EDMX file (and context) for each database. There are some ugly workarounds like exposing tables from second database via views in the first database (so EDMX talks only to the first database) but that brings other problems because views are read only in EF unless you create CUD stored procedures for every table exposed as a view.

Upvotes: 0

Related Questions