To me this kind of code ... that will obviously not compile ... indicates you have not really studied the basics of using the powerful tools that Linq provides.
Don't worry, though: everyone I know has gone through a learning curve to get somewhat fluent in using Linq :) Well, okay, imho, people with a deep background in DB query languages have an easier time; I just don't know them :)
Please consider getting a book on Linq, and using the on-line tool, LinqPad [^
], provided by the Albihari brothers. They have several books out on Linq; and, you may find this useful: [^
I have found my students respond well to the idea that the 'Where operator is a "selection function;" and, the 'Select operator is a function that enumerates and transforms elements into another form.