I have this mapping dilemma and was hoping to get some advice...
I have 2 tables:
T_Rule
RuleId int (identity) key
RuleName varchar(100),
SubjectRuleSeriesId int,
ReferenceRuleSeriesId int
...
T_Rule_Series
RuleSeriesId int (identity) key
RuleId int,
SeriesId int
....
There's a one to many relationship between T_Rule and T_Rule_Series -
but the one to many is on 2 columns: SubjectRuleSeriesId and
ReferenceRuleSeriesId. So there can be many records in the
T_Rule_Series for SubjectRuleSeriesId and many records in the
T_Rule_Series for the ReferenceRuleSeriesId.
So in my mapping for T_Rule I need to have 2 bags (ILists). One on
T_Rules_Series that match on SubjectRuleSeriesId and another that
match on ReferenceRuleSeriesId.
Which leads me to my question: Is it possible to map this? Wouldn't
T_Rule_Series need both columns (SubjectRuleSeriesId and
ReferenceRuleSeriesId)? Should I break this out to 2 tables?
Please any help you can give would be appreciated.
Thanks.
-Mike
--
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.
