What is Select and SelectMany in LINQ?

Select transforms each element; SelectMany also flattens nested collections into one sequence. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.