public IEnumerable <PersistedMessage> ExecuteAndReadResults(SQLiteCommand command) { var reader = _queryExecutor.ExecuteReader(command); var result = new List <PersistedMessage>(); while (reader.Read()) { result.Add(new PersistedMessage() { TableId = reader.GetInt64(0), Id = reader.GetString(1), Type = reader.GetString(2), Body = reader.GetString(3) }); } reader.Close(); return(result); }