C#中LINQ的使用知多少？LINQ常功能整理，源代碼解析
作者：架構(gòu)師老盧
以下是20個(gè)常用的LINQ功能點(diǎn)的示例代碼，它們展示了LINQ在C#中的強(qiáng)大查詢能力和靈活性。通過(guò)使用LINQ，開(kāi)發(fā)人員可以更加方便地進(jìn)行各種數(shù)據(jù)操作和查詢，提高代碼的可讀性和開(kāi)發(fā)效率。
LINQ（Language-Integrated Query）是C#語(yǔ)言中的一個(gè)強(qiáng)大的查詢技術(shù)，它提供了一種統(tǒng)一的查詢語(yǔ)法，可以用于查詢和操作各種數(shù)據(jù)源，包括集合、數(shù)據(jù)庫(kù)、XML等。下面詳細(xì)描述了LINQ的20個(gè)功能點(diǎn)，并提供了相應(yīng)的源代碼。
- 查詢集合中的所有元素：
int[] numbers = { 1, 2, 3, 4, 5 };
var query = from num in numbers
select num;
foreach (var num in query)
{
Console.WriteLine(num);
}- 使用條件過(guò)濾集合中的元素：
int[] numbers = { 1, 2, 3, 4, 5 };
var query = from num in numbers
where num % 2 == 0
select num;
foreach (var num in query)
{
Console.WriteLine(num);
}- 對(duì)集合中的元素進(jìn)行排序：
int[] numbers = { 5, 3, 1, 4, 2 };
var query = from num in numbers
orderby num
select num;
foreach (var num in query)
{
Console.WriteLine(num);
}- 對(duì)集合中的元素進(jìn)行分組：
string[] names = { "Alice", "Bob", "Charlie", "David", "Eve" };
var query = from name in names
group name by name[0];
foreach (var group in query)
{
Console.WriteLine(group.Key);
foreach (var name in group)
{
Console.WriteLine(name);
}
}- 對(duì)集合中的元素進(jìn)行投影：
string[] names = { "Alice", "Bob", "Charlie", "David", "Eve" };
var query = from name in names
select name.Length;
foreach (var length in query)
{
Console.WriteLine(length);
}- 連接兩個(gè)集合的元素：
string[] names1 = { "Alice", "Bob", "Charlie" };
string[] names2 = { "David", "Eve", "Frank" };
var query = from name1 in names1
join name2 in names2 on name1[0] equals name2[0]
select new { Name1 = name1, Name2 = name2 };
foreach (var pair in query)
{
Console.WriteLine($"{pair.Name1}, {pair.Name2}");
}- 使用LINQ查詢數(shù)據(jù)庫(kù)：
using (var dbContext = new MyDbContext())
{
var query = from user in dbContext.Users
where user.Age > 18
select user;
foreach (var user in query)
{
Console.WriteLine(user.Name);
}
}- 使用LINQ查詢XML文檔：
XDocument doc = XDocument.Load("data.xml");
var query = from element in doc.Descendants("book")
where (int)element.Element("price") > 10
select element.Element("title").Value;
foreach (var title in query)
{
Console.WriteLine(title);
}- 使用LINQ查詢JSON數(shù)據(jù)：
string json = File.ReadAllText("data.json");
var data = JsonConvert.DeserializeObject<List<Person>>(json);
var query = from person in data
where person.Age > 18
select person.Name;
foreach (var name in query)
{
Console.WriteLine(name);
}- 使用LINQ查詢并轉(zhuǎn)換結(jié)果：
int[] numbers = { 1, 2, 3, 4, 5 };
var query = from num in numbers
where num % 2 == 0
select num * 2;
foreach (var num in query)
{
Console.WriteLine(num);
}- 使用LINQ查詢返回匿名類型：
string[] names = { "Alice", "Bob", "Charlie", "David", "Eve" };
var query = from name in names
select new { Name = name, Length = name.Length };
foreach (var item in query)
{
Console.WriteLine($"{item.Name}, {item.Length}");
}- 使用LINQ查詢返回自定義類型：
public class Person
{
public string Name { get; set; }
public int Age { get; set; }
}
List<Person> people = new List<Person>
{
new Person { Name = "Alice", Age = 20 },
new Person { Name = "Bob", Age = 25 },
new Person { Name = "Charlie", Age = 30 }
};
var query = from person in people
where person.Age > 25
select person.Name;
foreach (var name in query)
{
Console.WriteLine(name);
}- 使用LINQ查詢返回集合：
int[] numbers = { 1, 2, 3, 4, 5 };
var query = from num in numbers
where num % 2 == 0
select num * 2;
List<int> result = query.ToList();
foreach (var num in result)
{
Console.WriteLine(num);
}- 使用LINQ進(jìn)行分頁(yè)查詢：
int pageNumber = 2;
int pageSize = 10;
var query = from product in dbContext.Products
orderby product.Name
select product;
var page = query.Skip((pageNumber - 1) * pageSize).Take(pageSize);
foreach (var product in page)
{
Console.WriteLine(product.Name);
}- 使用LINQ進(jìn)行聚合操作：
int[] numbers = { 1, 2, 3, 4, 5 };
int sum = numbers.Sum();
int max = numbers.Max();
int min = numbers.Min();
double average = numbers.Average();
Console.WriteLine($"Sum: {sum}");
Console.WriteLine($"Max: {max}");
Console.WriteLine($"Min: {min}");
Console.WriteLine($"Average: {average}");- 使用LINQ進(jìn)行集合的交集操作：
int[] numbers1 = { 1, 2, 3, 4, 5 };
int[] numbers2 = { 4, 5, 6, 7, 8 };
var query = numbers1.Intersect(numbers2);
foreach (var num in query)
{
Console.WriteLine(num);
}- 使用LINQ進(jìn)行集合的并集操作：
int[] numbers1 = { 1, 2, 3, 4, 5 };
int[] numbers2 = { 4, 5, 6, 7, 8 };
var query = numbers1.Union(numbers2);
foreach (var num in query)
{
Console.WriteLine(num);
}- 使用LINQ進(jìn)行集合的差集操作：
int[] numbers1 = { 1, 2, 3, 4, 5 };
int[] numbers2 = { 4, 5, 6, 7, 8 };
var query = numbers1.Except(numbers2);
foreach (var num in query)
{
Console.WriteLine(num);
}- 使用LINQ進(jìn)行集合的連接操作：
var query = from order in dbContext.Orders
join customer in dbContext.Customers on order.CustomerId equals customer.Id
select new { OrderId = order.Id, CustomerName = customer.Name };
foreach (var result in query)
{
Console.WriteLine($"{result.OrderId}, {result.CustomerName}");
}- 使用LINQ進(jìn)行集合的逆序操作：
int[] numbers = { 1, 2, 3, 4, 5 };
var query = numbers.Reverse();
foreach (var num in query)
{
Console.WriteLine(num);
}以上是20個(gè)常用的LINQ功能點(diǎn)的示例代碼，它們展示了LINQ在C#中的強(qiáng)大查詢能力和靈活性。通過(guò)使用LINQ，開(kāi)發(fā)人員可以更加方便地進(jìn)行各種數(shù)據(jù)操作和查詢，提高代碼的可讀性和開(kāi)發(fā)效率。
責(zé)任編輯：姜華
來(lái)源：
今日頭條
