Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
4.00/5 (1 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

1 solution

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[^]
 
Share this answer
 
Comments
♥…ЯҠ…♥ 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[^]
♥…ЯҠ…♥ 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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900