Hi Markus - thank you for your reply.  :-)

I was working on that, but if you look at the SQL you'll see that it
is calculating the next ProductNumber based on the maximum number of
all the Product rows in the database. If I were to do an insert of
three Product instances at once, I would have no way of knowing what
the maximum number was - even if I query the database each time, since
someone else might be in the process of inserting products at the same
time.

This ProductNumber basically works like a database identifier on
insert.

Thomas


On 19 Apr., 21:43, Markus Zywitza <[email protected]> wrote:
> What Fabio meant: Move the business logic to the domain objects, not the
> domain object's NHibernate mappings.
>
> -Markus
>
> 2009/4/19 Thomas Koch <[email protected]>
>
>
>
>
>
> > One more bit of detail, that I have omitted.
>
> > The application is a web app using the open-session-in-view pattern.
>
> > The consequence of this is that the NHibernate transaction is commited
> > when the request is finished. Given this architecture I cannot very
> > easily do an insert first, and then run an update afterwards to set
> > the ProductNumber.
>
> > Thomas
>
> > On 19 Apr., 21:32, Thomas Koch <[email protected]> wrote:
> > > Hi Fabio - thank you for your reply.
>
> > > Alas, I do not see the solution, that you are seeing.  :-)
>
> > > A little bit more detail:
> > > The Product table is mapped to a domain object using NHibernate.
>
> > > When I have to create new instances I create new Product instance I
> > > add them to a ProductList property of a Supplier object, and then I
> > > use cascading persistence to have the Products inserted in the
> > > database.
>
> > > Cheers,
> > > Thomas
>
> > > On 19 Apr., 21:21, Fabio Maulo <[email protected]> wrote:
>
> > > > re-read your first phrase... than think about where put that thing ;)
>
> > > > 2009/4/19 Thomas Koch <[email protected]>
>
> > > > > Hi - I am working on a legacy database, moving business logic from SP
> > > > > to domain objects relying NHibernate.
>
> > > > > I have encountered the following in a SP used to insert a "Product"
> > > > > row:
>
> > > > > DECLARE @productNumber int
> > > > > SET @productNumber = (SELECT isnull(MAX(ProductNumber), 401100) +1
> > > > > FROM Product)
>
> > > > > INSERT INTO Product (
> > > > >  .... [ProductNumber] ...
> > > > > )
> > > > > VALUES (
> > > > >  .... @productNumber
> > > > > )
>
> > > > > I do not think its pretty, but is there anyway I can reproduce this
> > > > > with NH ?
>
> > > > > I am not even sure the existing solution does not contain a race
> > > > > condition.
>
> > > > > Cheers,
> > > > > Thomas
>
> > > > --
> > > > Fabio Maulo- Skjul tekst i anførselstegn -
>
> > > > - Vis tekst i anførselstegn -- Skjul tekst i anførselstegn -
>
> > > - Vis tekst i anførselstegn -- Skjul tekst i anførselstegn -
>
> - Vis tekst i anførselstegn -
--~--~---------~--~----~------------~-------~--~----~
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