Entity Framework - how can I change connection string to be relative?
Can someone confirm how to change the auto-generated connection string for an entity framework application so that it is relative? 

That is so it will work for anyone who downloads and installs the application.  That is, currently the connection string auto-generated for me has an absolute path in it.  See below for an example:

    <add name="Model1Container" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;C:\Documents and Settings\Owner\My Documents\My Dropbox\source\MyProject\MyProjectLibrary\MyProject.sqlite&quot;'" providerName="System.Data.EntityClient" />

I should note that in my solution the UI application project uses a separate business logic layer project where the Entity Framework model is.  I have been copying the auto-generated connection string from this latter project to the UI project to get things to work.

thanks
Entity Framework - how can I change connection string to be relative?
===

Can someone confirm how to change the auto-generated connection string for an entity framework application so that it is relative? 

That is so it will work for anyone who downloads and installs the application.  That is, currently the connection string auto-generated for me has an absolute path in it.  See below for an example:

    <add name="Model1Container" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;C:\Documents and Settings\Owner\My Documents\My Dropbox\source\MyProject\MyProjectLibrary\MyProject.sqlite&quot;'" providerName="System.Data.EntityClient" />

I should note that in my solution the UI application project uses a separate business logic layer project where the Entity Framework model is.  I have been copying the auto-generated connection string from this latter project to the UI project to get things to work.

thanks