LINQ

//Query Syntax
var vendorQuery = from v in vendors
                  where v.CompanyName.Contains("Toy")
                  orderby v.CompanyName
                  select v;


//Method Syntax
var vendorQuery = vendors
                    .Where(v => v.CompanyName.Contains("Toy"))
                    .OrderBy(v => v.CompanyName);