CSV to object model mapping

by

For the specific data shown in your question…

var yourData = File.ReadAllLines("yourFile.csv")
                   .Skip(1)
                   .Select(x => x.Split(','))
                   .Select(x => new
                                {
                                    Plant = x[0],
                                    Material = x[1],
                                    Density = double.Parse(x[2]),
                                    StorageLocation = int.Parse(x[3])
                                });

If you already have a type declared for your data then you can use that rather than the anonymous type.

Note that this code isn’t robust at all. It won’t correctly handle values containing commas/newlines etc, quoted string values, or any of the other esoteric stuff that is often found in CSV files.

More Related Contents:

  1. How to have nested query with LINQ
  2. Read a CSV to a C# object to be able to do LINQ query on it [closed]
  3. Lambda statement for finding sub-string in a string from list of strings [closed]
  4. Fluent and Query Expression — Is there any benefit(s) of one over other?
  5. ‘Contains()’ workaround using Linq to Entities?
  6. linq case statement
  7. XDocument containing namespaces
  8. Use own IComparer with Linq OrderBy
  9. C#, regular expressions : how to parse comma-separated values, where some values might be quoted strings themselves containing commas
  10. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  11. How to convert list of arrays into a multidimensional array
  12. How to use the IEqualityComparer
  13. What is the effect of AsEnumerable() on a LINQ Entity?
  14. Understanding .AsEnumerable() in LINQ to SQL
  15. Updating an item property within IEnumerable but the property doesn’t stay set?
  16. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  17. An expression tree lambda may not contain a null propagating operator
  18. LINQ aggregate and group by periods of time
  19. VB.NET equivalent to C# var keyword [duplicate]
  20. NHibernate How do I query against an IList property?
  21. Create Items from 3 collections using Linq
  22. How to get duplicate items from a list using LINQ? [duplicate]
  23. Max or Default?
  24. How do I do a left outer join with Dynamic Linq?
  25. LINQ performance FAQ
  26. How to group by DateTime.Date in EntityFramework
  27. How to convert DataTable to class Object?
  28. Accessing System Databases/Tables using LINQ to SQL?
  29. How to merge two lists using LINQ?
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment