Advanced querying techniques
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. ...