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 ;
Source: stackoverflow.com
Related Query
- IQueryable command timeout
- How to set Nhibernate LINQ Command Timeout using Session.Query
- Execute expression on another IQueryable source
- LINQ Source Code Available
- .NET 4 Code Contracts: "requires unproven: source != null"
- Unit testing code using IQueryable
- creating Linq to sqlite dbml from DbLinq source code
- Increase SQL Command Timeout when making call through LINQ Mapping
- Cannot build the Test project for LINQ IQueryable Toolkit (IQToolkit) - Code 9009
- source code for LINQ 101 samples
- LINQ where clause using Generic IQueryable source
- List or Array of String Contain specific word in Html Source Code
- IQueryable two tables from Code First Entity Framework
- c# Linq or code to extract groups from a single list of source data
- LinqDataSource: How to assign IQueryable value to where parameters in code
- ToPagedListAsync() - The provider for the source IQueryable doesn't implement IDbAsyncQueryProvider
- Entity Framework: There is already an open DataReader associated with this Command
- Convert string[] to int[] in one line of code using LINQ
- Using IQueryable with Linq
- Code equivalent to the 'let' keyword in chained LINQ extension method calls
- Value cannot be null. Parameter name: source
- What's the difference between IQueryable and IEnumerable
- Linq code to select one item
- C# - code to order by a property using the property name as a string
- How do I find the text within a div in the source of a web page using C#
- Roslyn failed to compile code
- How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
- Instantiate empty IQueryable for use with Linq to sql
- Entity-framework code is slow when using Include() many times
- The data source does not support server-side data paging
More Query from same tag
- Converting nested loop to LINQ statement
- Why are the data in the database not filtered?
- Finding the maximum valued and different typed items in an object list by using Linq
- WCF to Database Connectivity
- Find the number of pairs in an array whose difference is K?
- View my value in the top and the rest by
- EF5 Convert Returned List<string> to its Proper Type
- Properties stuck one level down
- Linq Where clause with two conditions, not working
- Linq and Cross Products
- boolean Contains does not support conversion to SQL
- FirstOrDefault two ways
- Return anonymous type from LINQ query?
- xml XDocument Save modify file
- C# Linq Query with foreign Key relationship
- Checking if a string is NOT part of an Array (C#, Linq)
- SQL query for product combination
- C# - XPath-Question: How to get Nodes under a specified parent-node?
- Convert code that uses Linq to code that does not
- Updating List<string> values using linq C#
- Confusion over storing a type in a temp variable in a LINQ query
- SQL Linq Many To Many
- I want to Make a function that get product distinct customers names
- How to write generic Entity name in constructor in EF4?
- How to populate collection object using left join without duplicates in Linq
- LINQ to SQL dividing filters for better performance
- vb.net datatable asenumerble get distinct vlues and count grouped duplicate rows
- StackOverflowException on nested query, small item count
- converting ms sql "group by" query to linq to sql
- Need to select multiple columns in Entity Framework, but need to get only distinct on single column