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 ...