First LINQ query expression

from u in Users
join b in Businesses on u.BusinessID equals b.ID
orderby b.ID
select new {u.LastName, b.BusinessName}

Wow, a basic query expression sure is easy.  And it’s very familiar if you’ve worked with any flavor if SQL. This is an incredibly simple example, but definitely cool.

The order of your clauses definitely shift and your table alias equivalents are a bit different, but barely worth mentioning.

Btw, I’m reading through the .Net Standard Query Operators spec and using LINQPad to get started learning LINQ.  I’ve never met Joseph Albahari, but he seems to be one smart guy.

Advertisements