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 Query

More Query from same tag