I haven't used the LINQ To CSV library, but the idea of using LINQ to query CSV Files is a pretty cool idea.
There is a LINQ To CSV Library on CodeProject that offers a number of really cool features for using LINQ To query CSV Files:
- Follows the most common rules for CSV files. Correctly handles data fields that contain commas and line breaks.
- In addition to comma, most delimiting characters can be used, including tab for tab delimited fields.
- Can be used with an IEnumarable of an anonymous class - which is often returned by a LINQ query.
- Supports deferred reading.
- Supports processing files with international date and number formats.
- Supports different character encodings if you need them.
- Recognizes a wide variety of date and number formats when reading files.
- Provides fine control of date and number formats when writing files.
- Robust error handling, allowing you to quickly find and fix problems in large input files.
Check it out.