Entity Framework and multiple schemas
Posted: 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
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