Click here to Skip to main content
Rate this: bad
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 at 6-Sep-12 8:42am
Can i generate edmx file from Oracle database?
Prasad_Kulkarni at 6-Sep-12 8:46am
DevArt's OraDirect provider now supports entity framework. See here[^]
Prasad_Kulkarni at 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 at 6-Sep-12 9:04am
Now its clear....!! thanks
Prasad_Kulkarni at 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
0 Maciej Los 470
1 Sergey Alexandrovich Kryukov 424
2 OriginalGriff 360
3 Abhinav S 250
4 CHill60 240
0 Sergey Alexandrovich Kryukov 10,102
1 OriginalGriff 9,495
2 Peter Leow 5,241
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 3,076

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 6 Sep 2012
Copyright © CodeProject, 1999-2015
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