学步园

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;
        }