Devart Forums

Hello,

I am considering using Devart tools to achieve the following:

1. Generate and maintain Oracle db schema from an EDMX file generated for SQL Server (database is a table collection with relations, no stored procedures or SQL Server-specific stuff)

2. Use Oracle db with Entity framework from an application writtten using Visual Studio 2010.

I see that you have Entity Developer tools, and I assume it is capable of doing job in p.1.
Do I need dotConnect for Oracle to achieve p.2? If so, what edition? Will Developer edition be sufficient if I am the only developer working with this task? Does this edition come with a runtime license? The solution is for internal use, it will only be deployed in one place in the organization.

Thanks in advance

P.S. I checked Entity Developer editions and am a little confused. There are specific Entity Developer editions for dotConnect and SQL Server. Does it mean I need them both? Or since I am using VS2010 perhaps I don't need Entity Developer for SQL Server at all?

Vagif Abilov
Oslo Norway

You can purchase only dotConnect for Oracle and generate an .edmx model using the Microsoft ADO.NET Entity Data Model wizard, dotConnect for Oracle provides support for this tool.
Take a look at the
It seems to me that you need the Professional edition (if you don't need OraDeveloper Tools), it has Entity Framework support. Of course if you need OraDeveloper Tools, then you need the Developer edition.
As for the licensing, our product is licensed for developers (not for a workstation or a server). The license you purchase allows you to use dotConnect for Oracle, i.e. to compile the assemblies which have direct references to the Devart assemblies, to use Devart classes.
More details about the technical licensing are available here.

Thank you for the answer. I went ahead and downloaded Entity Developer trial. Now when I load a model from a database (using SQL Server as a source), then how do I convert to Oracle schema? I played with a tool and changed connection to point to an Oracel db, and then of course I got a lot of errors because of incompatible data types (nvarchar, datetime etc.). So assuming I have a model generated from a SQL Server database, how do I render it using Oracle datat types?

Take a look at this post, we have discussed this problem there.

This makes perfect sense. Thank you for quick replies!