Linq To Sql One To Many

Say I have 3 tables, Cars, Persons, CarOwners.

Cars is just a table of cars and Persons are different people that can own cars. CarOwners has a CarId and a PersonId relationship and a CarOwnerId PK.

If I just create the r开发者_开发问答elationship and then drag them to the linq context, a property of the Person class will be generated called CarOwners. To get the cars that this person owns I would have to do the following query:

var cars = person.CarOwners.Select(c=> c.Car);

But I would like to be able to do:

var cars = person.Cars;

Is that at all possible? The extra step is quite annoying.

---

You can just create a new property on Person:

public partial class Person
{
    public IEnumerable<Car> Cars
    {
        get { return this.CarOwners.Select(c => c.Car); }
    }
}

Or upgrade to Entity Framework where you can separate logical model from physical model.

---

Try to remove the CarOwnerId from CarOwners in your sql database. Then select CarId and PersonId in designer mode in SSMS (using shift key), right click and select `Set Primary Key.

In EF 4, you'll get only navigation keys in your model this way (you can use: Person.Cars and Car.Persons). Not sure about L2S.