-
-
Notifications
You must be signed in to change notification settings - Fork 22
Closed
Description
void Start()
{
string path = Path.IsPathRooted(DbName) ? DbName : Path.Join(Application.dataPath, DbName);
_connection = new SQLiteConnection(path);
_connection.DropTable<AssetTable>();
_connection.CreateTable<AssetTable>();
_connection.Insert(new AssetTable
{
ID = 100026,
GUID = "123123123123123",
Address = "address",
AssetPath = "path",
Valid = true,
});
var aaaa = _connection.Query<AssetTable>("SELECT * FROM AssetTable WHERE ID = 100026");
Debug.Log(aaaa[0].GUID);
var query = _connection.Table<AssetTable>().Where(p => p.ID == 100026);
foreach (var asset in query)
{
Debug.Log(asset.GUID);
}
}
Metadata
Metadata
Assignees
Labels
No labels