Luis Lora
Luis Lora

Reputation: 83

Fill Model Class With query

Hello I Have the Following Model

public class MainClass
{
    public List<SubClass1> First { get; set; }
    public List<SubClass2> Second { get; set; }
    public List<SubClass3> Third { get; set; }
}

public class SubClass1
{
    public string Prop1 { get; set; }
}

public class SubClass2
{
    public string Prop2 { get; set; }
    public string Prop3 { get; set; }            
}

public class SubClass3
{
    public string Prop4 { get; set; }
    public string Prop5 { get; set; }
}

I need to "fill" the MainClass with a linq query result, I'm trying to do it this way:

var resultado = from a in DataContext.Table1
                        join b in DataContext.Table2 on a.Id equals b.CId
                        select new MainClass
                        {
                           First = new SubClass1 ... list query result,

                           Second = new SubClass2 ... list query result,

                           Third = new SubClass3 ... list query result,                               
                        }; 

How can I "fill" the SubClasses in order to construct the MainClass.

Upvotes: 1

Views: 595

Answers (1)

Yuri
Yuri

Reputation: 2900

Your code should look like this

var resultado = from a in DataContext.Table1
                    join b in DataContext.Table2 on a.Id equals b.CId
                    select new MainClass
                    {
                       First = ( from i in db.Entity where somecondition).ToList<SubClass1>()
                       , Second = (from s in db.Entity2 where ).ToList<SubClass1>()

}

and so on..

Upvotes: 1

Related Questions