Linq复杂对象查询

最新推荐文章于 2021-09-07 17:21:20 发布
最新推荐文章于 2021-09-07 17:21:20 发布
阅读量219 收藏
点赞数
文章标签： c#
原文链接：https://yq.aliyun.com/articles/336929
版权

复杂的查询对象，
422101-20170513175701738-1511863812.png

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               where c.Region == "Asia"
                               select c;
            Console.WriteLine("亚洲的有:");
            foreach (Customer c in queryResults)
            {
                Console.WriteLine(c);
            }

            Console.ReadLine();
        }
    }
}

查询对象的某个元素

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               where c.Region == "Asia"
                               select c.City;
            Console.WriteLine("亚洲的城市有:");
            foreach (String city in queryResults)
            {
                Console.WriteLine(city);
            }

            Console.ReadLine();
        }
    }
}

查询结果只能是字符串，或者一个对象

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               where c.Region == "Asia"
                               select new { c.City, c.Country };
            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

用Select函数

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            //var queryResults = from c in customers
            //                   where c.Region == "Asia"
            //                   select new { c.City, c.Country };
            var queryResults = customers.Where(c => c.Region == "Asia").Select(c => new { c.City, c.Country });
            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

去重处理Distinct方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            //var queryResults = from c in customers
            //                   where c.Region == "Asia"
            //                   select new { c.City, c.Country };
            var queryResults = customers.Select(c => c.Region).Distinct();
            Console.WriteLine("洲有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

any，All查询

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };


            // Any All
            bool anyUSA = customers.Any(c => c.Country == "USA");
            if (anyUSA)
            {
                Console.WriteLine("有些人是美国的");
            }
            else
            {
                Console.WriteLine("没有美国的");
            }

            bool allAsia = customers.All(c => c.Region == "Asia");
            if (allAsia)
            {
                Console.WriteLine("全是亚洲的人");
            }
            else
            {
                Console.WriteLine("不全是亚洲的人");
            }

            Console.ReadLine();
        }
    }
}

多级排序

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               orderby c.Region,c.Country,c.City // 多级排序
                               select new {c.Region , c.Country, c.City };
            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

使用OrderBy，ThenBy实现

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            //var queryResults = from c in customers
            //                   orderby c.Region,c.Country,c.City // 多级排序
            //                   select new {c.Region , c.Country, c.City };
            var queryResults = customers.OrderBy(c => c.Region)
                .ThenBy(c => c.Country)
                .ThenBy(c => c.City)
                .Select(c => new { c.Region,c.Country, c.City});

            Console.WriteLine("亚洲的有:");
            foreach (Object item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

group的使用

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               group c by c.Region into cg
                               select new { TotalSales = cg.Sum(c => c.Sales),Region = cg.Key };

            var orderedResults =
                from cg in queryResults
                orderby cg.TotalSales descending
                select cg;


            foreach (var item in orderedResults)
            {
                Console.WriteLine(item.TotalSales+"\t:"+item.Region);
            }

            Console.ReadLine();
        }
    }
}

通过Take方法获取前几个数据
通过Skip方法，获取剩下的数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               group c by c.Region into cg
                               select new { TotalSales = cg.Sum(c => c.Sales),Region = cg.Key };

            var orderedResults =
                from cg in queryResults
                orderby cg.TotalSales descending
                select cg;

            // Take获取前几个数据
            // Skip获取后几个数据
            // 出去前1个后的数据
            foreach (var item in orderedResults.Skip(1))
            {
                Console.WriteLine(item.TotalSales + "\t:" + item.Region);
            }

            Console.WriteLine("----------------------------------------");

            // 前1个
            foreach (var item in orderedResults.Take(1))
            {
                Console.WriteLine(item.TotalSales + "\t:" + item.Region);
            }


            Console.ReadLine();
        }
    }
}

First与FirstOrDefault

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            var queryResults = from c in customers
                               group c by c.Region into cg
                               select new { TotalSales = cg.Sum(c => c.Sales),Region = cg.Key };

            var orderedResults =
                from cg in queryResults
                orderby cg.TotalSales descending
                select cg;

            // 获取第一个数据,First和FirstOrDefault
            // First方法如何数据不存在，会报错
            Console.WriteLine(orderedResults.First());

            Console.WriteLine(orderedResults.FirstOrDefault());

            Console.WriteLine(orderedResults.First(c => c.Region == "Europe"));

            Console.WriteLine(orderedResults.FirstOrDefault(c => c.Region == "Europe"));
            Console.ReadLine();
        }
    }
}

