List group only containing items

Question

List group only containing items

Navigation

#1 by (1 votes)
#2 by (1 votes)

2

And an example of model :

public class Grupo
{
   public int Id {get;set;}
   public string Nome {get;set;}

   public ICollection<Item> Itens {get;set:}
}

And the items

public class Item
{
  publit int Id {get;set;}
  public int GrupoId {get;set;}
  public string Nome {get;set;}
}

Is there any way I can filter via% w / o of% only groups containing Items?

c# entity-framework-6

asked by anonymous 25.02.2015 / 02:44

2 answers

Message in JSON does not appear Jquery taking too long to execute

score 1 · Answer 1

If you are using EF5 or higher, I believe the best solution involves Contains .

var gruposID = db.Itens.Select(item => item.GrupoId).Distinct().ToList();
var listaGrupos = db.Grupos.Where(grupo => gruposID.Contains(grupo.GrupoId));

score 1 · Answer 2

First of all, you need to reference class Item to Grupo :

public class Item
{
  publit int Id {get;set;}
  public int GrupoId {get;set;}
  public string Nome {get;set;}
  public virtual Grupo Grupo { get; set; } // <-

}

Then just make a query in Grupo to check if it has Item :

var listaGrupos = db.Grupo.Where(a => a.Itens.Count > 0).ToList();