Re: [nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Fabio Maulo
Scott, to change properties try to follow what I said and you will see that it is even more easy (you have to deal only with your object and not with NH internals). On Wed, Apr 6, 2011 at 4:42 AM, Scott Findlater scottfindla...@gmail.comwrote: Hi Suman, I would be interested to know if you

[nhusers] Re: First-Level cache management

2011-04-08 Thread Luigi Dallavalle
In those scenarios you described, isn't better to use an IStatelessSession? On 8 Apr, 02:18, brendan richards bren...@openthought.com wrote: Hi all, I'm writing this message to share a bit of code I've put together to give me some useful functions to manage NHibernate's first-level cache.

[nhusers] using QueryOver with WHERE IN ListGuid

2011-04-08 Thread Thomas Kehl
Hi I need the fallowing Query do with NHibernate QueryOver. But I have Problems with the List. select * from contact where CountryId = 'xxx' and ContactTypeId in ('aaa', 'bbb') The Values (xxx, aaa, bbb) are Guid's. I have a ListGuid() which contains the Guid's for ContactTypeId (contactTypes)

[nhusers] Re: Collection Property Is Null

2011-04-08 Thread Ricardo Peres
This is the current status of this issue: - If the entity is mapped as lazy and the collection is mapped as lazy, the collection property is null (!) - If the entity is mapped as lazy and the collection is mapped as not lazy, the collection property is null (!) - If the entity is mapped as not

[nhusers] Advice on building sets

2011-04-08 Thread Markus Ewald
Hi! An application I'm working on has different items that, as an upcoming feature, should be assignable to sets: Items Id ProducerId ItemSetId (nullable) Name Weight ItemSets Id ProducerId Views Id

Re: [nhusers] using QueryOver with WHERE IN ListGuid

2011-04-08 Thread Walter Poch
I'm not sure, but could you try: var query = contactRepository.GetAllOver() .Where(x = x.Country != null x.Country.Idhttp://x.country.id/ == countryId) *.JoinQueryOverContactType(x=x.ContactType).WhereRestrictionOn(x = x.Id http://x.contacttype.id/).*IsInG(contactTypes); I

[nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Scott Findlater
Fabio, thank you so much for your reply. Sorry I do not think I am explaining myself very well, may I please ask you to download this sln (http://dl.dropbox.com/u/20651208/ WTF.zip) and I can demonstrate with just 3 tests in the BecauseOfEventHandling class; 1. Test

[nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Scott Findlater
Fabio, the sln link got truncated http://bit.ly/hBRgLv On Apr 8, 1:54 pm, Scott Findlater scottfindla...@gmail.com wrote: Fabio, thank you so much for your reply. Sorry I do not think I am explaining myself very well, may I please ask you to download this sln

[nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Scott Findlater
Fabio, thank you so much for your reply. Sorry I do not think I am explaining myself very well, may I please ask you to download this sln (http://dl.dropbox.com/u/20651208/WTF.zip) and I can demonstrate with just 3 tests in the BecauseOfEventHandling class; 1. Test

Re: [nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Fabio Maulo
Scott, PreUpdate, PreInsert, PreDelete are to check entity state (as most even to log) but NOT TO CHANGE entity state. Again, try to follow what I said. To Log the old state or the difference you can use even the PostXYZ. On Fri, Apr 8, 2011 at 9:54 AM, Scott Findlater

[nhusers] NHIbernate projection alias not mapping to mapped type

2011-04-08 Thread cs
I have the following mapping: property name=TopLevelGenre column=top_level_genre type=Boo.NHibernateExtensions.ArrayType, Boo.NHibernateExtensions update=false insert=false / And the following projection as part of my query criteria: Projections.Alias(Projections.SqlFunction(array_agg,

[nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Scott Findlater
Hi Fabio, OK, obviously you are right :) I will stop trying to change entity state in these events. It is just NOT TO CHANGE state in these events is not really documented anywhere and from blog posts give examples of using the OnPreInsert and OnPreUpdate event listeners as the perfect place for

[nhusers] Re: Remotion.Data.Linq is internal

2011-04-08 Thread Patrick Earl
Those members are now exposed (NH-2636). On Apr 7, 10:49 am, Nicao nic...@gmail.com wrote: NHibernate bundles Remotion.Data.Linq.dll into the final library, but everything is marked as internal.  I am trying to make a more advanced Linq extension for NHibernate but I am unable to extend the

[nhusers] Re: Is it possible to call IQuerable.ToFuture() and IQuerable.Fetch() in same query for NHibernate (3.0) Linq?

2011-04-08 Thread Vas6ili
There is an issue opened, NH-2422 On Apr 7, 7:42 pm, Nicao nic...@gmail.com wrote: I've been trying to accomplish this exact same scenario and so far I have been unable to find a way around it without modifying source. On Apr 7, 9:25 am, Vas6ili vas6...@gmail.com wrote: I want to use

Re: [nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Fabio Maulo
is not really documented anywhere That is only because we are still waiting your patch for the NHibernate public documentation. If you don't want to send a patch you can use the nhforge wiki, the knol ( http://knol.google.com), share your experience in your blog, share your experience in the

[nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Scott Findlater
Touche Fabio :) I will make a deal with you ... I will write an in depth documentation patch about the NH event model if you can please explain why there is wiki article explaining how to create an audit log which clearly uses the OnPre events to CHANGE ENTITY state -

Re: [nhusers] Advice on building sets

2011-04-08 Thread Oskar Berggren
Are you suggesting that the NULL ItemSet belongs to all producers? (If not, why should it be included when querying by producerid?) It sounds like what you want is a null-object - instead of using NULL for the itemsetit, you would have an ItemSet with e.g. id 1, that is _always_ there, and that

[nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Scott Findlater
Touche Fabio :) I will happily contribute to the documentation but how do I explain a contradiction in the official NHibernate wiki article which uses the OnPre events TO CHANGE STATE - http://nhforge.org/wikis/howtonh/creating-an-audit-log-using-nhibernate-events.aspx On Apr 8, 7:33 pm, Fabio

[nhusers] Testing QueryOver Calls

2011-04-08 Thread Ryan
Have been running into some issues in our unit testing recently. As we have gotten into more complex queries, we have started to use QueryOver to execute these. In implemenation this works out great, but for testability we are running into major road blocks. Is there a proper way to test

Re: [nhusers] Testing QueryOver Calls

2011-04-08 Thread Walter Poch
Most of the NH users I kown are using this pattern for Complex Queries: Enhanced Query Object, described by Fabio Maulo here: http://fabiomaulo.blogspot.com/2010/07/enhanced-query-object.html http://fabiomaulo.blogspot.com/2010/07/enhanced-query-object.htmlRegards, 2011/4/8 Ryan

Re: [nhusers] Re: Clarification on NH-2596 of PreUpdate vs OnSaveOrUpdate semantics

2011-04-08 Thread Fabio Maulo
I asked you to write a wiki, right ? well... imagine that you do it and after some moths somebody else will ask me why that wiki say those things ? what should I answer ? On Fri, Apr 8, 2011 at 5:34 PM, Scott Findlater scottfindla...@gmail.comwrote: Touche Fabio :) I will make a deal with you

[nhusers] How to query a column name that includes a question mark character

2011-04-08 Thread Martin Ingham
I haven't been able to find the answer to this in any NHibernate documentation. I am trying to write an HQL query with named parameters. Unfortunately one of the column names includes a question mark character in its name. In the mapping file I have wrapped the column name in square brackets

[nhusers] Problem with NHibernate HQL Query and SubQuery

2011-04-08 Thread zsamer
Hi everyone! I have a problem with a NHibernate query with sub-query for a report. I have a Native SQL Query (SQLServer) with nested sub query and I need convert to NHibernate HQL. The Native SQL query is: SELECT ma.persona, ma.totalA, mb.totalB, (ma.totalA + mb.totalB) as