[Brian Chappell]

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

[JoeAlbahari]

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

[Terry Aney]

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

Hope it helps.

[JoeAlbahari]

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

[mbz13]

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

[CFQüeb]

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

[JoeAlbahari]

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

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

Joe