using App_Data in connection string

Question

simple stuff, I want to use App_Data as my db storage folder.

How can I reference App_Data in my connString.

<add name="ConnectionString" connectionString="Data Source=mydb.sqlite; ..." />

Answer 1

<add name="ConnectionString" 
connectionString="Data Source=|DataDirectory|\MyDb.sqlite;......" />

The |DataDirectory| token would expand to an App_Data folder under the root of a web application.