We talked about querying techniques in previous chapters. The topic of data retrieval is very extensive and requires developers to be thoroughly familiar with everything LINQ has to offer, in order to address scenarios that come up on a daily basis. In this chapter, we will cover many advanced topics. We want to make sure that developers are prepared for the vast majority of tasks they do daily, but some rarely encountered scenarios may not be addressed in this book.
Projections refer to a process of retrieving a subset of columns from one or more tables in a single query instead of all the columns, as we saw earlier in this book. Projections are very important from the perspective of efficiency and performance. If we only need to present the first and last names of a person to a user of our software, we have no reason to get all the columns from the Person
table. Now we are faced with a question. How do we represent this data from the object perspective...