Click here to Skip to main content
12,828,403 members (45,926 online)
Rate this:
Please Sign up or sign in to vote.
In my project, am using two databases (Oracle and SQL Server).

So is there any possible way to generate .edmx(ADO.Net entity data model) file using databases other than SQL Server?

If it is possible how can I?
Please respond it ASAP....

With regards
Posted 6-Sep-12 3:07am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Entity Framework does not support mapping more than one database to one model/.edmx file, The EF has a provider model so that more than one type of database can be used with it, but the EF does not support a single model mapped to more than one database.

Refer similar discussion:
unify two models (edmx) with visual studio[^]
rk_prabakar 6-Sep-12 8:42am
Can i generate edmx file from Oracle database?
Prasad_Kulkarni 6-Sep-12 8:46am
DevArt's OraDirect provider now supports entity framework. See here[^]
Prasad_Kulkarni 6-Sep-12 8:47am
Oracle now fully supports the Entity Framework.
Oracle Data Provider for .NET Release (ODAC 11.2)
Release Notes:[^]

More documentation on Linq to Entities and ADO.NET Entity Framework:[^]

Note: ODP.NET also supports Entity SQL.

Found it here[^]
rk_prabakar 6-Sep-12 9:04am
Now its clear....!! thanks
Prasad_Kulkarni 6-Sep-12 9:04am
Glad to hear that.
You're welcome :)

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170326.1 | Last Updated 6 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100