O'Reilly Community

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

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

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

Hope it helps.

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: Dec 5 2008, 04:00 AM