A Unity3D/C# wrapper around SQLite
- Read data from sqlite / Write data into sqlite
- Transaction sql
- TODO
- Generate data template depend on sqlite table structure
- Deserialize sql result into object
- Excel support
U3Database db = U3Database.DatabaseWithPath(Application.dataPath + "/test.db");
db.Open();
db.Update("UPDATE Main SET Value=3 WHERE ID=1");
db.Update("Main", "Value", 5);
db.Update("Main", "Value", 6, "ID=1");
db.Update("Main", "Value", 9, "ID", 2);
U3DBResultSet result = null;
result = db.Select("SELECT * FROM MAIN");
result.Show();
result = db.Select("Main", "ID", 1);
result.Show();
db.Insert("Main", "Value", 888);
db.Insert("Main", "Value", 999, "Description", "???");
db.BeginTransaction(delegate(ref bool rollback)
{
db.Update("Main", "Value", 0);
rollback = true;
});
- Unity 3D 4.x/5.x