Introduction
The select clause projection helps you pick and shape data from a list or collection into a new form.
When you want to get only certain parts of objects from a list.
When you want to create a new list with transformed or combined data.
When you want to simplify complex objects into simpler ones for display.
When you want to extract specific fields from a collection of records.