Click here to Skip to main content
11,921,898 members (39,529 online)
Rate this:
Please Sign up or sign in to vote.
I would like to have one model (entity framework 5), but connect to two different providers, one that supports SQL and one that supports Oracle. The idea is that I have one set of entities but with a different provider or connection string. I don't want to have two entities, one for each provider.

did anyone do this?
Posted 17-Dec-12 5:53am
Edited 17-Dec-12 5:55am
Rohit Shrivastava 19-Dec-12 18:48pm
theoritically thats what entity framework provides. only constraint is you should have the same schema in both the databases. Have you tried it and facing any issues?

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

  Print Answers RSS
0 OriginalGriff 493
1 Dave Kreskowiak 285
2 Sergey Alexandrovich Kryukov 243
3 Richard MacCutchan 155
4 ppolymorphe 135
0 OriginalGriff 7,231
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,356
3 George Jonsson 2,865
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web04 | 2.8.151120.1 | Last Updated 17 Dec 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