© Brian L. Gorman 2020
B. L. GormanPractical Entity Frameworkhttps://doi.org/10.1007/978-1-4842-6044-9_9

9. LINQ for Queries and Projections

Brian L. Gorman1 
(1)
Jesup, IA, USA
 

Data in the real world

In this chapter, we are going to learn how to use queries in complex scenarios to get the data we want. To this point, we’ve worked with the database in a fairly superficial manner. As this is a book on practical application of the concepts, we really need to experience working with data in real-world scenarios.

Often, when working with data, there will be a need to perform join operations across multiple tables and then use that data in some manner. There are a couple of approaches that we can employ in these scenarios.

LINQ vs. stored procedures

In the ...

Get Practical Entity Framework: Database Access for Enterprise Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.