Page 1 of 1

schemas support - still don't work :(

Posted: Tue 24 Mar 2009 08:00
by kulibin
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?

Posted: Tue 24 Mar 2009 12:31
by AndreyR
Please check that your connection string contains the "schema=public,security" part.

Posted: Tue 24 Mar 2009 15:39
by kulibin
my connection string contains "schema=security" - but tables from public schema was called in runtime

Posted: Wed 25 Mar 2009 08:58
by AndreyR
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.