tags:

views:

8

answers:

0
Q: 

Particular mapping on related tables

I have this domain problem: one table with this column "id,name,cubicleId" and another table with "id,date,name,numbers"

the actual key to connect the two table is secondtable.name=firsttable.cubicle.name+"_"+firsttable.name

actually the two tables are not related because my domain problem is "I want to get the single row with maximum date less than THISDATE for the name THISNAME"

So in second table I have more row for the same name but with different dates.

How can I connect tables together so I can change name on first table mantaining relation on rows?

related questions

NHibernate: how to enable lazy loading on one-to-one mapping
NHibernate mapping - one-to-one (or one-to-zero)
NHibernate child to polymorphic parent mapping
How to map to get value from primary table in Nhibernate?
How can i view the mapping configurations passed to the NHibernate by the castle activerecord?
Could we have custom name of the primary key column in Fluent NHibernate?
Using Additional Data on Intermediate Table with NHibernate
Storing a comma separated list in a field using nHibernate
Normalizing EnumStringType in NHibernate
NHibernate mapping with a class hierarchy whose base class is abstract and the discriminator is not a string
Can this mapping be done with (Fluent) NHibernate?
Nhibernate ValueType Collection as delimited string in DB
NHibernate Many-to-many
NHibernate: Best way to deal with intermediary table using Fluent NHibernate?
NHibernate Inheritance mapping when sub class in Separate Assemblly
Fluent NHibernate: How to create one-to-many bidirectional mapping?
NHibernate - Is there any good tools to assist you with the configuration file?
Mapping a class with multiple collection properties containing the same object type
Joining NHibernate Classes that share a common column but no foreign key
Fluent NHibernate - how to map a subclass one-to-one?
NHibernate many-to-one and unique constraint violation
NHibernate: One base class, several mappings
Is there any way to fake an ID column in NHibernate?
NHibernate: How can I combine fields from two classes?
Mapping a collection of enums with NHibernate