Simple JOIN Syntax Not Working in Entity Framework

Question

I am trying to add a join to an existing LINQ statement but my syntax is incorrect. I looked here for examples among other places yet, my construction is still not working. Visual Studio is throwing a hissy fit. Both datasets are in the context that I am trying to work with so not sure what I am doing wrong:

The red squiggly line under the "join" keyword produces the error "The type arguments cannot be inferred from the query" The "n" and "nc" aliases produce the error "Cannot resolve symbol"

enter image description here

My Original, working statement

 var query = from nc in context.NewClubs
                           where nc.ClubMasterCustomerId == clubMasterCustId
                           select nc;
               var results = query.Any();

What I am trying to do (Illustrated in SQL)

select nc.NewClubName,nc.Id from NewClub as nc
join NewClubBuilder ncb on ncb.NewClubId = nc.Id
where ncb.BuilderClubKeyNumber = 'K00841'

My translation from SQL to LINQ (Not working)

var query = from nc in context.NewClubs
            join n in context.NewClubBuilders on n.NewClubId equals nc.Id
            where nc.ClubMasterCustomerId == clubMasterCustId
            select nc;

            var results = query.Any();

Thanks

Can you define "hissy fit"? What's the exact error reported? — Chris L
– Chris L, Commented Apr 4, 2014 at 14:24
Hissy fit == I included a screenshot that shows the issues in red — Slinky
– Slinky, Commented Apr 4, 2014 at 14:31
Could you create a entity relationship between NewClubs and NewClubBuilders so you don't have to specify the join in the query? — markpsmith
– markpsmith, Commented Apr 4, 2014 at 14:40
The red squiggly line under the "join" keyword produces the error "The type arguments cannot be inferred from the query" — Slinky
– Slinky, Commented Apr 4, 2014 at 14:55

Aducci · Accepted Answer · 2014-04-04 14:57:27Z

3

Swith the join properties, so nc.Id is first

join n in context.NewClubBuilders on nc.Id  equals n.NewClubId

answered Apr 4, 2014 at 14:57

Aducci

26.8k8 gold badges67 silver badges69 bronze badges

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

1 Comment

Slinky Over a year ago

Got bitten by that one before - forgot order matters here. Thanks

Collectives™ on Stack Overflow

Simple JOIN Syntax Not Working in Entity Framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related