Entity developer (full version) - multiple databases - with dotConnect provider for Oracle and native MS SQL provider

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
jantoni
Posts: 7
Joined: Tue 13 Jun 2006 07:56

Entity developer (full version) - multiple databases - with dotConnect provider for Oracle and native MS SQL provider

Post by jantoni » Fri 24 Oct 2014 09:57

Dear Support-Team,

Problem: Using Entity Developer (full Version) with MS SQL Server Provider (System.data.sqlclient) and dotConnect provider for Oracle (Devart.Data.Oracle) at same time.

We encountered some problems, according the following scenario:

We earlier used Devart dotConnect for Oracle with Visual Studio (Version 2012 at the moment). Now we have ported our database to MS SQL Server.
We want to use both databases Oracle and MS SQL Server in the future. Our database access in .NET works with Entity Framework (EF – version 6), database first.

We now have two different DataAccess assemblies, one for Oracle and one for MS SQL Server, each with an own edml-model. The generated c# classes for EF are equal.

At first we only worked with Oracle. Our model has been created by the Entity Developer, which has been shipped in bundle with dotConnect for Oracle. This version of Entity developer can’t be used with MS SQL Server native provider (system.data.sqlclient), just “Devart dotConnect for Oracle”.

So we bought the full version of Entity Developer. This can’t be installed together with the bundled version of Entity Developer above. Unfortunately in the full version we can’t use the dotConnect for Oracle provider (Devart.Data.Oracle). There comes an error message if loading an existing project: ... Devart.Data.Oracle not found ...

If we try to create a new project, the “Devart dotConnect for Oracle” provider isn’t shown.

We built an edml-Model for MS SQL Server successfully. So our approach, working with two DataAccess assemblies and therefore two edml-models, has been successful.

Our problem now is, that we need to uninstall one version and install the other version of entity provider when altering the database and update the model. This is a pain!

Question: How is it possible to use the full version of entity developer with the Devart dotConnect for Oracle provider?

It would be great to get a solution for our problem soon. Thanks in advance.

Regards

Jörg Antoni

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

Re: Entity developer (full version) - multiple databases - with dotConnect provider for Oracle and native MS SQL provider

Post by Shalex » Mon 27 Oct 2014 14:37

jantoni wrote:Problem: Using Entity Developer (full Version) with MS SQL Server Provider (System.data.sqlclient) and dotConnect provider for Oracle (Devart.Data.Oracle) at same time.
We cannot reproduce the problem in our environment. Please provide us with an additional information we have asked by email.

Post Reply