Answers for "linq c# cheat sheet"

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