LINQ query for object with a sub list

Question

LINQ query for object with a sub list

Navigation

#1 by (1 votes)

-1

I have the following structure:

public class Insumo{
    public int Insumo_id { get; set; }
    public List<InsumoDados> Dados{ get; set; }
}

public class InsumoDados{
    public int Desc { get; set; }
    public decimal Valor{ get; set; }
}

I need to query the database so that it already returns a list of the Input class. Preferably with linq. Something like:

 var listInsumo = (from insumo in banco.orc_insumo                        
                    select new Insumo
                    {
                        Insumo_id = insumo.insumo_id,
                        .
                        .
                        .

Can anyone help me? Thank you.

asp.net linq asp.net-mvc

asked by anonymous 27.07.2018 / 23:39

1 answer

Object counter in C [closed] How to Make a Simple Form in Responsive HTML with native CSS?

score 1 · Accepted Answer

An alternative is to do the following:

var listInsumo = seuContexto.Insumos.Include(p=> p.Dados).ToList();

Use Include to make join , if needed

Another way:

var listInsumo = from insumo in banco.orc_insumo                    
                select insumo;

obs: I do not know the name of your DbSet so you might have to adjust the properties name