JOIN使用

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LinqDemo
{
    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
        public override string ToString()
        {
            return "ID:" + ID + " City:" + City + " Country:" + Country + " Region:" + Region + " Sales:" + Sales;
        }
    }

    class Order
    {
        public string ID { get; set; }
        public decimal Amount { get; set; }
    }

    class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = new List<Customer>
            {
                new Customer {ID="A",City="New York",Country="USA",Region="North America",Sales=999 },
                new Customer {ID="B",City="Bei Jing",Country="China",Region="Asia",Sales=1999 },
                new Customer {ID="C",City="Shang Hai",Country="China",Region="Asia",Sales=9999 },
                new Customer {ID="D",City="Tokyo",Country="Japan",Region="Asia",Sales=2999 },
                new Customer {ID="E",City="London",Country="England",Region="Europe",Sales=3999 }
            };

            List<Order> orders = new List<Order>
            {
                new LinqDemo.Order {ID = "A",Amount = 100 },
                new LinqDemo.Order {ID = "A",Amount = 200 },
                new LinqDemo.Order {ID = "B",Amount = 300 },
                new LinqDemo.Order {ID = "B",Amount = 400 },
                new LinqDemo.Order {ID = "C",Amount = 500 },
                new LinqDemo.Order {ID = "D",Amount = 600 },
            };

            var queryResults = from c in customers
                               join o in orders on c.ID equals o.ID
                               select new { c.ID,c.City,SalesBefore = c.Sales,NewOrder = o.Amount,SalesAfter = c.Sales + o.Amount };

            foreach (var item in queryResults)
            {
                Console.WriteLine(item);
            }

            Console.ReadLine();
        }
    }
}

