After playing around with this I have figured it out. Basically I need to join onto T_Rule_series with 2 columns. one I get by using the "key" element. And for the other I used the "Where" clause on the <Bag> element.
Regards, Mike On Mar 4, 3:29 pm, MikeM <[email protected]> wrote: > 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.
