why sqlite can't read table names from database created programatically in the application
ozkaro
66
Reputation points
Hi I've created an application what's use sqlite to create database but if I want to use the database created in other application in the moment to call the table names, launch an exception that such table doesn't exist, I tried to open the table in "DB Browser for SQLite application tool" and it read exactly as I've created.
why this occurs?
string db_path = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.LocalApplicationData), "data_base.sqlite");
con = new SQLite.SQLiteConnection(db_path);
var dbquery = from sel in con.Table<CharacterTable>() orderby sel.number select sel;
result = dbquery.ToList(); // SQLiteException error