Import CSV


Assume that you have an plain text, old Comma Separated Values file filled with your precious export from a legacy system. How can you process it easily now? The first answer that is worth considering is parse it to LINQ, the language-integrated query, which is a collection of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations.

Import CSV file and query it with LINQ