Just as when you retrieve over association, if the relationship between entities is many-to-one, the retrieve will return the single entity. I know there is an option on the database retrieve to only return "first", but it would be nice if we did not have to remember to check this. Just return the single entity and not a list. This is also something that has caused novice developers to have to include uneccessary loops or list filtering.