Oracle and Edmgen2

Marc44 · 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 · 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 · 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 · Post by **AndreyR** » Tue 13 Oct 2009 14:55

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

Marc44 · 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 · 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).