Thanks for the reply. I only found the following blog post that explains the <any> association in any detail. http://ayende.com/Blog/archive/2009/04/21/nhibernate-mapping-ltanygt.aspx
It looks like <any> association does not support using queries to determine the value. Basically the RequestNumber is comprised of 2 parts. 1. RequestType 2. Request count with RequestType in 1. select count(*) from Request_table where request_type = 'RMI' and use the count(*) value as part of the On Apr 29, 12:43 am, Fabio Maulo <[email protected]> wrote: > <any> > > 2009/4/27 joe <[email protected]> > > > > > > > Hi, > > > In the system I am developing we have a field RequestNumber which is > > used to identify the request ( by the end user. It's not a primary > > key) > > > So for eg we have the following columns in the table > > Id > > RequestType (possible values: AIM, CMI, JMI) > > RequestNumber > > RequestDetail1 > > .... > > RequestDetailN > > > What I want in RequestNumber is AIM-10 if this is the 10th request of > > RequestType AIM > > JMI-120 if this is > > the 120th request of RequestType JMI > > > Is there a way to define the RequestNumber in the mapping file so that > > it uses the RequestType property and a select statement. > > > Maybe there is an easier way doing this. > > > I would appreciate if anyone can shed some light on this > > Thanks > > Joe > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
