schemas support - still don't work :(

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
kulibin
Posts: 12
Joined: Thu 18 Sep 2008 06:33

schemas support - still don't work :(

Post by kulibin » Tue 24 Mar 2009 08:00

Hi!
In our project we use edm-model with designer. I try to place some database tables in separate database schema (all entities in EDM from one schema). Designer works well. But in runtime generated queries still calls to schema "public":(. In SDL all tables has "security" schema - but in runtime schema was ignored :(
How can I make this works?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 24 Mar 2009 12:31

Please check that your connection string contains the "schema=public,security" part.

kulibin
Posts: 12
Joined: Thu 18 Sep 2008 06:33

Post by kulibin » Tue 24 Mar 2009 15:39

my connection string contains "schema=security" - but tables from public schema was called in runtime

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 25 Mar 2009 08:58

You need either to have correct Schema attribute and DefiningQuery tag in your SSDL part of model, or to remove them, if you want to operate using connection string parameters.

Post Reply