آموزش Linq - بخش ششم : عملگرهای پرس و جو قسمت دوم
نویسنده: مهدی ملائیان
تاریخ: ۱۳۹۴/۱۲/۱۸ ۲۳:۳۵
آدرس: www.dntips.ir
| مطالب | ۳۶۹۴ |
| نویسندگان | ۲۷۶ |
| گروههای مطالب | ۱۰۲۴ |
| نقشههای راه | ۱۱۹ |
| دورهها | ۱۴ |
| اشتراکها | ۱۷۹۱۴ |
string[] ingredients = { "Sugar", "Egg", "Milk", "Flour", "Butter" };
var query = ingredients.OrderBy(x => x);
foreach (var item in query)
{
Console.WriteLine(item);
} Butter Egg Flour Milk Sugar
Ingredient[] ingredients =
{
new Ingredient {Name = "Sugar", Calories = 500},
new Ingredient {Name = "Egg", Calories = 100},
new Ingredient {Name = "Milk", Calories = 150},
new Ingredient {Name = "Flour", Calories = 50},
new Ingredient {Name = "Butter", Calories = 200},
};
var query = ingredients.OrderBy(x => x.Calories);
foreach (var item in query)
{
Console.WriteLine(item.Name + " " + item.Calories);
} Flour 50 Egg 100 Milk 150 Butter 200 Sugar 500
var query = from i in ingredients orderby i.Calories select i;
Ingredient[] ingredients =
{
new Ingredient {Name = "Sugar", Calories = 500},
new Ingredient {Name = "Milk", Calories = 100},
new Ingredient {Name = "Egg", Calories = 100},
new Ingredient {Name = "Flour", Calories = 500},
new Ingredient {Name = "Butter", Calories = 200},
};
var query = ingredients
.OrderBy(x => x.Calories)
.ThenBy(x => x.Name);
foreach (var item in query)
{
Console.WriteLine(item.Name + " " + item.Calories);
} Egg 100 Milk 100 Butter 200 Flour 500 Sugar 500
var query = from i in ingredients orderby i.Calories, i.Name select i;
Ingredient[] ingredients =
{
new Ingredient {Name = "Sugar", Calories = 500},
new Ingredient {Name = "Egg", Calories = 100},
new Ingredient {Name = "Milk", Calories = 150},
new Ingredient {Name = "Flour", Calories = 50},
new Ingredient {Name = "Butter", Calories = 200},
};
var query = ingredients.OrderByDescending(x => x.Calories);
foreach (var item in query)
{
Console.WriteLine(item.Name + " " + item.Calories);
} Sugar 500 Flour 500 Butter 200 Milk 100 Egg 100
var query = from i in ingredients orderby i.Calories descending select i;
Ingredient[] ingredients =
{
new Ingredient {Name = "Flour", Calories = 500},
new Ingredient {Name = "Sugar", Calories = 500},
new Ingredient {Name = "Egg", Calories = 100},
new Ingredient {Name = "Milk", Calories = 100},
new Ingredient {Name = "Butter", Calories = 200}
};
var query = ingredients
.OrderBy(x => x.Calories)
.ThenByDescending(x => x.Name);
foreach (var item in query)
{
Console.WriteLine(item.Name + " " + item.Calories);
} Milk 100 Egg 100 Butter 200 Sugar 500 Flour 500
var query = from i in ingredients orderby i.Calories, i.Name descending select i;
char[] letters = { 'A', 'B', 'C' };
var query = letters.Reverse();
foreach (var item in query)
{
Console.WriteLine(item);
} C B A
Ingredient[] ingredients =
{
new Ingredient {Name = "Sugar", Calories = 500},
new Ingredient {Name = "Lard", Calories = 500},
new Ingredient {Name = "Butter", Calories = 500},
new Ingredient {Name = "Egg", Calories = 100},
new Ingredient {Name = "Milk", Calories = 100},
new Ingredient {Name = "Flour", Calories = 50},
new Ingredient {Name = "Oats", Calories = 50}
};
IEnumerable<IGrouping<int, Ingredient>> query = ingredients.GroupBy(x => x.Calories);
foreach (IGrouping<int, Ingredient> group in query)
{
Console.WriteLine("Ingredients with {0} calories", group.Key);
foreach (Ingredient ingredient in group)
{
Console.WriteLine(" -{0}", ingredient.Name);
}
} Ingredients with 500 calories -Sugar -Lard -Butter Ingredients with 100 calories -Egg -Milk Ingredients with 50 calories -Flour -Oats
string[] applePie = { "Apple", "Sugar", "Pastry", "Cinnamon" };
string[] cherryPie = { "Cherry", "Sugar", "Pastry", "Kirsch" };
IEnumerable<string> query = applePie.Concat(cherryPie);
foreach (string item in query)
{
Console.WriteLine(item);
} Apple Sugar Pastry Cinnamon Cherry Sugar Pastry Kirsch
string[] applePie = { "Apple", "Sugar", "Pastry", "Cinnamon" };
string[] cherryPie = { "Cherry", "Sugar", "Pastry", "Kirsch" };
IEnumerable<string> query = applePie.Union(cherryPie);
foreach (string item in query)
{
Console.WriteLine(item);
} Apple Sugar Pastry Cinnamon Cherry Kirsch
string[] applePie = { "Apple", "Sugar", "Apple", "Sugar", "Pastry", "Cinnamon" };
IEnumerable<string> query = applePie.Distinct();
foreach (string item in query)
{
Console.WriteLine(item);
} Apple Sugar Pastry Cinnamon
string[] applePie = { "Apple", "Sugar", "Pastry", "Cinnamon" };
string[] cherryPie = { "Cherry", "Sugar", "Pastry", "Kirsch" };
IEnumerable<string> query = applePie.Concat(cherryPie).Distinct();
foreach (string item in query)
{
Console.WriteLine(item);
} Apple Sugar Pastry Cinnamon Cherry Kirsch
string[] applePie = { "Apple", "Sugar", "Pastry", "Cinnamon" };
string[] cherryPie = { "Cherry", "Sugar", "Pastry", "Kirsch" };
IEnumerable<string> query = applePie.Intersect(cherryPie);
foreach (string item in query)
{
Console.WriteLine(item);
} Sugar Pastry
string[] applePie = { "Apple", "Sugar", "Pastry", "Cinnamon" };
string[] cherryPie = { "Cherry", "Sugar", "Pastry", "Kirsch" };
IEnumerable<string> query = applePie.Except(cherryPie);
foreach (string item in query)
{
Console.WriteLine(item);
} Apple Cinnamon
var article = "date datetime datelocal Groups dnttips the elements Groups the elements dnttips the".Split(' ');
var result = article.GroupBy(x => x).Select(x => new { Word = x.Key, Count = x.Count() });
foreach (var item in result)
{
Console.WriteLine($"{item.Word} : {item.Count}");
} date : 1 datetime : 1 datelocal : 1 Groups : 2 dnttips : 2 the : 3 elements : 2