Changing the underlying schema name without recompilation
Posted: Thu 01 Oct 2009 20:41
I am using dotConnect for Oracle 5.25.44 to connect to an Oracle 10g instance. I am using the EDM Wizard to generate a conceptual model of the database which is then used by ADO.NET Data Services to expose a RESTful web service. I cannot dictate to the customer what the schema owner will be named in their production environment. I also can not install visual studio on their production network and recompile to a new connection and schema.
Now, the connection string is a configuration element in the web.config file, but the Schema name appears to be embedded in the ssdl file generated as part of the compilation. How do I make this a configuration parameter and recompile for production use?
Now, the connection string is a configuration element in the web.config file, but the Schema name appears to be embedded in the ssdl file generated as part of the compilation. How do I make this a configuration parameter and recompile for production use?