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});

Source: brianvanderplaats.com

Linq cheat sheet

var query = from m in Models
		join p in PartNumbers on m.ModelId equals p.ModelId
		where m.Name.Contains("Domane")
		select new {m.ModelId, ModelName = m.Name, PartNumber = p.InventoryPartNumber };

var lambda = Models.Join(PartNumbers, m => m.ModelId, p => p.ModelId, (m, p) => new {m = m, p = p} )
					.Where( j => j.m.Name.Contains("Domane"))
					.Select(j => new {ModelId = j.m.ModelId, ModelName = j.m.Name, PartNumber = j.p.InventoryPartNumber});

Source: brianvanderplaats.com

Linq cheat sheet

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

Dim lambda = Manufacturers.Where(function(m) m.Name = "Trek").Select(function(m) m)

Source: brianvanderplaats.com

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

Source: brianvanderplaats.com

Linq cheat sheet

This is best so far:
https://vslapp.files.wordpress.com/2011/11/linq-cheatsheet.pdf

Source: vslapp.files.wordpress.com

Similar codes

2 votes202 views1 answer
Oracle calculated column
SQL
0 vote225 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
7 votes219 views1 answer
Oracle reset sequence
SQL
3 votes236 views2 answers
WhereIn SQL
SQL
-1 vote294 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote352 views1 answer
Hue hive UploadingTextFiletoHive
SQL
-1 vote236 views1 answer
Create view in mysql workbench
SQL
4 votes311 views2 answers
Convert utc to est sql
SQL
11 votes229 views1 answer
Oracle export view ddl
SQL
0 vote197 views1 answer
Hw to delete a procedure in pl sql
SQL