I know we can overwrite schema and catalog using web.config. Can you help me doing this using Code? I mean any other way of doing this other then specifying in web.config, so can do better error handling?
From your older threads I see you are using Adapter and v3.1, so I will assume that.
When you create the DataAccessAdapter instance, there is a ctor that receive a **CatalogNameOverwriteHashtable **and SchemaNameOverwriteHashtable, you can pass the overwrites with that objects.