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

Discussion in 'ASP .Net Web Controls' started by Ryan Liu, Dec 12, 2008.

  1. Ryan Liu

    Ryan Liu Guest


    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 Liu, Dec 12, 2008
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.