Oracle and Edmgen2

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Marc44
Posts: 7
Joined: Mon 05 Oct 2009 15:08

Oracle and Edmgen2

Post by Marc44 » Fri 09 Oct 2009 16:00

Hello,

Has anyone tried using edmgen2 to connect to an Oracle database? It is really slow compared to sql server and on top of that I still can't generate an edmx or associated files with it...

Thanks,

Marc

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

Post by AndreyR » Mon 12 Oct 2009 11:01

The default way to query metadata for EF Model creation is MSSQL Server-oriented and in the Oracle case is much slower.
We have made some optimizations for Entity Data Model Wizard and Update from Database Wizard.
No EdmGen2-specific optimizations are planned.

Marc44
Posts: 7
Joined: Mon 05 Oct 2009 15:08

Post by Marc44 » Tue 13 Oct 2009 13:02

AndreyR wrote:Entity Data Model Wizard and Update from Database Wizard
Thank you for your response. What tools are the Entity Data Model Wizard and the Update from Database Wizard from?

Marc

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

Post by AndreyR » Tue 13 Oct 2009 14:55

These are design time Microsoft tools integrated into Visual Studio 2008 Service Pack 1.

Marc44
Posts: 7
Joined: Mon 05 Oct 2009 15:08

Post by Marc44 » Tue 13 Oct 2009 15:08

AndreyR wrote:These are design time Microsoft tools integrated into Visual Studio 2008 Service Pack 1.
Ok thanks. I actually though you were referring to a product that devart is offering to clients. So am I to assume that the devart team has already put the optimizations in place and that the Entity Framework designer and wizard are pretty much as fast as it is going to get?

Marc

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

Post by AndreyR » Wed 14 Oct 2009 13:06

We provide Entity Developer as well.
This tool uses another way to query metadata, its performace is even better than the one of
Microsoft wizard's (even with our optimizations).

Post Reply