tags:

views:

22

answers:

0
Q: 

Fluent Nhibernate, how to handle a has many that really only has one?

Currently I have a table "ComponentAnalysis" and a table "HistoryOfUse" that I am trying to map in Fluent NHibernate.

A component analysis should only have 1 history of use and a history of use should belong to 1 component analysis. This would suggest to me that the tables should be set up for a 1 to 1 mapping. But the designer of the DB didn't set it up that way.

Instead "HistoryOfUse" has a column "ComponentAnalysisID" to specify what component analysis it belongs to. To conform to the database I should have HistoryOfUse References ComponentAnalysis and ComponentAnalysis should HasMany HistoryOfUse.

But if I do this then I need to have a list of type HistoryOfUse which seems fairly annoying. Is there a way to set this up, without changing the database, to allow ComponentAnalysis to have a single HistoryOfUse object even though, according to the DB structure, it should have a list of them?

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