schemas support - still don't work :(

kulibin · 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 · Post by **AndreyR** » Tue 24 Mar 2009 12:31

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

kulibin · 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 · 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.