Linq to SQL - Returning two values with one query

Question

Is it possible to return a single value and an enumerable collection using LINQ to SQL?

The problem is, I'm trying to do paging across a large recordset. I only want to return 10 rows at a time so I'm using .Skip(20).Take(10) approach.

However I need to know the total number of records so I can show an appropriate page x of y.

Trying to avoid two separate queries.

Thanks

Klaus Byskov Pedersen · Accepted Answer · 2010-03-26 11:51:40Z

4

Don't be afraid of queries. Do both.

answered Mar 26, 2010 at 11:51

122k31 gold badges192 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I'm worried that the page count might change between the two queries. Things might look a bit odd.

@Sir Psycho: Then use a TransactionScope.

Nick Allen · Accepted Answer · 2010-03-26 11:51:48Z

1

I came across this exact same issue and ended up with

var q = from i in tableName select i;

int total = q.Count();

foreach(var obj in q.Skip(20).Take(10))
{
    ...
}

It really wasn't a problem at all

answered Mar 26, 2010 at 11:51

Nick Allen

12.3k11 gold badges49 silver badges61 bronze badges

That is fine, but it executes two queries. Therefore my answer below.