Hello,
I have following tables, I have go the mapping workings for
Party,Person, GenericValue, GenericValueType, Identifiers (each class
maps
to each table). Party is the root.
Party
========================
Id, PersonId
========================
1, 1
Person
========================
PersonId, FirstName, LastName
========================
1, , TestLName
GenericValueType maps directly to a class
============
TypeId, TypeName
==============
1 , IdentifierType
GenericValue maps directly to a class
======================
GenericValueId, Name, TypeId
======================
1, EmployeeId, 1
2, DriverLicense, 1
3, etc...
Identifiers
===========================
Id, PartyId, GenericValueId, identifier (string)
===========================
1, 1, 1, , 123456
Employee
============================
EMPLID (int), FirstName, LastName
============================
123456 , Test , TestLName
Trouble is mapping employee to identifiers table, the employee view id
is
integer and the corresponding value stored in identifiers is stored in
the
column identifier is string. Each night the
party, person and identifier records are created from employee view.
The
thing is customer doesn't want to modify existing tables and person
tables
has limited information. So what I basically
want is some how able to access Employee class from Person for e.g
Person.Employee.DepartmentName, Person.Employee.LastName.
Let me know if this is even possible? or any other mapping suggestion
to
accomplish in a better way?
Thanks
Rusty
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to fluent-nhibern...@googlegroups.com.
To unsubscribe from this group, send email to
fluent-nhibernate+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en.
