C# Linq подобный формат
Помогите перевести sql подобный формат в LINQ.
void Main()
{
List<Wheel> wheel = new List<Wheel>();
wheel.Add(new Wheel { Id_wheel = 1, Name = "Первый"});
wheel.Add(new Wheel { Id_wheel = 2, Name = "Второй"});
wheel.Add(new Wheel { Id_wheel = 3, Name = "Третий"});
List<Car> car = new List<Car>();
car.Add(new Car { Id = 1, Name = "Car 1", Id_left_wheel = 1, Id_right_wheel = 4});
car.Add(new Car { Id = 2, Name = "Car 2", Id_left_wheel = 2, Id_right_wheel = 2});
car.Add(new Car { Id = 3, Name = "Car 3", Id_left_wheel = 3, Id_right_wheel = 3});
var query = from c in car
join cn in wheel.AsQueryable() on c.Id_left_wheel equals cn.Id_wheel
join ct in wheel.AsQueryable() on c.Id_right_wheel equals ct.Id_wheel
where (c.Id_left_wheel == cn.Id_wheel) && (c.Id_right_wheel == ct.Id_wheel)
select new { Id = c.Id, Name = c.Name, Left = cn.Name, Right = ct.Name };
var query2 = Car.Join(Wheel, c => c.Id_left_wheel, cn => cn.Id_wheel, (c,cn) => new { Id = c.Id, Name = c.Name, Left = cn.Name}) // что-то подобное, но с двумя join
}
public class Car
{
public int Id { get; set; }
public string Name { get; set; }
public int Id_left_wheel { get; set; }
public int Id_right_wheel { get; set; }
}
public class Wheel
{
public int Id_wheel { get; set; }
public string Name { get; set; }
}