Help Generating EDMX
Posted: Thu 16 Oct 2008 14:00
I am evaluating PostgreSQLDirect.NET and am having problems generating the initial edmx model. The problem is the process hangs for at least 24 hours, whether I use EdmGen(2) from the command line, or use the Visual Studio tool.
On the server side, the PgAdmin logs show a query that looks like this being executed:
Select "Project6"."C11" AS "C1", "Projects6"."CatalogName", "Projects6"."SchemaName", etc... being executed.
Going with the theory that the database was overloaded, or the amount of data in the database was affecting the efficiency, I exported the schema only using pg_dump, and loaded it into a freshly installed copy of PostgreSql 8.3 on my local machine. However, even with an empty, unused database, the process was still taking just as long, with no results.
As I've read there are issues with how efficient the entity framework's mapping tools (EdmGen, EdmGen2) are when mapping large numbers of tables, I attempted to map just a single table, with the exact same results; no results written, no progress made whatsoever.
There is no way I can provide the schema to support or publicly, but given that I have the schema, is there anyway to generate the edmx directly from the schema definition file, without interrogating the database and reverse engineering it?
Does anyone have any insight or ideas as to how to get around this? Any help would be greatly appreciated.
On the server side, the PgAdmin logs show a query that looks like this being executed:
Select "Project6"."C11" AS "C1", "Projects6"."CatalogName", "Projects6"."SchemaName", etc... being executed.
Going with the theory that the database was overloaded, or the amount of data in the database was affecting the efficiency, I exported the schema only using pg_dump, and loaded it into a freshly installed copy of PostgreSql 8.3 on my local machine. However, even with an empty, unused database, the process was still taking just as long, with no results.
As I've read there are issues with how efficient the entity framework's mapping tools (EdmGen, EdmGen2) are when mapping large numbers of tables, I attempted to map just a single table, with the exact same results; no results written, no progress made whatsoever.
There is no way I can provide the schema to support or publicly, but given that I have the schema, is there anyway to generate the edmx directly from the schema definition file, without interrogating the database and reverse engineering it?
Does anyone have any insight or ideas as to how to get around this? Any help would be greatly appreciated.