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

[ivoryguard]

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]

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