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.
Friday, 25 April 2014
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”
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;