Answers for "linq cheat sheet c#"

linq cheat sheet

Dim query = from m in Manufacturers
	where m.Name = "Trek" 
	select new with {.Name = m.Name, .ManufacturerId = m.ManufacturerId}

Dim lambda = Manufacturers.Where(function(m) m.Name = "Trek").Select(function(m) new with {.Name = m.Name, .ManufacturerId = m.ManufacturerId})

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

linq cheat sheet

var query = from m in Manufacturers
	where m.Name == "Trek" 
	select m;

var lambda = Manufacturers.Where(m => m.Name == "Trek").Select(m => m);