Replacing WHERE Clause usage using Linq

Prabhukiran345
Posted by Prabhukiran345 under LINQ category on | Points: 40 | Views : 820
We often use the 'IN' Operator to specify multiple values in the WHERE clause. The same can be done very easily using LinQ.

For Example Consider some Static data:
var pinCodes = new[] { 411021, 411029, 411044 };

var Booths = new[] {

new { BoothName = "Booth1", PinCode = 411011 },

new { BoothName = "Booth2", PinCode = 411021},

new { BoothName = "Booth3", PinCode = 411029 },

new { BoothName = "Booth4", PinCode = 411044 },

new { BoothName = "Booth5", PinCode = 411056 },

new { BoothName = "Booth6", PinCode = 411023 },

new { BoothName = "Booth7", PinCode = 411024 }

};


The linQ query to search the desired pincodes from the list of Booth Addresses is:
var lstPinCodes= from booth in Booths

join pins in pinCodes

on booth.PinCode equals pins

select booth;

Comments or Responses

Login to post response