Out Of Memory Exception on DataAdapter.Fill(Dataset)

[Pho3nix]

See how it goes. I used to use select * and stopped a while back, I think for similar reasons to yours can't remember but something bad happened along the way. Now even if I do need all the columns I specify each one.

Tried an no dice..

 

[Pho3nix]

Managed to do this, using an ORM (PetaPoco) was step 1 and needed to change project to x64 which cause some other issues but a smaller headache.
Thanks to all.

Solution still takes 3gb's when running on my local machine :wtf: but it working is a start. Optimizations will be sorted in the next sprint.