Cannot connect to SQLite DB in android

Questions & Answers
1

Hi guys
In editor everything works fine but the problem is in android device.
The .db file copy in Application.PersistentDataPath but SqliteConnection cant connect to .db, it’s doesn’t give any error but doesn’t read value from .db, too.

please help

this is my code:

StrConnection = "URI=file:" + Application.persistentDataPath + "/" + _DBName;
if (System.IO.File.Exists (Application.persistentDataPath + "/" + _DBName))
			_txtShowUI.text += "Database Exist

";
else
_txtShowUI.text += "Database Not Found
";

		using (IDbConnection dbConnection = new SqliteConnection(StrConnection))
		{
			_txtShowUI.text += StrConnection + "

";
dbConnection.Open();
_txtShowUI.text += dbConnection.State.ToString() + "
";
using(IDbCommand dbCmd = dbConnection.CreateCommand())
{
string sqlQuery = “SELECT * FROM tbl_01”;
dbCmd.CommandText = sqlQuery;

				using(IDataReader reader = dbCmd.ExecuteReader())
				{
					while(reader.Read())
					{
						_txtShowUI.text += reader.GetInt32(0) + ". " + reader.GetString(1) + " " + reader.GetString(2) + "

";
}
reader.Close();
}
}
dbConnection.Close();
}

3

http://answers.unity3d.com/answers/1414635/view.html

2

Instead of

"URI=file:" + Application.persistentDataPath + "/" + _DBName;

try this:

new WWW("jar:file://" + Application.dataPath + "!/assets/" + DatabaseName);

but if like u said is in persistent data path u can simply do this:

var filepath = string.Format("{0}/{1}", Application.persistentDataPath, DatabaseName);

without the URI in front!