SQL Query in C# (Linq)

Question

I've this query in my C# file and it works fine:

from var in db.database_1 
where var.database_2.primarycat.Length > 0 && var.meditype.Contains("All")   
xxx               
select new XElement("id", new XElement("temp", var.database_2.name)

Now, I want to insert this query in the where argument at xxx:

AND name IN (
SELECT primarycat
from database_2
GROUP BY primarycat
HAVING COUNT(*) > 1)

Can somebody help me?

Nuffin · Accepted Answer · 2013-01-09 15:14:09Z

5

A simple sub query should do this:

from var in db.database_1 
where var.database_2.primarycat.Length > 0
    && var.meditype.Contains("All")   
    && (from cat in db.database_2
        group cat by cat.primarycat into g
        where g.Count() > 1
        select g.Key).Contains(var.name)
select new XElement("id", new XElement("temp", var.database_2.name)

answered Jan 9, 2013 at 15:14

Nuffin

3,97020 silver badges34 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:48:59Z

1

Use a sub select. Check out this thread which answers pretty much the same thing.

how to do subquery in LINQ

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Jan 9, 2013 at 15:11

Moriya

7,9363 gold badges38 silver badges54 bronze badges

Collectives™ on Stack Overflow

SQL Query in C# (Linq)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related