Jump to content


Photo
- - - - -

How To Return More Than 1000 Rows


  • Please log in to reply
7 replies to this topic

#1 Brian Chappell

Brian Chappell

    New Member

  • Members
  • Pip
  • 1 posts

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

#2 JoeAlbahari

JoeAlbahari

    Super Veteran Member

  • Members
  • PipPipPipPipPipPipPipPipPipPipPip
  • 529 posts
  • 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


#3 Terry Aney

Terry Aney

    Active Member

  • Members
  • PipPip
  • 19 posts

Posted 03 December 2008 - 10:46 PM

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

Hope it helps.

#4 JoeAlbahari

JoeAlbahari

    Super Veteran Member

  • Members
  • PipPipPipPipPipPipPipPipPipPipPip
  • 529 posts
  • 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

Edited by Joseph Albahari, 05 December 2008 - 04:00 AM.


#5 mbz13

mbz13

    New Member

  • Members
  • Pip
  • 1 posts

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


#6 CFQüeb

CFQüeb

    New Member

  • Members
  • Pip
  • 1 posts

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

#7 JoeAlbahari

JoeAlbahari

    Super Veteran Member

  • Members
  • PipPipPipPipPipPipPipPipPipPipPip
  • 529 posts
  • 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

#8 davidsflys

davidsflys

    New Member

  • Members
  • Pip
  • 2 posts

Posted 12 December 2013 - 09:19 AM

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 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users