The values of the attributes UseXViews and SessionMode that are specified in the connection string of an application must be the same in the connection string specified for the SchemaLoader.

Unexpected results can occur if these attributes are different. For example, suppose UseXViews = false in the connection string for the SchemaLoader and UseXViews = true in the connection string used by the EDM Wizard. The information that will be returned from either the Views or ViewColumns store schemas will be information on views that the user does not have privilege to access.

Set the RestrictToDefaultDatabase connection string attribute to false when executing the SchemaLoader if applications must specify different values for this attribute.

When an application sets this attribute to true, the Entity Provider will filter the results by the default database.

Unfortunately, a similar recommendation cannot be made for UseXViews.

If users are only allowed to retrieve information on views that they have privilege to access, then mapped tables must be created/loaded for each user.

It is recommended that SessionMode be set to Teradata mode when using mapped tables.

When the mode is set to Teradata, string comparisons are case insensitive. The case insensitivity will reduce the confusion of what information was loaded into the mapped tables, and what data was returned from the store schemas.