Page 1 of 1

Entity Framework and multiple schemas

Posted: Tue 26 Aug 2008 18:48
by anthonym
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

Posted: Wed 27 Aug 2008 09:46
by Shalex
Thank you for your feedback.
This functionality is implemented already. It will be available in the next build.

Posted: Mon 01 Sep 2008 12:30
by Shalex
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.

Posted: Tue 02 Sep 2008 16:50
by anthonym
Just tested this with the new build and it works great. Thanks for the quick fix guys.

Anthony