Jamie is awesome, I'm a trainer and I love your style and your knowledge, many thanks for these great videos, they are sooooo much appreciated.

great videos. have a few c# resources laying around, this blows them all away in terms of getting an initial foothold/grasp of the concept, which in turn allows me to actually get something out of the other sources as well. Much obliged.

Great explanation

They are ordered in the playlists. Use the playlists.

Welcome to the fire! Sounds like you need to use the entity framework. You can do joins and such, but using the entity framework to "dot" into the tables you need is much better.

The select statement in the method syntax seems useless in this case as you are just returning the same thing you pass in. Stopping after the Where method would have yielded the same result if I'm not mistaken.

I am new to LINQ but I got thrown into the fire... I need to select from multiple tables and populate several dropdowns and a gridview base on the dropdown selections. Is there anyway to group all those selects into one list then use that list to populate my gridview?

I'm confused why we need .Select ( not the linq style but the . style ) ... because I get the same return without .Select

Nice video. But I'm pretty sure that the method syntax is wrapped by a delegate instance, because i read at the msdn docu that the query gets only executed by using it in the foreach and not before by only declaring the query. So it must be a delegate-instance wrapper around it, theoretically. But I'm not sure :). Am I right Jamie?

let me call it 'sql sugar' here are my findings when i use it i have to use select e.g from n in numbers where n > 5 select n; however when i say result = numbers.where(n=>n > 5) i don't have to write select and it works as expected note: sql sugar requires select ???????

I was just beginning to believe the chain was each call returning the Enumerable class, which could then call the other methods of that class. But instead, you are saying this is a sort of nested extension method. [Which is clear because the methods for Enumerable return an IEnumerable or other, not an Enumberable. Okay.] They are two different things, but can now at least tell the difference - thanks!

you should number your videos when they are about the same topic