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
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.