I am having trouble with a LINQ query to return the name of the Home and Away team from the same table. I have schedule table with awayid and homeid. In sql server it's easy to reference the teams table as teams and teams1 and get my data in same record. I cannot figure out the LINQ code to produce same results.
This brings in home team name. How would I change it to also get away team from teams table.
Dim curScores = From s In db.Schedules Join hteams In db.Teams On s.HomeID Equals hteams.Teamid
Where s.Week = 3 And s.Season = "2014" Select Teamid = s.HomeID, HomeTeam = hteams.TeamName