Is selecting column, filtering , sorting, paging is done in database or memory when use linq to sql?

[Ryan Liu]

Hi,

When use Linq to sql (e.g. though LinqDataSource), and enabling filtering,
sorting, paging, and specify what properties/columns are returned, then
underneath, is those functions are accomplisehd by generated sql inside
database, or LINQ still gets all columns and all rows into memory, and just
do selecting columns, paging, filtering, sorting in memory against entities?

Thanks a lot!
Ryan