Linq to Entities Skip() and Take()

asp.net c# entity-framework linq linq-to-entities

Question

I am working on an ASP.NET application and I am creating a LINQ query which will select paginated records from db. on user interface I have a listbox where user can select multiple choices. I want to know:

  • How can I increment Skip(), Take() parameters to view next results ?

  • How can I use "IN" key word so that if user selects multiple options from listbox, query can check all values ?

My query looks like this:

var searchResults = context.data_vault.Where(d => d.STATE == lstStates.SelectedItem.Text).OrderBy(d= > d.dv_id).Take(10).Skip(2);    
GridView1.DataSource = searchResults;
GridView1.DataBind();
1
8
6/8/2012 2:08:12 PM

Popular Answer

I think you are using Skip incorrectly. It should be before the Take.

Skip skips a number of records, so for your first page, pass in 0, else pass in the (page number - 1) * records per page.

I usually do something like this:

int Page = 1;
int RecordsPerPage = 10;
var q = yourQuery.Skip((Page - 1) * RecordsPerPage).Take(RecordsPerPage);
20
6/8/2012 2:13:46 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow