ok, you propose composition over inheritance.
But my teacher has some other properties ie: favoritebook etc..
and my policeman has other properties too ie: colleague etc.
and if I put all those properties in a single table i get many rows
that contains null in specific columns.

On Aug 6, 6:34 pm, Jason Meckley <[email protected]> wrote:
> according to you're object hierarchy and NH mapping/database schema a
> person can be either a policeman or a teacher, not both.
> If they can be both you need to change your domain model/db schema to
> allow for this. something like
>
> class person
> {
>    IList<Job> Occupations;
>
> }
>
> person table
>   id
>   name
>
> occupation table
>    person id
>    job id
>
> Job table
>   id
>   description
>
> in other words... a person has many jobs. not a person is a job.
>
> On Aug 6, 12:16 pm, Fabio Maulo <[email protected]> wrote:
>
>
>
> > The problem is not the mapping but the concept of OOP.
> > Let me show another case:
> > Animal
> > Dog : Animal
> > Cat : Animal
>
> > In the DB I have an Animal with ID 1 that is a Dog and a Cat.
>
> > On Fri, Aug 6, 2010 at 11:50 AM, James Gregory 
> > <[email protected]>wrote:
>
> > > Please show us your mappings.
>
> > > You should have:
>
> > > ClassMap<Person>
> > > SubclassMap<Teacher>
> > > SubclassMap<Policeman>
>
> > > On Aug 6, 3:32 pm, Luka <[email protected]> wrote:
> > > > ups my error!
>
> > > > I have this problem:
> > > > public class Person:DomainBase<Person,int>
> > > > {
> > > >    public string Name;
>
> > > > }
>
> > > > public class Teacher: Person
> > > > {...
>
> > > > }
>
> > > > public class Policeman:Person
> > > > {...
>
> > > > }
>
> > > > All classes are mapped using fluent nhibernate.
> > > > The inheritance is mapped by: SubClassMap<Person>.
>
> > > > In code I am doing this:
> > > > IPersonRepository rep =
> > > > ObjectFactory.GetInstance<IPersonRepository>();
> > > > var teachers = rep.GetAllTeachers();
> > > > var policemans = rep.GetAllPolicemans();
>
> > > > The error I am getting is this:
>
> > > > Object with id: 1 was not of the specified subclass: Policeman
> > > > (loading object was of wrong class [Teacher]).
>
> > > > in the database I have i person with ID 1 that is a teacher and a
> > > > policeman.
>
> > > > How to solve this problem?
>
> > > --
> > > You received this message because you are subscribed to the Google Groups
> > > "nhusers" group.
> > > To post to this group, send email to [email protected].
> > > To unsubscribe from this group, send email to
> > > [email protected]<nhusers%[email protected]
> > >  >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/nhusers?hl=en.
>
> > --
> > Fabio Maulo

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to