title: SQLCompact connection error in azure web sites
body: <p>I am using the below connection string .This is working fine when I am in the azure web role but when I try to use this connection string in a azure web site I am getting this error 
  The path is not valid. Check the directory for the database. [ Path = D:\home\site\wwwroot\App_Data\Configuration.sdf ]</p>
  
  <pre><code>  &lt;add name="Configuration"
         connectionString="Data Source=|DataDirectory|\Configuration.sdf"
         providerName="System.Data.SqlServerCe.4.0" /&gt;
  </code></pre>
  
  <p>Is there some other configuration needed for Azure web sites.</p>
  
  <p>Update:
  So I looked at this thread <a href="https://stackoverflow.com/questions/14938406/sql-ce-azure-connection">Stack Link</a> and this person has the same issue but he adds the database connection through azure management portal so I am sure it's supposed to work.</p>
  
  <p>Thanks</p>