O'Reilly Forums: How To Return More Than 1000 Rows - O'Reilly Forums
Page 1 of 1
How To Return More Than 1000 Rows
Posted 06 June 2008 - 02:00 AM
Firstly, awesome tool. I'm taking the challenge and using your tool instead of Management Studio and it really is working, I'm creating Linq now that I wouldn't have even known where to start a few days ago.
I have hit a stumbling block, I need to extract some data for a colleague and can only return the first 1000 records. I'm sure there's something I've missed with regard to the Dump extension but I can't find what. Help!
Posted 06 June 2008 - 02:30 AM
This is currently a limitation of LINQPad. It uses a web browser to display results exported using LINQ to XML, which imposes practical limits on the output size. If you want to export all the data to some other file or format, you can either include the C# code to do that in your query, or write a custom extension method to do the same. Press F4 to add the reference to the custom DLL & namespace, then click 'Set as default for new queries'.
The other option is that I could modify LINQPad to use dynamically generated WPF elements to display content. This would remove the result size limitation, but would make copying/pasting troublesome!
Posted 05 December 2008 - 03:57 AM
Just so readers know, the library described in that article has some other useful extensions, too:
Definitely worth checking out!
This post has been edited by Joseph Albahari: 05 December 2008 - 04:00 AM
Posted 01 December 2010 - 07:42 AM
I know this thread is a little dated, but it came up when I was looking for a solution to this problem. It turns out in the latest and greatest version on linqpad (4.26 and I do mean GREATEST!!!) there is an option under edit/preferences/results that allows you to make the result set larger than the 1000 row default.
Warning it is resource intensive but worth it if you dont want to have to copy and paste the generated sql into management studio and run it there
Posted 17 January 2012 - 06:50 AM
Yes.. this limitation is my first disappoint with this amazing tool. Maybe some configuration to allows the developer preserve the limitation to 1000 records or get all records. Maybe will be a great idea include the extension for CVS files into LinQPad.
Share this topic:
Page 1 of 1
1 User(s) are reading this topic