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