Entity Framework and multiple schemas

anthonym · Post by **anthonym** » Tue 26 Aug 2008 18:48

Hi,

I'm using the trial version 3.75 of the data provider and I'm trying to connect to a database with several schemas.

When I add a new ADO.NET Entity Data Model to a project and specify my database connection, I leave the "Schema" field blank since I'm trying to access tables from different schemas. After I click "Next" to get to the step where I select tables to add to my model, it only lists the ones in the public schema (or whichever schema is first in the search_path of my database user).

Is there a way to include tables from different schemas in one entity data model?

Thanks,
Anthony

Shalex · Post by **Shalex** » Wed 27 Aug 2008 09:46

Thank you for your feedback.
This functionality is implemented already. It will be available in the next build.

Shalex · Post by **Shalex** » Mon 01 Sep 2008 12:30

New build of PostgreSQLDirect .NET version 3.75.31 is available!

To get more information visit: http://www.devart.com/forums/viewtopic.php?t=12787

P.S. When creating new PostgreSQL Server connection in EDM Wizard, you should write several schemas in the Schema field using comma.

anthonym · Post by **anthonym** » Tue 02 Sep 2008 16:50

Just tested this with the new build and it works great. Thanks for the quick fix guys.

Anthony