How do I reference the Sqlite db file in the App_Data folder for my ASP.NET Web Application?

Question

I'm currently storing my sqlite db file in the App_Data folder as per ASP.NET best pattern and practices.

Currently I'm using the following in the webconfig:

  <connectionStrings>
    <add name="sqlite"  
         connectionString="Data Source=|DataDirectory|MyDB; Version=3;" />
  </connectionStrings>

and the following in code:

       public SqliteDAO(string path)
        {
            Connection = new System.Data.SQLite.SQLiteConnection(path );
        }

//...

//where path = |DataDirectory|MyDB

It causes sqlite to make a NEW database (with no tables in it), and thus none of my data access calls work, since they aren't finding the table names. How do I reference the sqlite db file in the App_Data folder from my WebApplication code??

Thanks!

Answer 1

Use Server.MapPath to your db file. So it would be something like

Server.MapPath(@"~\App_Data\Your.db");