Changing the underlying schema name without recompilation

Question

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?

Answer 1

You can change the edmx definition to outpt the csdl/ssdl/msl files to the output directory instead of embedding them into the assembly. You can then direct your connection string to these files and let your customer change the ssdl file and alter the schema name

---

Please mark posts as answers/helpful if it answers your question