Ok i'm gonna check it out.. Thanks On Mon, Mar 29, 2010 at 9:37 PM, Robert Rudduck <[email protected]> wrote:
> You will probably want to map that with Table-Per-Subclass. So you will use > the joined-sublcass syntax. You might want to consider combining the table > and using a discriminator instead considering the similarities. > > This link will help explain more: > http://ayende.com/Blog/archive/2009/04/10/nhibernate-mapping-ndash-inheritance.aspx > > - Robert > > > On Sun, Mar 28, 2010 at 11:18 PM, reggieboy <[email protected]>wrote: > >> Hello guys i am currently thinking on how to map a database table like >> this >> >> >> create table [User] ( >> Id UNIQUEIDENTIFIER not null, >> RecordVersion INT not null, >> Email NVARCHAR(255) null, >> Password NVARCHAR(255) null, >> UserCategory INT null, >> primary key (Id) >> ) >> >> >> create table Doctor ( >> Id UNIQUEIDENTIFIER not null, >> RecordVersion INT not null, >> Firstname NVARCHAR(255) null, >> Lastname NVARCHAR(255) null, >> Middlename NVARCHAR(255) null, >> Gender INT null, >> Birthdate DATETIME null, >> primary key (Id) >> ) >> >> create table Secretary ( >> Id UNIQUEIDENTIFIER not null, >> RecordVersion INT not null, >> Firstname NVARCHAR(255) null, >> Lastname NVARCHAR(255) null, >> Middlename NVARCHAR(255) null, >> Gender INT null, >> Birthdate DATETIME null, >> primary key (Id) >> ) >> >> alter table Doctor >> add constraint FKCE4594AAF1922C4D >> foreign key (Id) >> references [User] >> >> alter table Secretary >> add constraint FKF4B0E86CF1922C4D >> foreign key (Id) >> references [User] >> >> >> what will the xml mapping file will look like? >> >> can i use polymorphic association with it? >> thanks guys in advance :) >> >> -- >> 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. >> >> > -- > 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. > -- 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.
