- List<Book> books = new List<Book>() {
- new Book { Id=1, Title="LINQ in Action" },
- new Book {Id=2, Title="LINQ for Fun" },
- new Book {Id=3, Title="LINQ Action Fun" },
- new Book {Id=4, Title="LINQ Action Fun1" },
- new Book {Id=5, Title="LINQ Action2 Fun" },
- new Book {Id=6, Title="LINQ Action3 Fun4" },
- new Book {Id=7, Title="LINQ Fun5" },
- new Book {Id=8, Title="LINQ Fun55" },
- new Book {Id=9, Title="LINQ Fun445" },
- new Book {Id=10, Title="Action Extreme LINQ" }
- };
- //模糊查询
- var titles = from book in books
- where book.Title.Contains("Action")
- orderby book.Id descending
- select book;
- foreach (var item in titles)
- {
- int id = item.Id;
- }
- //分页
- // Skip(100)代表跳过100行后.从第101行开始分页;
- // take(10)表示多少行分页;
- var pageInfos = titles.Skip(0).Take(2);
- foreach (var item in pageInfos)
- {
- int id = item.Id;
- }
转载于:https://blog.51cto.com/dingjq/775277