String filepath = 'URI=file:' + Application.dataPath + DatabaseName Start is called before the first frame update Private string DatabaseName = '/database/DatabaseLeerlingInfo.db' Public class DatabaseController : MonoBehaviour Here is my code: using System.Collections How did you aquire those 4 files? Do the same files work for windows, android and IOS?ĮDIT 1: Like Katsamobus said, you need ' using System.Data ' but I only realised that when I actually wanted to use the 'IDatareader' functions to get data from the database.

I got a lot of error lines in visual studio 2019 so I changed it a little bit and now it works for me. Let me know if t$$anonymous$$s post helped you to solve your issues :D Go to Build Settings and select x86_64 in Arc$$anonymous$$tecture field (Windows Platform).ĭo a new build and check if game run correctly. Net Standard 2.0 is selected in Api Compatibility Lebel field.

Go to Player Settings / Other Settings and be sure. ' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,' + SqlQuery = 'CREATE TABLE IF NOT EXISTS (' + Using (dbconn = new SqliteConnection(conn)) String filepath = Application.dataPath + DATABASE_NAME String DATABASE_NAME = '/mydatabase.s3db' Add the 'IF NOT EXISTS' clause in every CREATE TABLE to prevent future Sql exceptions.Ĭall the new function from the Start() function after find the database. Into your database manager script, add a function that create the tables you need in your database. When you build your project, Unity exports the database EMPTY, that is, without tables. The following files must be inside the Plugins folder:, , f and sqlite3.dll. You have two problems here: error in Unity Editor and issue in build.

Unity pc build on website