Databases
StackOverflow2013
Postsdbo
POHow does ServiceConfiguration.cscfg and ServiceDefinition.csdef play with WebConfig in Azure?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow does ServiceConfiguration.cscfg and ServiceDefinition.csdef play with WebConfig in Azure?
    text
    copied!<p>I have a big Silverlight app which I have successfully converted and added a CloudService project. I have uploaded the database to SQL Azure, and from my webconfig file with a connection to this database on SQL Azure everything works fine. So, my next step, where I'm crashing, was when adding a Cloud Service to my solution and setting that service as a startup project.</p> <p>So, I'm guessing that I'm not adding the connectionstring correctly to ServiceConfiguration.cscfg/ServiceDefinition.csdef ?</p> <p>Error I get is: Error message is for Query LoadUsers: System.ServiceModel.DomainServices.Client.DomainOperationException: Load operation failed for query 'LoadUserInfo'. The remote server returned an error: NotFound.....</p> <p>My connectionstring look like this in webconfig:</p> <pre><code>&lt;add name="LiveEntities" connectionString="metadata=res://*/LiveModel.csdl|res://*/LiveModel.ssdl|res://*/LiveModel.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=.;Initial Catalog=Live09092010;Integrated Security=True;MultipleActiveResultSets=True&amp;quot;" providerName="System.Data.EntityClient" /&gt; </code></pre> <p>Do I need to put the same connectionstring into ServiceConfiguration.cscfg/ServiceDefinition.csdef and how should it look like?</p> <pre><code>Solution Live SilverLight App proj 1 --files Silverlight App proj 2 --files Silverlight App proj 3... --files... Live.Web --My Project --Default.aspx --Web.config --etc.. LiveCloudServices Roles --Live.Web --ServiceConfiguration.cscfg --ServiceDefinition.csdef </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload