Click here to Skip to main content
12,294,775 members (65,614 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
R.K.
Posted 6-Sep-12 2:07am

1 solution

Rate this: bad
 
good
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[^]
  Permalink  
Comments
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 11.2.0.3 (ODAC 11.2)
Release Notes:
http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/whatsnew.htm#BGGJIEIC[^]

More documentation on Linq to Entities and ADO.NET Entity Framework:
http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/featLINQ.htm#CJACEDJG[^]

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.160525.2 | Last Updated 6 Sep 2012
Copyright © CodeProject, 1999-2016
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