Relative Path in ASP.NET Web.config

Question

I have the following tag in my ASP.NET Web.config application:

<add name="monitorEntities" connectionString="metadata=res://*/Models.MonitorDB.csdl|res://*/Models.MonitorDB.ssdl|res://*/Models.MonitorDB.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;C:\Documents and Settings\jdoe\Desktop\LcdManager\LcdManager\App_Data\monitor.sqlite&quot;'" providerName="System.Data.EntityClient" />

that refers to an EntityFramework instance mapping a sqlite db located in the App_Data directory of the application.

How can i make the link relative so that deploying in a production environment is easier?

Thanks

David Christiansen · Accepted Answer · 2009-07-27 10:16:07Z

6

Have you tried

<add name="monitorEntities" connectionString="metadata=res://*/Models.MonitorDB.csdl|res://*/Models.MonitorDB.ssdl|res://*/Models.MonitorDB.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;./App_Data/monitor.sqlite&quot;'" providerName="System.Data.EntityClient" />

or

<add name="monitorEntities" connectionString="metadata=res://*/Models.MonitorDB.csdl|res://*/Models.MonitorDB.ssdl|res://*/Models.MonitorDB.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;|DataDirectory|/monitor.sqlite&quot;'" providerName="System.Data.EntityClient" />

answered Jul 27, 2009 at 10:16

David Christiansen

5,9192 gold badges40 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

M4N · Accepted Answer · 2009-07-27 10:26:44Z

6

Can't you use "|DataDirectory|" in the connection string (instead of C:...\App_Data)? E.g:

connectionString="... |DataDirectory|\monitor.sqlite ..."

I know this works for SQL Server Express databases that are deployed in the app_data folder of the application. But I don't know if this works for Entity Framework / SQLite.

edited Jul 27, 2009 at 10:26

answered Jul 27, 2009 at 10:15

M4N

96.8k45 gold badges225 silver badges265 bronze badges

3 Comments

Dave Archer Over a year ago

Does that work when built on one server and deployed to another?

M4N Over a year ago

As long as your database is in the App_Data folder of the deployed application.

Dave Archer Over a year ago

doh! yes web.config not compiled, duh me :-( This is probably the right way to do it then, not my answer.

Dave Archer · Accepted Answer · 2009-07-27 10:16:04Z

0

I assume you're talking about this bit

C:\Documents and Settings\jdoe\Desktop\LcdManager\LcdManager\App_Data\monitor.sqlite

instead, try this

../../App_Data/monitor.sqlite

(not sure about the number of '../' but you get the idea ../../App_Data/monitor.sqlite

answered Jul 27, 2009 at 10:16

Dave Archer

3,05021 silver badges23 bronze badges

Collectives™ on Stack Overflow

Relative Path in ASP.NET Web.config

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related