.NET SQLite provider can't find my table anymore

Early I used to run :

using (SQLiteConnection sqlite_connection =
    new SQLiteConnection("Data Source="
        + armc.Model.Settings.dbpath
        + ";Version=3;New=True;Compress=True;")) {
    sqlite_connection.Open();
    SQLiteCommand sqlite_command = sqlite_connection.CreateCommand();
    sqlite_command.CommandText = "select * from `archive`"; // ???
    SQLiteDataReader sqlite_datareader = sqlite_command.ExecuteReader();
    while (sqlite_datareader.Read()) {
        m_products.Add
            (new Product("val", int.Parse(sqlite_datareader["value"].ToString())));
        }
    }

But now I'm getting:

$exception {"SQLite error\r\nno such table: archive"} System.Exception {System.Data.SQLite.SQLiteException}

I don't understand what has changed but I still can work with that sqlite using C++ api and using SQLite 2009 Pro util but something is going wrong with .NET provider for .NET 4.0.

Had tried to change database, save as RSA and seems like nothing happens so far, what esle could be there?

Answers


new SQLiteConnection("Data Source="
        + armc.Model.Settings.dbpath
        + ";Version=3;New=True;Compress=True;"))

set Property New to False


Need Your Help

ViewData.Model in partial is null

c# asp.net-mvc model

In my main page (call it index.aspx) I call

Convert Div Content to PDF and save on server path

asp.net c#-4.0 pdf

I want to convert Div content into pdf and save that created pdf file on server path without asking to me save file (download file).