CsvReader or CsvDataReader

[Guest]

Is there really a CsvReader or CsvDateReader class in .net 2.0
I can't find any documentation.
There was a post somewhere mentioning how efficient it is and how it takes
memory only to read in one record and how validations can be done before
copying it to SQL Server.
Is this all true?? Where is the class in MSDN then?

 

[Karl Seguin [MVP]]

Not part of the .NET framework, maybe they were refering to
http://www.csvreader.com/ which actually appears to be a commercial
application - not sure why you'd pay for this functionality.

Karl

 

[DKode]

that guys csvreader is actually very effecient, he just added some
functionality that speeds it up to DTS speeds when importing a csv
directly to sql

 

[Guest]

so in that case, what do you think would be the best way to read a csv
containing thousands of records...validating those records and transferring
them to a SQL Server database??
I mean ...use a streamreader then a dataset or anything else??