Tools to generate and maintain Oracle db

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
object
Posts: 89
Joined: Tue 26 Oct 2010 08:29

Tools to generate and maintain Oracle db

Post by object » Tue 26 Oct 2010 08:46

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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 26 Oct 2010 11:20

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.

object
Posts: 89
Joined: Tue 26 Oct 2010 08:29

Post by object » Tue 26 Oct 2010 11:33

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?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 26 Oct 2010 11:53

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

object
Posts: 89
Joined: Tue 26 Oct 2010 08:29

Post by object » Tue 26 Oct 2010 12:05

This makes perfect sense. Thank you for quick replies!

Post Reply