I fixed up your code sample and moved the post to the .NET section.
If you just want to a list of all the values in a response, you could project just the values like this:
var response = _bucket.Query<KeyValuePair<string, Profile>>(request);
var profiles = response.Rows.Select(x => x.Value).ToList();
However, as you're not using the 'key' field, you could make your query simpler and therefore your QueryResult type like this:
public List<Profile> GetAll()
var request = QueryRequest.Create("SELECT TOOBJECT(hc) as `value` FROM `test` as hc WHERE type='Profile';");
var response = _bucket.Query<Profile>(request);