radgrid and custompaging using linqdatasource

[Raj]

HI, in your demos you have needdatasource and objectdatasource version of custom paging.  I need to use LinqDatasource and implement custom paging.  I have been trying it but with no lock.  can you pl advice.  thx

[Radoslav]

Hi Raj,

To achieve the desired functionality you could try using the following code snippet:

protected void linqDS_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
    // LINQ query
    var query = from c in myDC.Class
                select c;

    // Set the total count
    e.Arguments.TotalRowCount = query.Count();

    // Get only the rows we need for the page requested
    query = query.Skip(RadGrid1.CurrentPageIndex * PAGE_SIZE).Take(PAGE_SIZE);

    e.Result = query;
}

I hope this helps.

Regards,
Radoslav
the Telerik team

[John]

ISome detailed explanation for ...

// LINQ query
    var query = from c in myDC.Class
                select c; 

 

... would be much appreciated.  Thanks.

[Radoslav]

Hello John,

This is a standard linq to sql select query where myDC is the context and the Class is the entity. More information you can find here:
https://msdn.microsoft.com/en-us/library/bb308959.aspx
https://msdn.microsoft.com/en-us/library/bb425822.aspx
https://msdn.microsoft.com/en-us/library/bb397947.aspx

I hope this helps.

Regards,
Radoslav
Telerik