Get,Set using Lists in C# ...Help Needed

See more:

C#

Hey Guys,

I need to read a CSV file in C# and drop the data into a list and then dump the data to a SQL Database database... The class im interested using is using CsvHelper;

This is two sample data in the CSV File:

1,2013-05-14,NISSAN,059 7013,1995,VAN,Deisel,NISSAN,0000,NISSAN,Red,MARADANA,op1,description,p1.jpg+p2.jpg+p3.jpg,r1+r2+r3

2,2013-05-14,NISSAN2,059-7013,1995,VAN,Deisel,NISSAN,0000,NISSAN,Red,MARADANA,op1,description,p1.jpg+p2.jpg+p3.jpg,r1+r2+r3

This is the class for the CSV file

class Vehicle
    {
        public int ID { get; set; }
        public string ClosingDate { get; set; }
        public string Model { get; set; }
        public string Reg { get; set; }
        public string YearOfManufacture { get; set; }
        public string VehicleType { get; set; }
        public string Fuel { get; set; }
        public string Brand { get; set; }
        public string Mileage { get; set; }
        public string Make { get; set; }
        public string Colour { get; set; }
        public string VehicleYard { get; set; }
        public string BasicOptions { get; set; }
        public string Description { get; set; }
        public List<string> Photos { get; set; }
        public List<string> Regions { get; set; }
    }

I tried and Read the CSV file using this code:

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            CsvHelperRead();

            Console.Read();
        }

        private static void CsvHelperRead()
        {

            CsvConfiguration config = new CsvConfiguration();
            config.HasHeaderRecord = false;

            using (var reader = new CsvReader(new StreamReader(@"C:\Users\afshandc\Desktop\0729\vTest.csv"), config))
            {
                while (reader.Read())
                {
                    Console.WriteLine(reader.GetField(1));
                }
            }
        }
    }
}

I Need to Read the CSV File and Drop it to this list, Any HElp Help Will be appriciated!Thanks!

class CSV
   {
       public List<Vehicle> ReadVechileCSV()
       {







       }
   }