Tables are Locations, and Rotations
A rotation can have many locations, and visa versa
So if I have a locationID of 5, how do I query to get a list of all rotations who are linked to the LocationID 5?
I'm very confused :) This is all I can think of....
var rotations = (from r
where r.CommonLocations.Where(x => x.LocationID == 3)
...but that doesn't compile
Cannot implicitly convert type