Anonymous type values in grid view

BandiG

I would like to create a csv file and used an ArrayList of anonymous types to get the best results.
Dumping the results works fine in the Rich Text view but when I switch to grid view (to see past a 1000 results) then I see one column named "Value" and each row in an "Anonymous" link to the real values. What happened to the real data that shows fine in the Rich Text view?

Tormod

I was pretty sure LINQPad beta had a DumpCsv() method. But now I can't find it.
You can set the max number of lines in edit->preferences.

BandiG

It seems as the maximum maximum is 10000 lines.
And I've noticed that the resolving of anonymous types in grid view stops somewhere above 540000 lines.

I know that it would be much better to generate this right into csv but I was too lazy to look up the right method. Now it seems I'll really have to resort to the proper solution.

JoeAlbahari

Use Util.WriteCsv:

Util.WriteCsv (myData, @"c:\temp\foo.csv");

BandiG

Excellent, my last problem was that I used ArrayList with anonymous types out of laziness, but I converted it to List with ExpandoObjects inside that I cast into anonymous types with a select for the WriteCsv to work. This way I can keep the script as C# statements as I don't have to define a struct. (having said that I could have used tuples but this is much nicer as it has property names)

Thanks!

JoeAlbahari

Great. Regarding the incorrect rendering of an ArrayList of anonymous types, I cannot reproduce this. The following renders fine for me in both rich text and data grids mode:

new ArrayList (new[] 
{
	new { X = 1, Y = 2 },
	new { X = 1, Y = 2 }
})

BandiG

As I said it only happens with very large lists. Try this:

var list = new ArrayList();
for (int i = 0; i < 600000; i++)
{
  list.Add( new { X=1, Y=2});
}
list.Dump();

It does work with 500000 but not with 600000 (in data grid mode).
I of course realise that it was probably not meant for this...

JoeAlbahari

FYI, I've fixed the latest beta so you'll always get proper columns in grid mode, regardless of result set size.