In the Results pane, the object is listed with (First 1000 items). When using the export function, Linqpad only exports this first 1000 items. Is there any way to configure it to export all results?
Click the toolbar button 'Results to Data Grids'. Then there will be no limit on the number of rows returned. Right-click the grid to export.