lambda expression in entity framwork

Question

0.00/5 (No votes)

See more:

iam using entity framwork i need to get a user friends the diagram are in the picture

this is the diagram of the tables

Int64 userID =1;

ctx.Users.Where(x => x.FriendShips.All(y => y.Accepted == true && y.CreatorID == userID)).ToList();

Posted 19-Dec-13 6:28am

Prutal

Add a Solution

Comments

Prutal 19-Dec-13 12:32pm

the result of the above query is not what i want so how i can get all the friends of a user

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bowlturner · Answer 1 · 2013-12-19T07:46:00

Solution 1

Well it might help to know what results you are expecting and what you are actually getting.

currently what you have here

y => y.Accepted == true && y.CreatorID == userID)

will only get the friendships in one direction. meaning if someone else created the friend request and your user accepted it, then they would be the 'FriendId'. If there is a row put into the Friendship table for both users then this doesn't matter, but assuming 1 friendship record for 1 relationship, you'd have to add the

y => && y.FriendId== userID)

as well.

Posted 19-Dec-13 7:46am

bowlturner

Comments

Prutal 19-Dec-13 14:19pm

lets say that i am the user and i want to get all the users that i sent them a friend request and they accept the request what will the expression be if the the above one does not get the wanted result (i cant understand the result that is retrived)

bowlturner 19-Dec-13 14:27pm

I'm not positive (I do a lot of trial and error testing) but I don't think you need the .all in there.

Prutal 19-Dec-13 14:36pm

so what is the answer, what will the expression be ?

bowlturner 19-Dec-13 17:36pm

Just realized something. Most of my Lambda is using objects, so I missed this. I think you might need to use .Join to join the Friendship table to the user table using userid = createid before the where clause.