Friday, 25 April 2014

Ordering generic list IEnumerable

string[] musos = { "Roger Waters", "Rick Wright", "David Gilmour"};
IEnumerable query = musos.OrderBy(m => m.Split().Last());
Using Inner Query

string[] names = { "Tom", "Dick", "Harry", "Mary", "Jay", "Maya" };
var outerQuery = names
 .Where(n => n.Length == names.OrderBy(n2 => n2.Length)
 .Select(n2 => n2.Length).First()
 ); //output Tom,Jay

Same query as above

IEnumerable comprehension = from n in names
   where n.Length == (from n2 in names
   orderby n2.Length
   select n;
IEnumerable query4 = names
 .Select(n => Regex.Replace(n, "[aeiou]", ""))
 .Where(n => n.Length > 2)
 .OrderBy(n => n.Length);
IEnumerable query4 = names
 .Select(n => Regex.Replace(n, "[aeiou]", ""))
 .Where(n => n.Length > 2)
 .OrderBy(n => n.Length);

Same as above query

IEnumerable query5 = from n in names
 select Regex.Replace(n, "[aeiou]", "") into g
 where g.Length > 2
 select n2.Length).First()
 orderby g.Length
 select g;

IEnumerable query8 = from n1 in
 (
 from n2 in names
 select Regex.Replace(n2, "[aeiou]", "")
 )
 where n1.Length > 2
 orderby n1
 select n1;

 IEnumerable query9 = from n in names
  let vowelless = Regex.Replace(n, "[aeiou]", "")
  where vowelless.Length > 2
 orderby vowelless
 select n; // Thanks to let, n is still in scope.
Share:

using First, FirstOrDefault, DefaultIfEmpty, Single, SingleOrDefault

string[] names = { "Tom", "Dick", "Harry", "Mary", "Jay", "Maya" };
int[] number = { 1, 5, 6, 8, 20, 15, 34, 67, 98, 12, 23 };
 var num = number.Where(n => n > 100).FirstOrDefault(); //num=0
 var numm = number.Where(n => n > 100).First(); //will give an error
 var nummm = number.Where(n => n > 100).DefaultIfEmpty(1).First(); //nummm=1
 var nam = names.Where(n => n.StartsWith("z")).FirstOrDefault();//nam=null
 var name = names.Where(n => n.StartsWith("M")).SingleOrDefault();
//will give an error because two values found with “M”

Share:

Find Customer list whom city exists in city array

String[] _cities = { "London", "New Delhi" };

var _customers = new[] { new { Name = "Saurabh", City = "London" },
 new { Name = "Sumit", City = "New Delhi" },
 new { Name = "Rohit", City = "London" },
 new { Name = "Rahul", City = "Mumbai" },
 new { Name = "Suresh", City = "London" },
 new { Name = "Sunil", City = "New Delhi" },
 new { Name = "Mahesh", City = "Agra" }
 };

var _query = from c in _customers
 where (_cities).Contains(c.City)
 select c;
Share: