Getting <List> of each type in an anonymous type array variables

Question

Using a Linq query, I have returned an array of two types and am trying assign each list of types to a list variable of the given type:

Model:

public class ReportViewModel
{
    public List<DbTable> DbTables;
    public List<Application> Applications;
}

Controller:

var ReportTablesAndSystems = (from tu in db.DbTablesUsed
                              join t in db.DbTables on tu.TableId equals t.TableId
                              join a in db.DbApplication on t.ApplicationId equals a.ApplicationId
                              where tu.ReportId == id
                              select new
                              {
                                  a,
                                  t
                              }).ToList();

ReportViewModel rvm = new ReportViewModel();

rvm.DbTables = //?????????
rvm.Applications = //??????

How can I set rvm.DbTables to be the list of DbTables which is held in ReportTablesAndSystems and set rvm.Applications to be the list of Applications held in ReportTablesAndSystems?

What does ReportTablesAndSystems contain? I.e. a List<T> -- what is T? — rory.ap
– rory.ap, Commented Nov 1, 2016 at 16:57
Your comment makes no sense. What type does the list contain? — rory.ap
– rory.ap, Commented Nov 1, 2016 at 17:28
I think your ReportViewModel should only consist of one list of applications, each containing a collection of tables. — Gert Arnold
– Gert Arnold, Commented Nov 1, 2016 at 19:34

DeveTho · Accepted Answer · 2016-11-01 18:00:54Z

2

I have returned an array of two types

That would actually be a list of an anonymous type with properties a of type Application and t of type DbTable. ;)

You can assign your two properties like this then:

rvm.DbTables = ReportTablesAndSystems.Select(r => r.t).ToList();
rvm.Applications = ReportTablesAndSystems.Select(r => r.a).ToList();

answered Nov 1, 2016 at 18:00

DeveTho

3912 silver badges16 bronze badges

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

2 Comments

SE1986 Over a year ago

Thanks - simple solution!

SE1986 Over a year ago

Alternatively : rvm.DbTables = (from r in ReportTablesAndSystems select r.t).ToList()

Collectives™ on Stack Overflow

Getting <List> of each type in an anonymous type array variables

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related