Linq to Sql, derived to derived association

Question

I dont know if its possibe.

I have a base table with 2 derived tables.

Mammal
Mammal -> Boy
Mammal -> Dog

A want that Dog table has a foreign key(ownerBoyId) to Boy table, but linq designer dont permit, because Boy itself dont have a Id collumn, Id is inherited.

How can I resolve this problem? Associate to Base class?

Answer 1

LINQ to SQL only supports table-per-heirarchy, not table-per-type.