sqlite works in editor but not in device

Questions & Answers
1

i created sqlite database by DBbrowser and it works fine unity editor but when ever i build for android it does not work in device.
this the script for connection

using UnityEngine;

using System.Collections;

using Mono.Data.Sqlite;

using System.Data;

using System.Collections.Generic;

using System;

using System.IO;

using Mono.Data;

public class databaseDemo : MonoBehaviour

{

  void Start()

  {

     
      string conn = "URI=file:" + Application.streamingAssetsPath+ "/databsedemo1.db"; //Path to database.        
      
      IDbConnection dbconn;
     
      dbconn = (IDbConnection)new SqliteConnection(conn);
     
      dbconn.Open(); //Open connection to the database.
     
      IDbCommand dbcmd = dbconn.CreateCommand();
      
      string sqlQuery = "SELECT id,name FROM temp";
      dbcmd.CommandText = sqlQuery;
      IDataReader reader = dbcmd.ExecuteReader();
    
      while (reader.Read())
      {
          int id = reader.GetInt32(0);
          string name = reader.GetString(1);

          GameObject.Find("id").GetComponent<UIInput>().value = id.ToString();
          GameObject.Find("name").GetComponent<UIInput>().value = name.ToString();
        
          Debug.Log("id= " + id + "  name =" + name );
      }
    
      reader.Close();
      reader = null;
      dbcmd.Dispose();
      dbcmd = null;
      dbconn.Close();
      dbconn = null;
  }

}

i put my .db file in StreamingAssets folder,

i put sqlite3.dll, mono.data.sqlite,system.data, into plugins folder,

i put in Plugins/Android/lib/ libsqlite3.so file
please help.

3

Problem solved.
please download this plugin from gethub

2

Hi, i’m facing the same issue, did you got the solution if yes kindly share it. thanks