entity framework - Converting a GroupBy / Having SQL query to Linq or EF query -

i have following query:

select planet_id  tags  name in ('tag1', 'tag2')  group hardware_id  having count(name) = 1; 

where 'tag1' , 'tag2' items of list<string> pass function. want know how convert entity framework or linq query.

you can use contains extension method:

var tags=new list<string>{"tag1", "tag2"}; var query= t in context.tags            tags.contains(t.name)            group t t.hardware_id g            g.count()==1