Using Linq to aggregate from array to single var

Question

I have an accordion that binds data for each item from an array. I want that for every time that I bound the data I will loop through all of the array and aggregate all of the items with the same id and create a long string with a name from a cell. In the code the name oneJob.order_id does not exist and I don't know why.

protected string GetAllProffesions(int orderID)
{
    IEnumerable<string> allProf;
    orderID = 544;
    Job[] curItems = null;
    curItems = JobManager.GetJobs(RangeID, GetParam());
    allProf = from oneJob in curItems
              where oneJob.order_id == orderID
              select oneJob.profession_name;

    return Convert.ToString(allProf);
}

Does your Job class has order_id field ? You can use String.Join to join a string — Habib
– Habib, Commented Jun 11, 2012 at 8:43
Just to be sure: Has your "Job"-class a property or field named "order_id" that is accessible from this method? — Ral Zarek
– Ral Zarek, Commented Jun 11, 2012 at 8:44
Where does the Job come from? Is it a manually created class or a product of an ORM (LINQ to SQL or Entity Framework or NHibernate etc.)? — Branko Dimitrijevic
– Branko Dimitrijevic, Commented Jun 11, 2012 at 8:45
Yes Job has order_id and it was created earlier,once i press "." it gives all the proprieties that i have in Job. Job is manually created in the program. — Danny
– Danny, Commented Jun 11, 2012 at 13:29

Jakub Konecki · Accepted Answer · 2012-06-11 08:44:48Z

1

This is because your job class doesn't have a property called order_id. Check your spelling.

Also, you probably don't want to do Convert.ToString(allProf), as I expect this will give you the type name instead of all the professions concatenated. Try this instead:

string.Join(", ", allProf.ToArray());

answered Jun 11, 2012 at 8:44

Jakub Konecki

46.1k8 gold badges92 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Linq to aggregate from array to single var

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related