Linq
hhw199112
这个作者很懒,什么都没留下…
展开
-
java中的spring boot项目如何使用linq
java中的spring boot项目使用linq原创 2023-02-07 11:03:51 · 350 阅读 · 0 评论 -
根据stirng类型的进行Linq排序是否有效
var list = new List<Mitem>(); Mitem item = new Mitem(); item.id = "a"; item.Rank = "1"; list.Add(item); var item2 = new Mitem(); item2.id = "b"; item2.Rank = "12";...原创 2021-03-10 10:22:40 · 67 阅读 · 0 评论 -
Linq之多表查询
DBManager db = new DBManager(); DataTable dt = db.Query("select * from T_User"); DataTable dtUserInfo = db.Query("select * from t_userInfo"); var query...原创 2018-08-27 14:10:32 · 312 阅读 · 0 评论 -
Linq to DataTable之修改DataTable里的数据
DBManager db = new DBManager(); DataTable dt = db.Query("select * from t_User"); var query = from val in dt.AsEnumerable() select val; foreach (var ite...原创 2018-08-27 14:10:15 · 3054 阅读 · 0 评论 -
Linq小案例
using System.Linq;using System.Xml.Linq;using System.Data.Linq;想要调用Linq框架,至少要3.5或3.5以上的框架。 string[] arr = { "32323", "abc", "23dsdk", "dfs3223", "dsfjkk2" }; var query = from val in arr ...原创 2018-06-07 10:39:17 · 167 阅读 · 0 评论 -
Linq to ADO.NET简介
Console.WriteLine("修改数据前:"); YPTHDataContext ypth = new YPTHDataContext();//这个类是通过添加Linq to SQL文件产生的,然后通过服务器资源管理器将你需要的数据库文件拖到Linq to SQL文件上 var query2 = from val in ypth.T_Use...原创 2018-06-07 10:46:11 · 268 阅读 · 0 评论 -
Linq to SQL之增删查改
YPTHDataContext ypth = new YPTHDataContext(); var query = from val in ypth.T_User select val; foreach (var item in query) { Console.Wri...原创 2018-08-27 14:09:49 · 289 阅读 · 0 评论 -
Linq to XML详细介绍(一)
XElement xelement = new XElement("Student"); xelement.SetAttributeValue("Name", "jack"); xelement.SetAttributeValue("Age", 23); xelement.SetAttributeVa...原创 2018-08-27 14:09:34 · 1651 阅读 · 0 评论 -
Linq to XML新建XML
XElement element = new XElement("Student", new object[] { new XElement("Profile", new XElement[] ...原创 2018-08-27 14:09:03 · 119 阅读 · 0 评论 -
Linq to XML详细操作
XElement root = new XElement("root", new object[] { new XElement("Stu", new object[] ...原创 2018-06-22 23:28:27 · 160 阅读 · 0 评论 -
Linq to XML之添加结点
string xmlNewData = @" <ItemList> <item1/> <item3/> </ItemList> "; F...原创 2018-06-23 11:12:50 · 322 阅读 · 0 评论 -
Linq to XML增加节点(2)
string XmlData = @"<Root> <ItemList1> <item2/> <item3/> ...原创 2018-06-23 12:12:44 · 515 阅读 · 0 评论 -
两个集合的交集,并集,差集如何计算
string[] arr1 = { "445345", "fsdfsdf", "423423", "123" }; string[] arr2 = { "123", "Fsdfsdf", "3243", "324234" }; var query1 = arr1.Union(arr2);//两个集合的并原创 2018-06-02 12:07:35 · 5863 阅读 · 0 评论 -
Linq用法之Conact
string[] arr1 = { "Nice", "To", "Meet" }; string[] arr2 = { "You", "Mr.Bing" }; var query1 = arr1.Concat(arr2); foreach(string item in query1) { ...原创 2018-06-02 12:22:04 · 1950 阅读 · 0 评论 -
Linq的Distinct简介
string[] arr = { "23423", "1", "23", "23", "ABC", "abc" }; var query1 = arr.Distinct(); foreach (string item in query1) { Console.WriteLine(ite原创 2018-06-02 15:08:29 · 263 阅读 · 0 评论 -
Linq的求最大值,最小值,平均值以及求和方法简介
int[] arr = { 34, 43, 45, 565, 2, 54, 456, 65, 2, 3, 6, 43, 65, 34 }; var query1 = arr.Sum(); Console.WriteLine("Sum:" + query1); var query2 = arr.Max(); ...原创 2018-06-02 15:11:47 · 1534 阅读 · 0 评论 -
Linq to DataTable
DBManager db = new DBManager(); DataTable dt = db.Query("select * from T_User"); var query = from val in dt.AsEnumerable() select val; query = query.Wh...原创 2018-08-27 14:11:22 · 168 阅读 · 0 评论 -
Linq之交集,并集,差集介绍
int[] arr = { -32, 53, 5, -34, 56, 45, 34, 5, -34, 45, 2, 3, 6 }; int[] arr2 = { 53, 56 }; var query = arr.Union(arr2);//求并集,去重复 foreach (var item in q...原创 2018-08-27 14:11:34 · 1934 阅读 · 0 评论 -
Linq的求最大值,最小值,平均值以及求和方法简介2
string[] arr = { "fsdfd", "fsdf", "34534534", "45fgd232423", "3342gddvdff" }; var query1 = arr.Min(str => str.Length); Console.WriteLine(query1);//最短字符串长度 var qu..原创 2018-06-02 16:49:16 · 633 阅读 · 0 评论 -
LINQ之where查询
/*****LINQ where查询********/ int[] arr = { 32, 43, 345, 234, 543, 23, 543, 34, 65, 345 }; Console.WriteLine("所有元素"); foreach (var item in arr) { ...原创 2018-06-12 18:04:05 · 462 阅读 · 0 评论 -
Lambda的SingleOrDefault与Where方法详解
//Lambda,查询单个元素 int[] arr = { 234, 54, 34, 54, 34, 65, 345, 654, 3 }; Console.WriteLine("所有元素"); foreach (var item in arr) { Console.W...原创 2018-06-12 18:15:18 · 1125 阅读 · 0 评论 -
LINQ之JOIN的内部联接
YPTHDataContext ypth = new YPTHDataContext(); int[] arr1 = { 32, 43, 43, 54, 65, 76, 56, 434 }; int[] arr2 = { 3, 34, 23, 54, 65, 76, 65, 29, 402, 45 }; /**数据组内部连接...原创 2018-06-13 09:29:02 · 165 阅读 · 0 评论 -
Linq查询 group into
Student[] stuArray = { new Student("chandler",20,"男"), new Student("joe",39,"男"), new Student("rose",38,"男"),原创 2018-06-21 09:13:02 · 417 阅读 · 0 评论 -
Linq查询之多个排序条件
Student[] stuArray = { new Student("chandler",20,"男"), new Student("joe",39,"男"), new Student("rose",38,"男"),原创 2018-06-21 09:14:29 · 2777 阅读 · 0 评论 -
Linq两个from查询条件
int[] arr1 = { 32, 3, 432, 543, 23, 5, 634 }; int[] arr2 = { 64, 4, 8, 3, 3, 6, 23, 5, 2 }; var query1 = from val in arr1 from val2 in arr2 where val % val2 == 0 gr...原创 2018-06-21 09:29:11 · 1223 阅读 · 0 评论 -
Linq之分组联接
int[] arr1 = { 32, 3, 432, 543, 23, 5, 634 }; int[] arr2 = { 64, 4, 8, 3, 3, 6, 23, 5, 2 }; var query = from val in arr1 join val2 in arr2 on val equals val2 into t...原创 2018-06-21 09:56:23 · 417 阅读 · 0 评论 -
Linq之左联接
int[] arr1 = { 32, 3, 432, 543, 23, 5, 634 }; int[] arr2 = { 64, 4, 8, 3, 3, 6, 23, 5, 2 }; var query = from val in arr1 join val2 in arr2 on val equals val2 into t...原创 2018-06-21 10:02:16 · 132 阅读 · 0 评论 -
LINQ之group by详解
Student[] stuArry = { new Student("Jack",23,"男"), new Student("Wade",17,"男"), new Student("Lucy",18,"女"), new Student(&q原创 2018-06-13 15:50:33 · 3030 阅读 · 0 评论 -
Linq----lambda表达式之where and orderby
int[] arr = { -32, 53, 5, -34, 56, 45, 34, 5, -34, 45, 2, 3, 6 }; var query = arr.Where((num, index) => num > num * index); foreach (var item in query) ...原创 2018-06-21 12:06:26 · 2351 阅读 · 1 评论 -
Linq的Skip和SkipWhile详细介绍
int[] arr = { -32, 53, 5, -34, 56, 45, 34, 5, -34, 45, 2, 3, 6 }; var query = arr.Skip(5); Console.WriteLine("去除前五个"); foreach (var item in query) ...原创 2018-06-21 12:48:19 · 2839 阅读 · 0 评论 -
Linq之最大值,最小值,平均值,和值
int[] arr = { -32, 53, 5, -34, 56, 45, 34, 5, -34, 45, 2, 3, 6 }; var query = arr.Take(4); foreach (var item in query) { Console.Write(i...原创 2018-06-21 13:01:08 · 3383 阅读 · 0 评论 -
Linq之Distinct介绍
int[] arr = { -32, 53, 5, -34, 56, 45, 34, 5, -34, 45, 2, 3, 6 }; var query = arr.Distinct(); foreach (var item in query) { Console.Writ...原创 2018-06-21 13:11:01 · 159 阅读 · 0 评论 -
Linq之Concat介绍
int[] arr = { -32, 53, 5, -34, 56, 45, 34, 5, -34, 45, 2, 3, 6 }; int[] arr2 = { 53, 56 }; var query = arr.Concat(arr2); foreach (var item in query) ...原创 2018-06-21 13:14:05 · 4237 阅读 · 0 评论 -
Linq的简单调用
Linq的命名空间,using System.Linq;一定要引用。基本语法,from 自定义查询变量 in 查询源 select 自定义查询变量 List<string> listStr = new List<string>(); for (int i = 0; i < 30; i++) {...原创 2018-05-17 07:04:51 · 223 阅读 · 0 评论