schemas support - still don't work :(

schemas support - still don't work :(

Postby 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?
kulibin
 
Posts: 12
Joined: Thu 18 Sep 2008 06:33

Postby AndreyR » Tue 24 Mar 2009 12:31

Please check that your connection string contains the "schema=public,security" part.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby kulibin » Tue 24 Mar 2009 15:39

my connection string contains "schema=security" - but tables from public schema was called in runtime
kulibin
 
Posts: 12
Joined: Thu 18 Sep 2008 06:33

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for PostgreSQL