StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODevArt Entity Framework deployment using MSDeploy
text
Body
copied!<p>Scenario first :- </p> <p>I'm using Entity Framework to do some queries, to build my Models I'm trying DevArt Entity Developer inside a MVC3 project. I build the app upload to SVN and then a Continuous Integration server picks it up (Bamboo) builds and deploys using MSDeploy. </p> <p>However for some reason there appears to be a problem with the deployment since MSDeploy requires to know about files in advance before it will deploy them, it means that the <code>'.csdl', '.ssdl', or '.msl'</code> files aren't deployed to the remote machine. </p> <pre><code>System.Data.MetadataException: Unable to load the specified metadata resource. </code></pre> <p>Now if I set DevArt from EmbedInOutputAssembly to CopyToOutputDirectory the web.config file changes form </p> <p><code><add name="jcps01EntitiesConnectionString" connectionString="metadata=res://*/Models.jcps01.csdl|res://*/Models.jcps01.ssdl|res://*/Models.jcps01.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=XXXXX;Initial Catalog=jcps01;Integrated Security=False;Persist Security Info=True;User ID=XXXXX;Password=XXXXX&quot;"</code></p> <p>to </p> <p><code><add name="jcps01EntitiesConnectionString" connectionString="metadata=~/bin/Models/jcps01.csdl|~/bin/Models/jcps01.ssdl|~/bin/Models/jcps01.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=XXXXX;Initial Catalog=jcps01;Integrated Security=False;Persist Security Info=True;User ID=XXXXX;Password=XXXXX&quot;" providerName="System.Data.EntityClient" /></code></p> <p>However this comes with its own set of problems, the first is that the application doesn't create a Models folder, it just makes the file <code>/bin/Models.jcps01.msl</code> and of course since the file isn't included in the project/solution MSDeploy doesn't deploy it :| </p> <p>Has anyone ever had any success using MSDeploy with DevArt before and if so did you have to make any changes in your solution to files to copy to output directory etc etc? </p>

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