LINQ query syntax must end with a Select or GroupBy clause
public class Student{
public int StudentID { get; set; }
public string StudentName { get; set; }
public int Age { get; set; }
}
IList<Student> studentList = new List<Student>() {
new Student() { StudentID = 1, StudentName = "John" },
new Student() { StudentID = 2, StudentName = "Moin" },
new Student() { StudentID = 3, StudentName = "Bill" },
new Student() { StudentID = 4, StudentName = "Ram" },
new Student() { StudentID = 5, StudentName = "Ron" }
};
//只是查询姓名
var selectResult = from s in studentList
select s.StudentName;
IList<Student> studentList = new List<Student>() {
new Student() { StudentID = 1, StudentName = "John", Age = 13 } ,
new Student() { StudentID = 2, StudentName = "Moin", Age = 21 } ,
new Student() { StudentID = 3, StudentName = "Bill", Age = 18 } ,
new Student() { StudentID = 4, StudentName = "Ram" , Age = 20 } ,
new Student() { StudentID = 5, StudentName = "Ron" , Age = 15 }
};
//这里面可以针对不同条件对数据做不同处理
// returns collection of anonymous objects with Name and Age property
var selectResult = from s in studentList
select new { Name = "Mr. " + s.StudentName, Age =s.Age==15?1:s.Age };
// iterate selectResult
foreach (var item in selectResult)
Console.WriteLine("Student Name: {0}, Age: {1}", item.Name, item.Age);
Take
, Skip
, TakeWhile
and SkipWhile
methods to partition the input sequence .You can get a slice of the input sequence as the output sequence.
The orderby
keyword, along with descending
, and the OrderBy
, ThenBy
, OrderbyDescending
and ThenByDescending
LINQ queries are used to sort data output.
The GroupBy
and into
operators organize a sequence into buckets.
这些操作符提供对多个集合的数据对比, 提供不同集合直接的交集,并集,不重复和差异的
转化成Array List Dictionary 或指定的元素类型
The methods First
, FirstOrDefault
, Last
, LastOrDefault
, and ElementAt
retrieve elements based on the position of that element in the sequence.
all any
count
原文:https://www.cnblogs.com/maanshancss/p/13086830.html