score:1

Accepted answer

You can set the DataContext CommandTimeout Property

http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.commandtimeout.aspx

And out of curiosity, why do you have

var resultList = result.Skip((pageNumber - 1) * pageSize)
                           .Take(pageSize).ToList();

    return new List<Stat>(resultList);

and not

List<Stat> resultList = result.Skip((pageNumber - 1) * pageSize)
                           .Take(pageSize).ToList();

    return resultList ;

Related Articles