I have a question about the design of one of my entities:
Let's say that I have an SUV Class and a MiniVan Class and a Sedan Class. They all inherit from an AutomobileBase class. My database contains a table called Automobile that contains all the data for SUVs, Minivans and Sedans.
Say I am adding a new SUV, I first add all the properties to the object and then call ADDNEW. ADDNEW will call the base class ADDNEW to add the base information and then update it with the SUV information.
Is this a good design or should each of the "types" be put into their own table to control?
How would LLBLGen handle this Inheritance from a Base Class? Is a different design better?