复杂的LINQ多表有多对多[关闭](complex LINQ multiple tables with many to many [closed])

复杂的LINQ多表有多对多[关闭](complex LINQ multiple tables with many to many [closed])

我还是LINQ的新手。 这种情况可以与linq一起使用吗？

我有4张桌子：

1. Garage (ID, Name) 2. Car (ID, GarageID, Name) -- a garage has multiple cars. 3. Dealer (ID, Name) 4. Car_Dealership (ID, CarID, DealerID) -- many to many table between car and dealer

我想得到所有车库的集合以及每个车库处理的每个经销商。

你怎么能用LINQ做到这一点？

提前致谢！

I am still new to LINQ. Is this scenario possible to do with linq?

I have 4 tables:

1. Garage (ID, Name) 2. Car (ID, GarageID, Name) -- a garage has multiple cars. 3. Dealer (ID, Name) 4. Car_Dealership (ID, CarID, DealerID) -- many to many table between car and dealer

I want to get a collection of all garages along with every dealer that each garage dealt with.

How can you do this with LINQ?

Thanks in advance!

最满意答案

你应该可以使用这样的东西：

var map = from garage in Garages join car in Cars on garage.ID equals car.GarageID join car_dealership in Car_Dealerships on car.ID equals car_dealership.CarID join dealer in Dealers on car_dealership.DealerID equals dealer.ID group dealer by garage; foreach (var garage in map) { Console.WriteLine("Garage: " + garage.Key.Name); foreach (var dealer in garage) Console.WriteLine(" Dealer: " + dealer.Name); }

将来，请发布您尝试过的内容，以便我们帮助您解决您遇到的具体问题。

You should be able to use something like this:

var map = from garage in Garages join car in Cars on garage.ID equals car.GarageID join car_dealership in Car_Dealerships on car.ID equals car_dealership.CarID join dealer in Dealers on car_dealership.DealerID equals dealer.ID group dealer by garage; foreach (var garage in map) { Console.WriteLine("Garage: " + garage.Key.Name); foreach (var dealer in garage) Console.WriteLine(" Dealer: " + dealer.Name); }

In the future, please post what you've tried so that we can help you with the specific problems you're running into.