there are parts of my application where i am showing read-only access and i want to fetch the reporting data efficiently as possible using linq. if I project into a custom dto object, say i return IEnumerable<UserSearchDTO>, is that populating an entity collection under the hood?

thanks!

No, if your projection result is an anonymous type, no entities are involved in the process. Are you experiencing performance issues?