本文转自TBHacker博客园博客，原文链接：http://www.cnblogs.com/jiqing9006/p/6849844.html，如需转载请自行联系原作者
weixin_33908217
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
新技术讲座LINQ复杂查询 （学习资料带例子）
12-28
新技术讲座LINQ复杂查询 （学习资料带例子） LINQ复杂查询 Linq
LINQ 标准查询操作符
10-29
LINQ（Language Integrated Query，语言集成查询）是.NET框架中的一种强大的数据查询工具，它允许开发者使用熟悉的C#或VB.NET语法对各种数据源进行查询。标准查询操作符是LINQ的核心组成部分，它们提供了一组预定义...
linq 复杂查询
weixin_30530339的博客
11-08 132
1、模糊查询 con.Users.Where(a =>a.UserName.Contains(name)).ToList(); //包含name con.Users.Where(a =>a.UserName.StartsWith(name)).ToList(); //以name开头 con.Users.Where(a =>a.UserName.EndsWith(name...
C# LINQ查询之对象
weixin_30673611的博客
05-18 129
LINQ是一组查询技术的统称，其主要思想是将各种查询功能直接集成到C#语言中，可以对 对象、XML文档、SQL数据库、外部应用程序等进行操作。 这里面讲的简单的几个子句， 必须以from子句开头，以select或group子句结尾。 例子： int [] nums={0,1,2,3,4,5}; var q = from n in nums // 表示查询数据的通用类型。 wher...
.NET：使用 LinqSharp 简化复杂查询
dotNET跨平台
03-06 375
LinqSharp是个开源LINQ扩展库，它允许您编写简单代码来生成复杂查询，包括查询扩展和动态查询生成。LinqSharp.EFCore是对EntityFramework的增...
C# Linq复杂一点的查询
Rand Tsui
03-30 1589
using System; using System.Collections.Generic; using System.Linq; namespace ConsoleApplication22 { class Program { public Student[] students { get; set; } public SC[] scs { g
LINQ查询语句与查询方法
最新发布
02-21
LINQ提供了一种统一的方式来处理和操作数据，使得代码更加简洁、可读性更强，并减少了手动编写复杂循环和条件语句的工作。 使用LINQ，你可以通过以下步骤实现对数据的查询和操作： 1. 定义数据源：可以是一个集合...
Linq 的基本查询
08-23
**Linq 基本查询概述** LINQ (Language Integrated Query)，即语言集成查询，是.NET框架中的一个重要特性，它允许开发人员使用统一的查询语法在各种数据源上执行查询，如集合、数据库、XML文档等。LINQ极大地方便了...
Linq动态查询、行转列
05-07
在.NET中，我们可以使用`DataTable`对象配合LINQ来实现这一转换。以下是一个简单的示例： ```csharp var groups = data.Table.AsEnumerable() .GroupBy(row => row.Field("Category")) .Select(group => new { ...
谜一样的LINQ查询
12-14
LINQ（Language Integrated Query，语言集成查询）旨在提供一种一致的查询体验，无论数据源是对象、XML、数据库还是其他数据结构。 **一、LINQ概念** 1. 引入LINQ是为了解决.NET框架中存在的一些挑战，例如： - **...
LINQ to DataSet实现复杂数据查询
kakaaa的专栏
02-25 1072
5.2 LINQ to DataSet实现复杂数据查询LINQ to DataSet将LINQ和ADO.NET集成，它通过ADO.NET获取数据，然后通过LINQ进行数据查询，从而实现对数据集进行非常复杂查询。本节将介绍如何使用LINQ to DataSet操作数据集DataSet中的数据。5.2.1 使用LINQ to DataSetLINQ to DataSet可以简单理解成通过LINQ对DataSet中保存的数据进行查询，它和第7章介绍的LINQ查询并没有太大的区别。LINQ to DataSet的使
精通LINQ －－8.1.2 复杂查询
04-20 1692
    8.1.1小节使用简单的LINQ查询表达式查询LinqDB数据库的UserInfo中的数据，且该查询中只涉及一个表（UserInfo），查询条件也相对简单。本小节介绍比较复杂的LINQ查询表达式，并在LINQ查询表达式使用join子句联接多个相关的表。下面的实例代码使用LINQ to SQL查询LinqDB数据库中的UserInfo、UserRole和Role表中的数据，并在查询中
谜一样的LINQ高级查询
dust__的博客
03-23 600
高级查询方法 聚合类 Count(),Max()/Min(),Average() 排序类 ThenBy() 分区类 Take(),TakeWhile(),Skip(),WkipWhile() 集合类 Distinct() 生成类 Range(),Repeat()
Linq 查询
海月的博客
09-07 318
Linq 探索 一开始，由于查询时，使用了GroupBy进行分组 查询结果是 IGrouping<bool,int> 类 得到了查询结果却不知道怎么使用 最后用了很复杂的方法才取出查询结果 using System.Collections; using System.Collections.Generic; using UnityEngine; //需要引用 using System.Linq; public class LinqTest : MonoBehaviour {.
复杂Linq语句写法
eNet
07-24 1616
从网上收藏的复杂Linq语句写法   1、case when： 原型： sql原型： SELECT ProductID, Name, Color,     CASE       WHEN Color = 'Red' THEN StandardCost       WHEN Color = 'Black' THEN StandardCost + 10       ELSE List...
LINQ查询对象集合
weixin_30256505的博客
07-01 180
此示例演示如何对一个 Student 对象列表执行简单查询。每个 Student 对象都包含一些有关该学生的基本信息，以及一个表示该学生的四次考试得分的列表。 此应用程序充当此部分中其他很多示例的框架，这些示例都使用相同的 students 数据源。 下面的查询返回那些在其第一次考试中得分为 85 分或更高的学生。 public class StudentClass ...
EF中使用linq进行关联查询
a713040869的博客
09-19 526
EF使用linq进行多表查询是完全可以的，最后ToList()调用的时候回产生一条分页的sql语句，所以并不是全部查询再分页的。所以不会影响查询的性能 public void TestLinq() { var a = from m in DbContext.Set<T1>() join q in DbContext.Set&...
LINQ查询操作符详解
LINQ（Language Integrated Query，语言集成查询）是.NET Framework 3.5及更高版本引入的一项特性，旨在简化和统一多种数据源的查询操作，包括数据库、XML、数组和对象集合等。通过LINQ，开发人员可以在C#或Visual ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值