Very simple C# CSV reader

Question

I'd like to create an array from a CSV file.

This is about as simple as you can imagine, the CSV file will only ever have one line and these values:

Device, SignalStrength, Location, Time, Age. 

I'd like to put these values into one dimensional array.

I've tried some examples but they've all been more complicated than required.

Answer 1

If there is only ever one line then do something like this:

using System; using System.IO;  class Program {     static void Main()     {         String[] values = File.ReadAllText(@"d:\test.csv").Split(',');     } } 

Answer 2

You can try the some thing like the below LINQ snippet.

string[] allLines = File.ReadAllLines(@"E:\Temp\data.csv");      var query = from line in allLines                 let data = line.Split(',')                 select new                 {                     Device = data[0],                     SignalStrength = data[1],                     Location = data[2],                      Time = data[3],                     Age = Convert.ToInt16(data[4])                 }; 

UPDATE: Over a period of time, things evolved. As of now, I would prefer to use this library http://www.aspnetperformance.com/post/LINQ-to-CSV-library.aspx