Basic use of the Unity SQLite database

Database Connection Object
Sqliteconnection con;
Database Command Object
Sqlitecommand command;
Database Read Object
Sqlitedatareader reader;

Database path in unity, place the database file in the Streamingassets file under the Assets folder for example: database name Stu.sqlite

String Sqlitepath = "Data source=" + Application.streamingassetspath + "/stu.sqlite";

Create a database connection

Con=new sqliteconnection (Sqlitepath);

Create a database directive (to be created by the connection object that connects to the database)

The first of these methods
Command=con. CreateCommand ();

The second method of

Command. Connection = con;

Assigning a query statement to an object

command.commandtext= database Query statements

Open Database

Con. Open ();

Close the database

Con. Close ();

Basic use of the Unity SQLite database