New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Results list seems to be limited to 1000 #3

Closed
devavejay opened this Issue Jul 12, 2012 · 8 comments

Comments

Projects
None yet
4 participants
@devavejay

devavejay commented Jul 12, 2012

Azure storage explorer limits the results to 2000, it would be nice to use continuation tokekens, get all the data back into a collection, then use the full linq syntax

@Pablissimo

This comment has been minimized.

Pablissimo commented Oct 8, 2013

I know this is really an old issue but - you can do this yourself by appending '.AsTableServiceQuery()' after any Where clauses and before you materialise the result. This'll let you get up to LinqPad's seemingly unavoidable 10,000 records limit with proper configuration, and lets the query run for an arbitrary amount of time as continuation tokens are used.

Example

Users.Where(x => x.EmailAddress == "user@example.com").AsTableServiceQuery().ToList()

Hope this might help someone else!

@madd0

This comment has been minimized.

Owner

madd0 commented Oct 14, 2013

Excellent, I was on vacation, but I will try to integrate this to the plugin this weekend.

@purplepangolin

This comment has been minimized.

purplepangolin commented Sep 29, 2014

Hello,

The latest version of the driver no longer allows the use of "AsTableServiceQuery" . Is there another workaround for this to avoid the 1000 items limit?

@madd0

This comment has been minimized.

Owner

madd0 commented Oct 1, 2014

Hi @purplepangolin,

Are you sure that the new version of the driver is not overcoming the limit on its own? I was pretty sure that upgrading to the newest Azure SDK would do that.

I also just wrote a quick sample where I inserted 1005 items to a table and iterated through them successfully printing 1005 items (or simply by writing Table1.ToList().Count).

@purplepangolin

This comment has been minimized.

purplepangolin commented Oct 13, 2014

Sorry for the late response, just seen your reply. I don't have the latest SDK installed (I have been explicitly asked not to install it), so that could be the issue. If I can get access to another test machine I'll give that a whirl.

@madd0

This comment has been minimized.

Owner

madd0 commented Oct 13, 2014

@purplepangolin you don't need to install anything; the driver has an embedded version of the SDK.

@purplepangolin

This comment has been minimized.

purplepangolin commented Oct 13, 2014

Ah, it appears to be an issue with linqpad and the Dump extension method printing the first 1000 rows by default. I hadn't realized that there is an option to expand to all results. Sorry for wasting your time.

@madd0

This comment has been minimized.

Owner

madd0 commented Oct 13, 2014

Not a problem 😉

@madd0 madd0 closed this Oct 13, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment