[nhusers] Re: IStatelessSession.Insert and uni-directional one-to-many

2009-04-29 Thread Roger Kratz
StatelessSession doesn't do cascade operations, AFAIK. -Original Message- From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On Behalf Of mscheibler Sent: den 29 april 2009 07:57 To: nhusers Subject: [nhusers] Re: IStatelessSession.Insert and uni-directional one-to-many

[nhusers] Using legacy Functions and Procs in Oracle

2009-04-29 Thread fquednau
Hi there, I am currently prototyping a .NET app towards a legacy Oracle DB. Quite a bit of the meat of the legacy app is inside stored procs functions. I read a bit about using procs, and it looks like ref out cursors can be supported. Fair enough! We have a number of functions that have a

[nhusers] Re: IStatelessSession.Insert and uni-directional one-to-many

2009-04-29 Thread mscheibler
Hi Roger, that's what I experienced. The question now is if there is any other way to correctly insert the detail class including the foreign key. The reason I am asking is that A) from a DDD point of view I should never adjust my domain model to overcome persistence restrictions and B)

[nhusers] Mapping collections in many-to-many associations

2009-04-29 Thread Ahmed Emad
hi all when i tried to map acollection to create mapping for many-to-many association i founded many types of collection but i don't know what is the most suitable one. i read that set is more suitable .However, most tutorials and samples use bags. so,from your practical experience in

[nhusers] Re: Mapping collections in many-to-many associations

2009-04-29 Thread James Gregory
How do you want your collection to behave? Is it ordered? Can it contain duplicates? On Wed, Apr 29, 2009 at 10:07 AM, Ahmed Emad aemad...@gmail.com wrote: hi all when i tried to map acollection to create mapping for many-to-many association i founded many types of collection but i don't

[nhusers] Re: Mapping collections in many-to-many associations

2009-04-29 Thread James Gregory
A bag is an unordered, unindexed, collection that can contain an element more than once; as such, it's typically the default for legacy setups. If you know that the collection should be ordered, indexed, or not contain duplicates then you should pick one of the other collection types. On Wed, Apr

[nhusers] Re: Mapping collections in many-to-many associations

2009-04-29 Thread Ahmed Emad
i know that to contain duplicates i can't use set but what i need to know can i consider one collection mapping as preferred one for most cases. 2009/4/29 James Gregory jagregory@gmail.com How do you want your collection to behave? Is it ordered? Can it contain duplicates? On Wed, Apr

[nhusers] Re: IStatelessSession.Insert and uni-directional one-to-many

2009-04-29 Thread Roger Kratz
Do you think something like that would word? If yes, would you consider including into the trunk? I'm not a committer. -Original Message- From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On Behalf Of mscheibler Sent: den 29 april 2009 10:33 To: nhusers Subject:

[nhusers] Re: StaleStateException when executing 'delete'

2009-04-29 Thread Fred F.
I want to tell you about my newest conclusions and ask you again for help. For better reading I will shorten the mentioned MainObject to 'MO' and ChildObject to 'CO'. I have taken the nhibernate sourcecode and discovered following Method: ActionQueue.ExecuteActions() From here all committed

[nhusers] inheritance issue

2009-04-29 Thread graphicsxp
Hi, I have an issue due to some poorly design database (which I can't change now). I want to have 3 classes : Person , Employee which inherits from Person Analyst which inherits from Person as well. In the database there are 3 tables : [Person] {PersonId, Fullname} [Employee] {EmployeeId,

[nhusers] Re: inheritance issue

2009-04-29 Thread graphicsxp
hum I think join-subclass is the answer to my problem.. correct me if I'm wrong. On 29 avr, 11:41, graphicsxp graphic...@googlemail.com wrote: Hi, I have an issue due to some poorly design database (which I can't change now). I want to have 3 classes : Person , Employee which inherits

[nhusers] executing stored procedure

