O'Reilly Forums: How To Return More Than 1000 Rows - O'Reilly Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

How To Return More Than 1000 Rows Rate Topic: -----

#1 User is offline   Brian Chappell 

  • New Member
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 06-June 08

Posted 06 June 2008 - 02:00 AM

Hi Joe,

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!

Regards,
Brian
0

#2 User is offline   JoeAlbahari 

  • Super Veteran Member
  • PipPipPipPipPipPipPipPipPipPipPip
  • Group: Members
  • Posts: 529
  • Joined: 15-February 08
  • Gender:Male
  • Location:Perth, Australia

Posted 06 June 2008 - 02:30 AM

Hi Brian

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!

Regards
Joe

0

#3 User is offline   Terry Aney 

  • Active Member
  • PipPip
  • Group: Members
  • Posts: 19
  • Joined: 25-March 08

Posted 03 December 2008 - 10:46 PM

Please see my article for a possible Dump To CSV solution.

Hope it helps.
0

#4 User is offline   JoeAlbahari 

  • Super Veteran Member
  • PipPipPipPipPipPipPipPipPipPipPip
  • Group: Members
  • Posts: 529
  • Joined: 15-February 08
  • Gender:Male
  • Location:Perth, Australia

Posted 05 December 2008 - 03:57 AM

Just so readers know, the library described in that article has some other useful extensions, too:

  • LINQ-predicated updates
  • Pastable SQL translations
  • Batched LINQ to SQL queries


Definitely worth checking out!

Joe

This post has been edited by Joseph Albahari: 05 December 2008 - 04:00 AM

0

#5 User is offline   mbz13 

  • New Member
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 01-December 10

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

0

#6 User is offline   CFQüeb 

  • New Member
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 14-January 12

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.

Thank you
0

#7 User is offline   JoeAlbahari 

  • Super Veteran Member
  • PipPipPipPipPipPipPipPipPipPipPip
  • Group: Members
  • Posts: 529
  • Joined: 15-February 08
  • Gender:Male
  • Location:Perth, Australia

Posted 17 January 2012 - 11:42 PM

Download the latest beta:
www.linqpad.net/beta.aspx

Then click the 'Output to grids' button. This lets you dump without limit.

Joe
0

#8 User is offline   davidsflys 

  • New Member
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 12-December 13

Posted 12 December 2013 - 09:19 AM

View PostJoeAlbahari, on 17 January 2012 - 11:42 PM, said:

Download the latest beta:
www.linqpad.net/beta.aspx

Then click the 'Output to grids' button. This lets you dump without limit.

Joe


This is a great inspiring. I am pretty much pleased with your good work. You put really very helpful information. Looking to reading your next post.
judi bola , wap ibcbet , akun sbobet
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users