.net CsvHelper 2.0

 

http://joshclose.github.io/CsvHelper/

            var fs = new FileStream(outputmatchPath, FileMode.Open, FileAccess.Read);
            var contentReader = new StreamReader(fs, Encoding.GetEncoding("gb2312"));

            //TextReader contentReader = File.OpenText(outputmatchPath);

            //var a=contentReader.ReadToEnd();

            var matchCsv = new CsvReader(contentReader);

 

var outputmatchPath = System.Configuration.ConfigurationManager.AppSettings["//FilePath"];

TextReader requiredMatchElementsfileReader = File.OpenText(outputmatchPath);

 

 

var matchCsv = new CsvReader(requiredMatchElementsfileReader);

 

 

matchCsv.Configuration.RegisterClassMap<RequiredMatchElementsMap>();
var requiredMatchList = matchCsv.GetRecords<RequiredMatchElements>().ToList();

 

 

    public class RequiredMatchElements
    {
        public int IngredientId { set; get; }


        public string IngredientName { set; get; }


        public string RequriedElementsString { set; get; }
    }


    public class RequiredMatchElementsMap : CsvClassMap<RequiredMatchElements>
    {
        public override void CreateMap()
        {
            Map(m => m.IngredientId).Name("IngredientId");
            Map(m => m.IngredientName).Name("IngredientName");
            Map(m => m.RequriedElementsString).Name("RequriedElementsString");
        }


    }

 

Write

var dateList = new List<OutputTopTags>();
            dateList.Add(new OutputTopTags() { Count = 1, Matched = 1, TagName = "test" });
            dateList.Add(new OutputTopTags() { Count = 2, Matched = 0, TagName = "test1" });
            using (TextWriter streamWriter =
            new StreamWriter(HttpContext.Current.Server.MapPath("/App_Data/Top5000Instagram.csv")))
            {


                var csv = new CsvWriter(streamWriter);
                csv.WriteRecords(dateList);
            }