Oracle Schema Name

How can I include the schema into my connection开发者_StackOverflow string inside my web.config.

The schema is synonymous with user in oracle - you don't specify a schema in the connection string - you specify a username. Each user may or may not be an owner of database objects (tables, views, procedures, etc). To access the objects owner by another user (schema) you can either:

1. Use a fully qualified name: SCHEMA.OBJECTNAME
2. Create a private synonym which aliases to the object: CREATE SYNONYM mytable FOR otherschema.sometable
3. Create a public synonym which all users can use to access the object: CREATE PUBLIC SYNONYM sometable FOR otherschema.mytable

Check out the list of connection strings for Oracle here.

I could not see any setting that will allow you to specify a schema - guess you need to do this in code.