public TagAction GetNextTagAction() { using (var connection = new SQLiteConnection(DatabaseFilename)) { using (var statement = connection.Prepare(@"SELECT ID, ITEM_ID, TAG, ACTION_KIND FROM TAG_ACTION ORDER BY ID LIMIT 1;")) { if (statement.Step() != SQLiteResult.ROW) { return(null); } var item = new TagAction { Id = statement.GetInteger(0), ItemId = statement.GetText(1), Tag = statement.GetText(2), Kind = (TagActionKind)statement.GetInteger(3) }; return(item); } } }
public TagAction GetNextTagAction() { using (var connection = new SQLiteConnection(DatabaseFilename)) { using (var statement = connection.Prepare(@"SELECT ID, ITEM_ID, TAG, ACTION_KIND FROM TAG_ACTION ORDER BY ID LIMIT 1;")) { if (statement.Step() != SQLiteResult.ROW) return null; var item = new TagAction { Id = statement.GetInteger(0), ItemId = statement.GetText(1), Tag = statement.GetText(2), Kind = (TagActionKind)statement.GetInteger(3) }; return item; } } }