Anonymous type error when using JOIN in LINQ

Question

I'm getting an error when using a join in a LINQ statement:

'HalftimeHomeGoals is not a member of anonymous type; it does not exist in the current context'.

         Dim HomeAllLP = (From a In db.Matches
                         Join b In db.MatchesLeagues On a.Id Equals b.Id
                         Where (a.HomeTeam = HomeTeam)
                         Order By a.Date Descending
                         Select a, b)



        For Each y In HomeAllLP
            If (y.HalfTimeHomeGoals > 0) Or (y.HalfTimeAwayGoals > 0) Then
                HFHGL2 = HFHGL2 + 1
            End If
        Next

It works fine if I only select a, but if I try and select my joined table as well it gives the error, so I can't access my joined table.

I have looked this up but don't understand any of the answers I've found so far and they are all in C#, I'm using VB.NET.

How about y.a.HalfTimeHomeGoals?

Ivan Stoev
– Ivan Stoev

2015-11-26 17:28:13 +00:00
Commented Nov 26, 2015 at 17:28 — Ivan Stoev
– Ivan Stoev, Commented Nov 26, 2015 at 17:28

Muhammad Adeel Zahid · Accepted Answer · 2015-11-27 08:29:42Z

2

If you need to select both types, it is nevertheless a new type. you can select them in an object of anonymous type like

Dim HomeAllLP = (From a In db.Matches
                         Join b In db.MatchesLeagues On a.Id Equals b.Id
                         Where (a.HomeTeam = HomeTeam)
                         Order By a.Date Descending
                         Select New With {a, b})

Then in foreach you can acess properties of a or b like

For Each y In HomeAllLP
            If (y.a.HalfTimeHomeGoals > 0) Or (y.b.HalfTimeAwayGoals > 0) Then
                HFHGL2 = HFHGL2 + 1
            End If
        Next

answered Nov 27, 2015 at 8:29

Muhammad Adeel Zahid

17.8k16 gold badges95 silver badges160 bronze badges

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

Comments

Alex B. · Accepted Answer · 2015-11-27 11:27:54Z

-1

Assuming that both classes Matches and MatchesLeagues contain a field/property named HalfTimeHomeGoals the following code should work:

For Each y In HomeAllLP
    If (y.a.HalfTimeHomeGoals > 0) Or (y.b.HalfTimeHomeGoals > 0) Then
       HFHGL2 = HFHGL2 + 1
    End If
Next

edited Nov 27, 2015 at 11:27

answered Nov 27, 2015 at 8:23

Alex B.

2,1671 gold badge17 silver badges25 bronze badges

Collectives™ on Stack Overflow

Anonymous type error when using JOIN in LINQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related