title: MySQL - Schema is not valid & No mapping specified for instances of..... (etc.)
body: <p>When I run the *.svc file in my solution to test the Web Service using the WCF Test Client in Visual Studio 2010 I get the following error:</p>
  
  <pre><code>Schema specified is not valid. Errors: 
  emp.msl(3,4) : error 2062: No mapping specified for instances of the EntitySet and AssociationSet in the EntityContainer empEntities.
  </code></pre>
  
  <p>If I right click on emp.edmx in the Model Browser > Generate Database from Model... > click Finish. Then click on the *.svc file and click run I get the error:</p>
  
  <pre><code>Object reference not set to an instance of an object.
  </code></pre>
  
  <p>I can circle back to the first error by doing the following:</p>
  
  <ol>
  <li>Right click on emp.edmx in the Model Browser > Update Model from Database...</li>
  <li>Refresh the Tables, Views, and Stored Procedures</li>
  <li>Right click on both *.tt files in the Solution Explorer > click Run Custom Tool for both files</li>
  <li>Right click on the *.edmx file in the Solution Explorer > click Run Custom Tool</li>
  <li>Left click on the *.svc file, then run, invoke anything and I get the original error.</li>
  </ol>
  
  <p>Also, the database has been edited and I am trying to align the app's schema to the db's schema, more or less. The app was working before someone edited the db.</p>
  
  <p>The app uses linq &amp; MySQL to query the database which then presents the table on SharePoint for people to view, not edit.</p>
  
  <p>I have reviewed the following posts and have gotten nowhere:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/5667355/why-am-i-getting-this-error-no-mapping-specified-for-the-following-entityset-as">Why am I getting this error: No mapping specified for the following EntitySet/AssociationSet - Entity1?</a></li>
  <li><a href="https://stackoverflow.com/questions/3700637/how-do-i-correctly-set-an-association-between-two-objects-in-the-entity-framewor">How do I correctly set an association between two objects in the Entity Framework 4 Entitydesigner?</a></li>
  </ul>