LINQ基础篇（下）

分页 Skip Take

var query = DataSource.Skip((PageNo-1)*PageSize).Take(PageSize).ToList();

Skip 跳过多少个元素

Take取出多少个元素

SkipWhile 逐一判断直到不满足条件，将该元素及其后的元素取出

TakeWhile 逐一判断取出满足条件的元素

 

Except

语法 a.Except(b)

作用 a中去除b中元素后剩余部分

            List<string> strListA = new List<string> { "Hello","World","C#","JavaScript","Animal"};
            List<string> strListB = new List<string> { "Hello", "Person", "History", "Furion", "Animal" };
            var exceptValue = strListA.Except(strListB);
            foreach (var item in exceptValue)
            {
                Console.WriteLine(item);
            }
            Console.ReadKey();    

 

Concat

语法 a.Concat(b)

作用 合并a和b中的元素，不去除重复

            List<string> strListA = new List<string> { "Hello","World","C#","JavaScript","Animal"};
            List<string> strListB = new List<string> { "Hello", "Person", "History", "Furion", "Animal" };
            var concatValue = strListA.Concat(strListB);
            foreach (var item in concatValue)
            {
                Console.WriteLine(item);
            }
            Console.ReadKey();

 

Union

语法 a.Union(b)

作用 合并a和b中的元素，去除重复

 

            List<string> strListA = new List<string> { "Hello","World","C#","JavaScript","Animal"};
            List<string> strListB = new List<string> { "Hello", "Person", "History", "Furion", "Animal" };
            var unionValue = strListA.Concat(strListB);
            foreach (var item in unionValue)
            {
                Console.WriteLine(item);
            }
            Console.ReadKey();

Intersect

语法 a.Intersect(b)

作用 求a和b的交集

 

            List<string> strListA = new List<string> { "Hello","World","C#","JavaScript","Animal"};
            List<string> strListB = new List<string> { "Hello", "Person", "History", "Furion", "Animal" };
            var intersectValue = strListA.Intersect(strListB);
            foreach (var item in intersectValue)
            {
                Console.WriteLine(item);
            }
            Console.ReadKey();

Contains

语法 a.Contains(b)

作用 类似 like ‘%b%’

            List<string> strListA = new List<string> { "Hello","World","C#","JavaScript","Animal"};
            List<string> strListB = new List<string> { "Hello", "Person", "History", "Furion", "Animal" };
            var containsValue = from s in strListA where s.Contains("l") select s;
            foreach (var item in containsValue)
            {
                Console.WriteLine(item);
            }
            Console.ReadKey();