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