2009-04-29 Thread graphicsxp
Hi, I have a named query which is supposed to execute a stored procedure : sql-query name=ConvertSource exec sp_GENERIC_ConvertPublication :@PublicationID, :@Type /sql-query Here is the stored procedure code : DECLARE @OldType AS INT SELECT @OldType = BroadMediaTypeID FROM

[nhusers] Re: Mapping collections in many-to-many associations

2009-04-29 Thread Ahmed Emad
thx for your replay but what is your opinion in that : so if using set to map collection, the return type won't be standard .NET collection type does that mean that it may make some problems? 2009/4/29 James Gregory jagregory@gmail.com A bag is an unordered, unindexed, collection that can

[nhusers] Re: Linq and DistinctRootEntity

2009-04-29 Thread Remco Ros
anybody ? On 28 apr, 10:54, Remco Ros r@rawsoft.nl wrote: When I execute the following query, I get an exception telling me that 'feedItemQuery' contains multiple items (so SingleOrDefault doesn't work). This is expected behaviour when using the Criteria api WITHOUT the

[nhusers] Issue with eager fetching

2009-04-29 Thread graphicsxp
Hi, I have 3 tables : [Post] and [Region] are in sqlserver database called Media. [User] is in sqlserver database called Admin. Region and User both have foreign keys to Post. So when I get a Post record I'm expecting NH to join on Region and Post when I do eager- fetching : return

[nhusers] Re: IStatelessSession.Insert and uni-directional one-to-many

2009-04-29 Thread Fabio Maulo
You can use the statefull session and clean it after each action; the final result is the same. 2009/4/29 mscheibler scheib...@scheibler-entwicklung.de Hi Roger, that's what I experienced. The question now is if there is any other way to correctly insert the detail class including the

[nhusers] Re: executing stored procedure

2009-04-29 Thread Fabio Maulo
You can use ExecuteUpdate but with a query like this and CreateSQLQuery: exec sp_GENERIC_ConvertPublication :PublicationID, :Type It should work even with namedQueries but I'm not sure we have tests about it. 2009/4/29 graphicsxp graphic...@googlemail.com Hi, I have a named query which is

[nhusers] Re: executing stored procedure

2009-04-29 Thread graphicsxp
Hi, I've tried this : SessionManager.GetCurrentSession() .CreateSQLQuery(exec ediaTest.dbo.sp_GENERIC_ConvertPublication :@PublicationID, :@Type) .SetParameter(@PublicationID, pId) .SetParameter(@Type, pType).ExecuteUpdate(); but I'm getting exactly the same error.

[nhusers] Re: executing stored procedure

2009-04-29 Thread Fabio Maulo
Repeat : exec sp_GENERIC_ConvertPublication :PublicationID, :Type Remove @ Ah... and we have a test using namedQuery. Can you send the complete exception and inner exception message ? 2009/4/29 graphicsxp graphic...@googlemail.com Hi, I've tried this : SessionManager.GetCurrentSession()

[nhusers] not-found = ignore triggers loading

2009-04-29 Thread graphicsxp
Hi, If not-found property of many-to-one mapping is set to ignore, the association always gets eagerly initialized regardless of the value of the lazy property. Is this meant to happen ? Thanks --~--~-~--~~~---~--~~ You received this message because you are

[nhusers] Auditing using events

2009-04-29 Thread darren
Any ideas why the following doesn't persist the new audit object? The audit information needs to be stored in a separate table. public bool OnPreUpdate(PreUpdateEvent updateEvent) { ISession session = updateEvent.Source.GetSession(); // don't audit the

[nhusers] Re: Mapping property value based on select statement and another property

2009-04-29 Thread joe
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

[nhusers] Re: Mapping property value based on select statement and another property

2009-04-29 Thread joe
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

[nhusers] Re: Store image in database ...

2009-04-29 Thread Kris-I
Not possible ? :) Coulf you tell me how to store (retrieve) an image (gif, pgn, jpeg,bmp) to a database with NH ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups nhusers group. To post to this group, send email