Multiple DB Support of EF with both DotConnect for Oracle and MySQL

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ivoryguard
Posts: 5
Joined: Wed 13 Oct 2010 01:11

Multiple DB Support of EF with both DotConnect for Oracle and MySQL

Post by ivoryguard » Mon 15 Dec 2014 22:29

Hello.

I have used DotConnect for Oracle with EF4 and WCF RIA Services since 2010.

I succeeded in supporting both MSSQL and Oracle at my app by using separate MSL/CSDL/SSDL files.

Now, I want to add MySQL support, as well as MSSQL and Oracle, with single EF model.

Could you please let me know it is possible to use both DotConnect for Oracle and DotConnect for MySQL in a single VS project?

If it is possible, please let me know how I can achieve it. When I used DotConnect for Oracle at 2010, there is few resources to support multiple DB in a single VS project.

Best regards.

Shalex
Site Admin
Posts: 8240
Joined: Thu 14 Aug 2008 12:44

Re: Multiple DB Support of EF with both DotConnect for Oracle and MySQL

Post by Shalex » Wed 17 Dec 2014 17:51

ivoryguard wrote: I succeeded in supporting both MSSQL and Oracle at my app by using separate MSL/CSDL/SSDL files. [...]
Could you please let me know it is possible to use both DotConnect for Oracle and DotConnect for MySQL in a single VS project?
Yes, it is possible. An example is available at http://www.devart.com/efquerysamples.zip.

Note that Devart data providers use a common assembly (Devart.Data.dll), so it is necessary to install compatible providers versions. We release our ADO.NET data providers in a single pack, thus releases from the same date should be compatible:
http://www.devart.com/dotconnect/oracle ... story.html
http://www.devart.com/dotconnect/mysql/ ... story.html

Post Reply