LINQ 實現常見SQL查詢

 

1.Top 查詢－－－－skip(index).Take(count)

  var Results = from dt in ctx.Customers.Skip(0).Take(10)
                          select new
                          ...{
                              dt.CustomerID,
                              dt.CompanyName,
                              dt.City
                          };

2.Like 查詢－－－－startwith()
           from dt in ctx.Customers
           where dt.ID.Startwith('A')

3.In查詢－－－－Contain()
  string[] s = ...{ "ivan","aaa","aaaa"};
            var Results = from dt in ctx.Customers.Skip(0).Take(10)
                          where s.Contains(dt.CustomerID)
                          select new
                          ...{
                              dt.CustomerID,
                              dt.CompanyName,
                              dt.City
                          };