Linq join query question

Question

I have this code:

join bird in yourBirds on bird.Name equals bird.Name select new { myBirds = bird.Name, yourBirds = bird.Name };

A range variable `bird' has already been declared in this scope

the question is: Create a variable named ourBirds and assign to it a LINQ query that is the result of a join from myBirds onto yourBirds using the Name property as the key. Make sure to return the birds that are the same between the two lists.

need help, thanks

CodeChallenge.cs

var myBirds = new List<Bird> 
{ 
    new Bird { Name = "Cardinal", Color = "Red", Sightings = 3 },
    new Bird { Name =  "Dove", Color = "White", Sightings = 2 },
    new Bird { Name =  "Robin", Color = "Red", Sightings = 5 }
};

var yourBirds = new List<Bird> 
{ 
    new Bird { Name =  "Dove", Color = "White", Sightings = 2 },
    new Bird { Name =  "Robin", Color = "Red", Sightings = 5 },
    new Bird { Name =  "Canary", Color = "Yellow", Sightings = 0 }
};

  var ourBirds =
                from bird in myBirds
                join bird in yourBirds on bird.Name equals bird.Name
                select new { myBirds = bird.Name, yourBirds = bird.Name };

Answer 1 · 2016-12-14T19:10:00Z

December 14, 2016 7:10pm

The issue is that you are using the same variable name for both of the tables.

bird.Name equals bird.Name

here is where you are telling linq what variable to join on, but linq cant tell which table you are talking about bc they are both named bird.

Answer 2 · 2016-12-29T12:00:50Z

December 29, 2016 12:00pm

Thank you!

Welcome to the Treehouse Community

Looking to learn something new?

Anne Yeiser

Anne Yeiser

Linq join query question

2 Answers

Allan Clark

Allan Clark

Anne Yeiser

Anne Yeiser