Problem with Entity Framework in WPF Application

Question

Hello again,

I am having a problem with a SQL server database in my WPF application. The database is in a separate class library project and I am using Entity Framework. The problem arises when I try and deploy this using ClickOnce in which the following error occurs:

"Underlying Provider failed to open"

I tried to solve this by moving the appropriate files and the database to the main project and then when I deploy the error doesn't show; up but this isn't the solution I'm after.

Any help much appreciated.

Ali Gray

Connection String:

<add name="TPGEntities" connectionString="metadata=res://*/Entities.TPG.csdl|res://*/Entities.TPG.ssdl|res://*/Entities.TPG.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TPG.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />