How to get all Parent records which doesn't have child record

Question

I am using Entity Framework where I want to fetch all the parent records which doesn't have child record.

How to query the same?

Parent Table -> "Messages" Child Table - > "SentMessages"

EDIT: Please note: I need th solution in Entity Framework classes.

Currently I am using -

ctx.Messages.Where(m => ctx.SentMessages(x => x.msgid != m.msgid))

but it failed

Paresh Makwana · Accepted Answer · 2015-01-12 11:29:57Z

1

You can try this LINQ,

MessageList.Where(m => !SentMessageList.Select(sm => sm.MsgId).Contains(m.MsgId));

answered Jan 12, 2015 at 11:29

Paresh Makwana

1892 silver badges14 bronze badges

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

3 Comments

Anil Purswani Over a year ago

how did you got MessageList?

Paresh Makwana Over a year ago

MessageList is 'Messages' table record list, and SentMessageList is 'SentMessages' table record list, m.MsgId is 'Messages' table primary key, sm.MsgId is foreign key of Messages table in 'SentMessages' table.

tschmit Over a year ago

@PareshMakwana you should have writen : ctx.Messages.Where(m => !ctx.SentMessages.Select(sm => sm.MsgId).Contains(m.MsgId));

tschmit · Accepted Answer · 2015-01-12 11:27:24Z

0

in pseudo code:

from m in Messages where m.Sents.Count() == 0 select m

answered Jan 12, 2015 at 11:27

tschmit

7,8402 gold badges38 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to get all Parent records which doesn't have child record

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related