I'm sure this has been asked and probably answered before but I'm not finding anything.
I have two database tables that are hierarchically related (a 1:1 relationship). For the sake of argument, let's call them Person and Employee. Person has fields like name and address. An Employee is also a person and gets those fields but ALSO gets extra fields like EmployeeNumber, Department, etc.
What I would like to have is a BLL entity called Employee that contains all those properties - so the data provider would know to join both records to load the values, and to perform both INSERT's or UPDATE's to write its data.
What's the best way to achieve this using .NetTiers? Is this somehow supported with the templates as-is? Am I going to need to create updateable views? Subclass the generated entities (breaking the .generated files and making future codegen's a royal pain)?
Thanks.
-C