.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

Explanation on Adding items to a ListBox in Windows RT

c# windows-8 windows-runtime windows-store-apps

I am trying to make a simple Windows 8/RT app for the store and i have a question about adding items to a ListBox.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.