title: ADO.NET Entity Connection String for Multiple Projects
body: <p>I am using multiple layer project where the DataModel hosts the ADo.NET Entity model and DataAccess layer does the validation.</p>
  
  <p>However everytime I get a error like this </p>
  
  <blockquote>
    <p>The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.</p>
  </blockquote>
  
  <p>I have tried connection strings</p>
  
  <p><code>&lt;add name="SalesEntities" connectionString="metadata=res://*/SalesEntities.csdl|res://*/SalesEntities.ssdl|res://*/SalesEntities.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=.;Initial Catalog=Phoenix;Integrated Security=True;MultipleActiveResultSets=True&amp;quot;" providerName="System.Data.EntityClient" /&gt;</code>   </p>
  
  <p>and </p>
  
  <p><code>
  &lt;add name="SalesEntities" connectionString="metadata=.\SalesEntities.csdl|.\SalesEntities.ssdl|.\SalesEntities.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=.;Initial Catalog=Phoenix;Integrated Security=True;MultipleActiveResultSets=True&amp;quot;" providerName="System.Data.EntityClient" /&gt;</code></p>
  
  <p>also tried other combinations to refer the Root Directory of the Called project directory but no luck.</p>
  
  <p>Any help is highly appreciated. Many Thanks as always :). </p>