LINQ query syntax to method syntax

Question

I use asp.net, c# and EF4.

I'm puzzled by this LINQ query:

  var queryContents = from a in context.CmsContentsAssignedToes
                    where a.UserId == myUserGuid
                    join cnt in context.CmsContents
                    on a.ContentId equals cnt.ContentId
                    where cnt.TypeContent == myTypeContent & cnt.ModeContent == myModeContent
                    select cnt;

I would like write its equivalent in LINQ method syntax to retrieve CmsContents.

In my conceptual model are two entity types:

CmsContent
CmsContentsAssignedTo

and their entity sets:

CmsContents
CmsContentsAssignedToes

and navigation properties:

in CmsContent --> CmsContentsAssignedTo RETURN: --> Instance of CmsContentsAssignedTo
in CmsContentsAssignedTo --> CmsContent RETURN: --> Instance of CmsContent

Do you know how to do it? I tried for more that one day but I cannot solve it!

Thanks for your time!

Jon Skeet · Accepted Answer · 2011-03-10 09:30:26Z

10

The equivalent method syntax is:

 var queryContents = context.CmsContentsAssignedToes
                            .Where(a => a.UserId == myUserGuid)
                            .Join(context.CmsContents,
                                  a => a.ContentId,
                                  cnt => cnt.ContentId,
                                  (a, cnt) = new { a, cnt })
                            .Where(z => z.cnt.TypeContent == myTypeContent &
                                        z.cnt.ModeContent == myModeContent)
                            .Select(z => z.cnt);

See my Edulinq blog post on query expressions for more details of how this works, and particularly where the "z" comes from (it's not really called "z"; it doesn't have a name as it's a transparent identifier).

answered Mar 10, 2011 at 9:30

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

2 Comments

GibboK Over a year ago

Thanks Jon for you explanation and link. Have a nice day!

GibboK Over a year ago

Hi, I posted a question, I would like you expert opinion if you have time. stackoverflow.com/questions/5260346/… thanks in advance for your help.

Collectives™ on Stack Overflow

LINQ query syntax to method syntax

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related