why sqlite can't read table names from database created programatically in the application

ozkaro 66

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

Karen Payne MVP 35,031 Reputation points

2021-09-03T09:52:01.837+00:00
Consider for the sake verifying if the query done in LINQ is the problem or something else use a connection and command object with the following SQL query to see if names are returned or you get another error.

SELECT name FROM sqlite_master WHERE type ='table' AND name NOT LIKE 'sqlite_%';

ozkaro 66

Hi Thanks but it returns "value cannot be null, parameter name: type"

            string queryTable = "SELECT name FROM sqlite_master WHERE type = 'table' AND name ";

            var sl = con.Query<Object>(queryTable); // here argument null exception

            Toast.MakeText(this, "Table name " + sl.Count, ToastLength.Short).Show();

Leon Lu (Shanghai Wicresoft Co,.Ltd.) 68,016 Reputation points Microsoft Vendor

2021-09-06T02:56:04.57+00:00

Do you want to use other application's sqlite DB in your application? You get the DB path by System.Environment.SpecialFolder.LocalApplicationData, If your application's package name is com.companyname.app129,it will back the path "/data/user/0/com.companyname.app129/files/.local/share/data_base.sqlite", different application have different package names, So, If other applications's package name is com.companyname.app100, then you use System.Environment.SpecialFolder.LocalApplicationData, you will get "/data/user/0/com.companyname.app100/files/.local/share/data_base.sqlite", So you get launch an exception that such table doesn't exist,