How to have nested query with LINQ

by

This line:

var csvLinesData = csvlines.Skip(1).Select(l => l.Split(',').ToArray());

produces an IEnumerble<string[]>. When you select it, you can access the columns of your CSV, as you do in this line:

CSRName = data[12],

The problem with this line:

csvLinesData.Count(w => w.direction='I')

is that an element of csvLinesData is a string[] which doesn’t have a direction field or property.

Anyhow, it looks strange that you count all the lines with a specific property, because it would result in the same number for every “user”.

Because I don’t know what you actually want to do (I can’t even guess), I cannot tell you what to do.

Edit, based on new section in the question:

You cannot assign an integer to a string:

Incomming = csvLinesData.Count(w => w[4] == "I"),

Either change the property Incomming to an integer or create a string from the number (Which is probably not what you need):

Incomming = csvLinesData.Count(w => w[4] == "I").ToString(),

By the way, it still cannot work, because you count all the lines where column 5 == "I", which leads to the same number for each user. Your example has a different number in each line (but the same user name). This is very confusing. You really have to think about what you actually want to do and either explain it clearly or provide some example data.

More Related Contents:

  1. Read a CSV to a C# object to be able to do LINQ query on it [closed]
  2. CSV to object model mapping
  3. Prevent duplicates from array, based on condition [closed]
  4. Where is likely the performance bug here? [closed]
  5. How to LINQ List and flatten it using SelectMany?
  6. LINQ – Full Outer Join
  7. Dynamic where clause (OR) in Linq to Entities
  8. Paging with LINQ for objects
  9. Pivot data using LINQ
  10. Using Linq to get the last N elements of a collection?
  11. Optimal LINQ query to get a random sub collection – Shuffle
  12. Searching a tree using LINQ
  13. How can I get LINQ to return the object which has the max value for a given property? [duplicate]
  14. Recursive Hierarchy – Recursive Query using Linq
  15. Filter/Search using Multiple Fields – ASP.NET MVC
  16. Operation could destabilize the runtime?
  17. How to select only the records with the highest date in LINQ
  18. Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
  19. C# Linq intersect/except with one part of object
  20. Entity-framework code is slow when using Include() many times
  21. The operation cannot be completed because the DbContext has been disposed using MVC 4
  22. Linq to Objects – return pairs of numbers from list of numbers
  23. From Eric Lippert’s blog: “don’t close over the loop variable” [duplicate]
  24. Export Model to DataTable
  25. loading a full hierarchy from a self referencing table with EntityFramework.Core
  26. Max return value if empty query
  27. Sort one list by another
  28. Get sum of two columns in one LINQ query
  29. Add the where clause dynamically in Entity Framework
  30. Split a List into groups of consecutive numbers [closed]

Leave a Comment