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.

Basically the RequestNumber is comprised of 2 parts.
1. RequestType
2. Request count with RequestType in 1.

I suspect I will have to map the RequestNumber as a property and then
assign the value by running the query seperately.

What I am worried about is if there are 2 requests at about the same
time then the RequestNumber will no longer be unique.

Thanks
joe






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
-~----------~----~----~----~------~----~------~--~---

Reply via email to