Linqpad result limitation of 10000 rows

Question

How do i increase the limitation of 10000 rows in linqpad to get more result rows. My query returns approximately 45000 rows. I tried editing the RoamingUserOptions.xml but the changes are reverted back to original state. Also used the Results to data grid option but no luck. Can anyone help me out??

Answer 1

As Cory pointed out, in "Results to Grid" mode, LINQPad will give you all rows - or throw an OutOfMemoryException.

The most likely reason for getting fewer is that the OData server is configured with a limit on how many it will return per query.