SQL Query to csv file in C#

I had a handy method to take a query result (geez, I can't even remember
what the object was called) and write it directly to a CSV file in VB6 (some
of the queries I have to write have a lot of records and if I don't have to
loop through them to write them to a file, I think things will be much
faster).

I have been searching for a similar sample in C# for Net 2.0 and I'm not
having much luck.  I was even hoping I might do it with a method that is
part of one of the SQL data objects in NET.

Any easy solution for this?

Peter

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com