I need to amend this somewhat. The key to T_Rule_Series is wrong. (I have many iterations of this going on b/c of my issues with getting this mapped that I posted the wrong evolution of the key to that table)
The table T_Rule_Series originally started as as a composite key. But I couldn't get that to map so I added the identity column but failed to realize that I made a one-to-one association. The original layout of the table looked liked this: T_Rule_Series RuleId int SeriesId int ParamId int ParamValue The composite key was RuleId, SeriesId and ParamId. So a give RuleId + SeriesId could have many ParamId records. But I couldn't get this mapped in the <bag> with the composite key going after those 2 columns: RuleID and SeriesId. Thanks again. -Mike On Mar 4, 3:14 pm, MikeM <[email protected]> wrote: > 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.
