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()