LINQ result set passing into other method

Question

var result = datatable.AsEnumerable()
                  .GroupBy(row=>row.Field<DateTime>("Date"))
                  .Select(gr=>new 
                  {
                      Date = gr.Key,
                      Agents = gr.Select(x => new 
                      {
                          Id = x.Field<int>("ID"),
                          Agent = x.Field<string>("Agent")
                      })
                  });

    foreach (var res in result) {  
            var lstAgents= res.Agents;
    ImportSchedule(lstAgents);
}

how can i pass lstAgents in ImportSchedule() method. What type i define in ImportSchedule?

When you do 'Select(gr=>new ...' you are creating an anonymous type. Here you could find an answer to your question: http://stackoverflow.com/questions/6624811/how-to-pass-anonymous-types-as-parameters. — Jose Luis, Feb 20 '16 at 10:19

score 1 · Answer 1 · edited May 23 '17 at 11:44

1

You can do it like this:

public void ImportSchedule(dynamic agents) { }

But you should make a class for this, the reason being if the property Id is changed to AgentId then you will find out the error on the Run time.

For more info:

Link 1

edited May 23 '17 at 11:44

Community

1
1

answered Feb 20 '16 at 10:18

Syed Farjad Zia Zaidi

3,302
4
27
50

score 0 · Accepted Answer · answered Feb 20 '16 at 10:21

You can't pass anonymous type into method, but you can make class or struct like this:

public class AgentDto
{
    public int Id {get; set;}
    public string Agent {get; set;}
}

in this case you shuld make method ImportSchedule like this:

public void ImportSchedule(IEnumerable<AgentDto> agents)

also take your attention that you not pass the date into ImportSchedule, but you probably need to do it

LINQ result set passing into other method

2 Answers2