c# linq methodcheat sheet code example
Example 1: linq cheat sheet
var query = from m in Manufacturers
where m.Name == "Trek"
select new {Name = m.Name, Key = m.ManufacturerId};
var lambda = Manufacturers.Where(m => m.Name == "Trek").Select(m=> new {Name = m.Name, Key = m.ManufacturerId});
Example 2: linq cheat sheet
'Single() will throw an error if more than one result, or there is no result
Dim lambda = Statuses.Single( function(s) s.Name = "Active")
'SingleorDefault() will throw an error if more than one result, and null if there is no result
Dim lambda = Statuses.SingleOrDefault( function(s) s.Name = "Active")
'first() will throw an error if no results
Dim lambda = PartNumbers.First( function(p) p.ModelId = 10001)
'firstOrDefault will return null if no results
Dim lambda = PartNumbers.FirstOrDefault( function(p) p.ModelId = 10001)
Dim lambda = PartNumbers.FirstOrDefault()