Linq query to return list within a list

Question

Hi I have following two model classes

public class c1
{
    public int id { get; set; }
    public int ptId { get; set; }
    public int bId { get; set; }
    public int rId { get; set; }
    public IEnumerable<styles> newStruct { get; set; }
}

public class styles
{
    public int id { get; set; }
    public int bId { get; set; }
    public string desc { get; set; }
}

I am trying to write a linq query

var records = (from y in db.main
               join c in db.secondary on y.bId equals c.bId
               where c.id == id
               select new c1
               {
                   pId= c.pId,
                   id = c.id,
                   newStruct = new List<styles>
                   {
                       new styles
                       {
                           id=y.room_id,
                           desc=y.desc,
                       }
                   }
               });

return records.ToList();

Problem I am having is that in newStruct is suppose to be List of all the styles but it just returns one style at a time rather than one list. Please let me know how can it return record where inside it contains list of styles Thanks

Sinan AKYAZICI · Accepted Answer · 2014-04-21 12:19:30Z

3

If you want to get a sublist by main list, you should use group by,

You can try this, but I'm not sure it worked. Becasue I couldn't compile it.

var records = (from y in db.main
                           join c in db.secondary on y.bId equals c.bId
                           where c.id == id
                           group c by new
                           {
                               c.pId,
                               c.id
                           } into gcs
                           select new c1
                           {
                               pId = c.Key.pId,
                               id = c.Key.id,
                               newStruct = from g in gcs select new styles { id=g.room_id, desc=g.desc}
                           });

answered Apr 21, 2014 at 12:19

Sinan AKYAZICI

3,9625 gold badges39 silver badges63 bronze badges

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

Comments

Chrisgh · Accepted Answer · 2014-04-21 13:02:01Z

0

Is this LINQ to Entities? If so, and the mappings are correct in the edmx, you can try:

var records = 
    from c in db.secondary
    where c.id == id
    select new c1
    {
        pId = c.pId,
        id = c.id,
        newStruct = c.main.Select(m => new styles { id = m.room_id, desc = m.desc })
    };

return records.ToList();

answered Apr 21, 2014 at 13:02

Chrisgh

1,0162 gold badges10 silver badges18 bronze badges

Collectives™ on Stack Overflow

Linq query to return list within a list

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related