[nhusers] Re: Nhibernate Validator and WPF

2009-08-21 Thread Bart Reyserhove
Cool. Looking at it now. Thanks! On Fri, Aug 21, 2009 at 12:34 AM, José Romaniello jfromanie...@gmail.comwrote: Bart, its done: This is the interceptor for dynamicproxy: http://code.google.com/p/unhaddins/source/browse/trunk/uNhAddIns/uNhAddIns.WPF.Castle/DataErrorInfoInterceptor.cs

[nhusers] Re: Inverse=True (again)

2009-08-21 Thread Oskar Berggren
Some answers below, hopefully correct. :) 2009/8/20 spiralni the.email.tr...@gmail.com: I don't get it :( I've read, and test all the references in the web, but this concept is just to complex for me.. Hope you can clarify me. From the 2.1 Reference, I found this in the Bidirectional

[nhusers] Re: AfterTransactionBegin in events

2009-08-21 Thread Niclas Pehrsson
No one? On 20 Aug, 17:19, Niclas Pehrsson pehrs...@gmail.com wrote: Hi can I listen for AfterTransactionBegin in the new event system? like in interceptor        public override void AfterTransactionBegin (ITransaction tx)         {             base.AfterTransactionBegin(tx);         }

[nhusers] Re: Why DB updated ....(Evict trouble ?)

2009-08-21 Thread Kris-I
As Ayende told me I tried session.Evict(...), I tried several to Evict several object at several place. but the DB is still updated :( In the code below, I get data from the database and I create a a List from these data. The result is as expected . the first time. In fact for each

[nhusers] Re: Why DB updated ....

2009-08-21 Thread Tuna Toksoz
But you're changing the entity itself.It is better if you convert those to dto's. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, Aug 21, 2009 at 11:46 AM, Kris-I kris.i@gmail.com wrote:

[nhusers] Re: Why DB updated ....

2009-08-21 Thread Kris-I
It is better if you convert those to dto's. Tell me more (dto ??? don't know this abbreviation) Thanks, --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups nhusers group. To post to this group, send email to

[nhusers] Re: Why DB updated ....

2009-08-21 Thread Tuna Toksoz
Data Transfer Objects. This calculation looked like it is something for visual purposes, as you don't persist them back. Is that right? Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, Aug 21,

[nhusers] Re: Why DB updated ....

2009-08-21 Thread Kris-I
Data Transfer Objects. This calculation looked like it is something for visual purposes, as you don't persist them back. Is that right? Exactly --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups nhusers group. To

[nhusers] Re: Why DB updated ....

2009-08-21 Thread Kris-I
Ok, I'll do this but Evict should work or I don't use it in the right way. So instead of binding them to let's say grid,you create another object from what you have, which only have properties what you need, and values that you want to show(in your case calculations) i don't know if it

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Saijado
This Bug should be fixed in Version 2.1.1 I've send a patch to JIRA some weeks ago. Search in JIRA for Example and you should find my post. -- Armin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups nhusers group. To

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Armin Landscheidt
http://nhjira.koah.net/browse/NH-1902 On Aug 21, 1:02 pm, Saijado saij...@googlemail.com wrote: This Bug should be fixed in Version 2.1.1 I've send a patch to JIRA some weeks ago. Search in JIRA for Example and you should find my post. -- Armin

[nhusers] Re: NHibernate 2.1 Dependency Injection and/or Proxy Issue

2009-08-21 Thread Nick Clarke
Cheers Roger. I rebuilt my site and ran into the problem again changed Company to ICompany and all worked fine. Thanks again --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups nhusers group. To post to this group,

[nhusers] Re: batch_size

2009-08-21 Thread srf
this is the commands: session.SetBatchSIze(100); ITransaction transaction = session.BeginTransaction() session.save(auditEntry); //add about 2000 of these session.Flush(); in my config; add key=adonet.batch_size value=1 / this is my mapping file ?xml version=1.0 encoding=utf-8 ?

[nhusers] Double many-to-one?

2009-08-21 Thread Jason Dentler
I have an extremely simple mapping that has been driving me mad for the better part of a day. I posted all the details on my blog. http://jasondentler.com/blog/2009/08/double-many-to-one/ Any help you can provide would be very much appreciated. Thanks, Jason Dentler

[nhusers] Querying through a many-to-many relationship?

2009-08-21 Thread Brian Kendig
I have a Person table and an Event table (parties, meetings, c.). This many-to-many relationship is represented by an Invitation table, which represents the invitations sent to people for events. The Invitation table also records when the invitation was sent, whether it was accepted, and so

[nhusers] Many-to-one filter

2009-08-21 Thread JozefSevcik
Hi all, I've seen some talk about many-to-one with filter in nh-dev mailing list recently, however I'm not quite clear about current status of that feature in 2.1 or trunk. Questions: a) Are filters supported in many-to-one mappings ? b) What's the behavior, how should they work ? c) Is to

[nhusers] Re: Linq Query ToLower

2009-08-21 Thread William Claiming
This throws the same Exception as well: var txAddresses = addresses.Where(address = string.Compare (address.State, Tx, true) == 0); I don't control the Database in my situation. Does anyone know how to do case insensitive string comparison with NHibernate.Linq? Hendry Luk wrote: Just

[nhusers] Re: Double many-to-one?

2009-08-21 Thread Tuna Toksoz
22hours ago email appears just now, hmm. The problem is solved, this is necessary action. Otherwise we would have FK violation etc Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, Aug 20, 2009

[nhusers] NHLinq exceptions with simple queries

2009-08-21 Thread JamesSpibey
Hi, I've tried a couple of basic queries with NHLinq but I just get exceptions thrown. For Example Dim results = (From p In session.Linq(Of Product) _ Where p.ImageCount 0 _ Select p).ToList I get the following at

[nhusers] Re: batch_size

2009-08-21 Thread Carlos cubas
session.SetBatchSIze(100);// This is used for fetching add key=adonet.batch_size value=1 / You should set this to a number like 100 if you want the system to batch your insert/update/deletes -Carlos Practice makes perfect, but if no one is perfect, why practice? Date: Fri, 21 Aug

[nhusers] Re: Inverse=True (again)

2009-08-21 Thread Cesar Sanz
@Oskar, Thanks for the explanation.. From another thread I extracted this setting inverse=true on the mapping tells Hibernate that 'the other side (the Child) has responsibility to update itself to maintain the foreign key reference in its table' And I think it has to do with what you said

[nhusers] Re: NHLinq exceptions with simple queries

2009-08-21 Thread Oskar Berggren
Supposedly you will also be told the name of the exception, the exception message, and recursive information about any inner exceptions? /Oskar 2009/8/21 JamesSpibey james.spi...@gmail.com: Hi, I've tried a couple of basic queries with NHLinq but I just get exceptions thrown. For Example

[nhusers] Re: NHLinq exceptions with simple queries

2009-08-21 Thread Tuna Toksoz
IS the code of ImageCount like this? public int ImageCount { get{return this.Images.Count;} } Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, Aug 21, 2009 at 5:19 PM, JamesSpibey

[nhusers] Re: batch_size

2009-08-21 Thread Fabio Maulo
two things:1- To have batcher working you should set adonet.batch_size=100 2- That native smell bad (in MsSQL native=identity and it nullify the batcher)... where is the guid you have mentioned ? 2009/8/21 srf scott.fl...@cmgl.ca this is the commands: session.SetBatchSIze(100);

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Joe
Thanks you guys, I was pulling my hair out! On Aug 21, 4:15 am, Armin Landscheidt saij...@googlemail.com wrote: http://nhjira.koah.net/browse/NH-1902 On Aug 21, 1:02 pm, Saijado saij...@googlemail.com wrote: This Bug should be fixed in Version 2.1.1 I've send a patch to JIRA some weeks

[nhusers] Re: OnPreInsert - generates an extra update ?

2009-08-21 Thread Chris F
+1 I've seen the same behaviour while debugging another problem. Immediately after running through my OnPreInsert code for all the entities being created, the OnPreUpdate is called for all the same entities. On Aug 11, 9:57 am, sirrocco xavier...@gmail.com wrote: If in an Event ,

[nhusers] Re: Querying through a many-to-many relationship?

2009-08-21 Thread Brian Kendig
On Aug 21, 1:33 pm, Fabio Maulo fabioma...@gmail.com wrote: I don't know the domain butselect i.Event from Invitation i where i.Person = :pPerson That's the problem; I don't know how to phrase a query to return a specific field rather than the entire object. For example, here's my query:

[nhusers] Re: Querying through a many-to-many relationship?

2009-08-21 Thread Fabio Maulo
I don't know the domain butselect i.Event from Invitation i where i.Person = :pPerson 2009/8/20 Brian Kendig br...@enchanter.net I have a Person table and an Event table (parties, meetings, c.). This many-to-many relationship is represented by an Invitation table, which represents the

[nhusers] Re: Nested Sessions/Transactions Possible ?

2009-08-21 Thread Fabio Maulo
ah... and that is the reason because I'm injecting the ISessionFactory on my DAOs/Repository 2009/8/21 Fabio Maulo fabioma...@gmail.com session = UoWstatelesssession != UoW 2009/8/21 empe...@gmail.com empe...@gmail.com Hello, Is it possible to use nested sessions or transactions ? My

[nhusers] Re: AfterTransactionBegin in events

2009-08-21 Thread Fabio Maulo
I don't remember... perhaps we should add it and some others as: OnSessionOpen OnSessionClose 2009/8/21 Niclas Pehrsson pehrs...@gmail.com No one? On 20 Aug, 17:19, Niclas Pehrsson pehrs...@gmail.com wrote: Hi can I listen for AfterTransactionBegin in the new event system? like in

[nhusers] Re: NHLinq exceptions with simple queries

2009-08-21 Thread JamesSpibey
The exception was a NullReferenceException, the message was Object reference not set to an instance of an object. and there was no InnerException. I think I found the issue, ImageCount is a nullable Integer (Integer?). Changing it to a Non-nullable type fixes it On Aug 21, 5:14 pm, Oskar

[nhusers] Re: Inverse=True (again)

2009-08-21 Thread Cesar Sanz
Sorry, a typo, I meant invers = false 2. With inverse=false, the many end (Children in this case) has no obligation to set the parent to which it belongs.. You mean, that Child.Parent being null would be ok, i.e. a Child with no parent? Well, I've read that in this case, NHibernate insert

[nhusers] Re: OnPreInsert - generates an extra update ?

2009-08-21 Thread sirrocco
Well .. there is an answer to this :) . You have to set the value in that state array AND on the entity. It took me an hour to realize this even though I found the following code : var audit = @event.Entity as IAudit; if(audit == null)

[nhusers] Re: OnPreInsert - generates an extra update ?

2009-08-21 Thread Chris F
This doesn't generate the extra update. I just couldn't see the difference. ?? Did you mean DOES generate? I wasn't able to discern what you meant in your last post. I totally get that you have to perform the Set on the @event.State, AND that you have to update the entity: (1)

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Joe
Oops, I celebrated too soon! I grabbed the latest build from NH TeamCity and at first it seemed fixed. But, there is a problem still with case. If I set a string property to C, the parameter generated is C%, but it should be c% because the where clause is: WHERE (lower (this_.description)

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Joe
Based on your tests for NH-1902, then this test should pass, too. I can't seem to get NHibernate to build and test on my machine. Is this something you can run?? [Test] public void TestEnableLikeAndCaseInsensitiveWithMatchmodeAnywhere() {

[nhusers] Re: OnPreInsert - generates an extra update ?

2009-08-21 Thread Chris F
Indeed, I did run the code with the commented out line, and the OnPreUpdate still gets called. I even commented out the entity state update (separately), and still OnPreUpdate gets called. So I'm still not understanding why this happens. On Aug 21, 2:50 pm, Chris F mcfaz...@gmail.com wrote:

[nhusers] Re: OnPreInsert - generates an extra update ?

2009-08-21 Thread sirrocco
Actually, in my code I was just updating the State array. Apparently that was the reason I was also getting the update. When I update the State and the Entity - for me , the update doesn't happen . PS: I found your question in another thread bellow and saw that you are doing this already . So

[nhusers] Paging with SQL 2000

2009-08-21 Thread Renato Duan
Hi All, I have a doubt about paging with SQL 2000 dialect. I did a simple test, using IQuery interface in both SQL 2005 and SQL 2000. In SQL 2005 I liked too much the query NH generated (using Row_Number() SQL Server function), but in SQL 2000, NH just made a “select Top N” from the table. Is

[nhusers] Re: OnPreInsert inconsistent behaviour

2009-08-21 Thread Chris F
It's not even limited to my joined subclasses it seems... This is all becoming rather non-deterministic. I have a base class called Business and a joined subclass called Customer. Business has (one-to-)many BusinessContacts, meaning Customers have many BusinessContacts. I create a primary

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread armin-landscheidt
If I remember right, it doesn't matter if you write 'C%' or 'c%' but I will check it. Based on your tests for NH-1902, then this test should pass, too. I can't seem to get NHibernate to build and test on my machine. Is this something you can run?? [Test]

[nhusers] Re: Paging with SQL 2000

2009-08-21 Thread Fabio Maulo
We done what is possible, we are working to do the impossible, for miracles give us more time and perhaps we can work on it. 2009/8/21 Fabio Maulo fabioma...@gmail.com and which is the way to paginate a SQL in MsSQL2000 ? 2009/8/21 Renato Duan renato...@gmail.com Hi All, I have a doubt

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Joe
It matters on Oracle database: select 'X' from dual where lower('ABCDE') like 'A%' Does not return a row, the like comparison fails. On Aug 21, 2:31 pm, armin-landscheidt saij...@gmail.com wrote: If I remember right, it doesn't matter if you write 'C%' or 'c%' but I will check it.

[nhusers] Re: Inverse=True (again)

2009-08-21 Thread Cesar Sanz
Plus, I found this.. very nice http://nhprof.com/Learn/Alert?name=SuperfluousManyToOneUpdate - Original Message - From: Cesar Sanz the.email.tr...@gmail.com To: nhusers@googlegroups.com Sent: Friday, August 21, 2009 12:03 PM Subject: Re: [nhusers] Re: Inverse=True (again) Sorry, a

[nhusers] Re: Paging with SQL 2000

2009-08-21 Thread Dario Quintana
Yes it is. The eternal fight against the pagination of SQL 2005... MS had created that nice way to paginate for us, how cool is that? :-) On Fri, Aug 21, 2009 at 4:50 PM, Renato Duan renato...@gmail.com wrote: Is that the expected behavior? Imagine a table with lots of rows, the performance

[nhusers] Re: batch_size

2009-08-21 Thread srf
I tried setting the adonet.batch_size=100 and 1000 and 2000 without any effect .maybe its the generator =native , what should I set that to for it to work? thanks scott On Aug 21, 10:16 am, Fabio Maulo fabioma...@gmail.com wrote: two things:1- To have batcher working you should set

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread armin-landscheidt
Puhhh some minutes more then i thought ^^. I think I've found it. Ther ist no lower call for Parameter. I hope sending fils on groups works. Here is the Patch for the LikeExpression. But I don't know if it was intended that ther is no lower call. I will try to send the patch in a short time to

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread armin-landscheidt
Now I'm really confused. There is an InsensitiveLikeExpression which allways calls lower. But it calls 'ilike' for Postgres. But in LikeExpression there is no special call for postgresql. And the lowercase call for paramters are missing too. Is this a Bug too? It matters on Oracle database:

[nhusers] Re: Paging with SQL 2000

2009-08-21 Thread Fabio Maulo
and which is the way to paginate a SQL in MsSQL2000 ? 2009/8/21 Renato Duan renato...@gmail.com Hi All, I have a doubt about paging with SQL 2000 dialect. I did a simple test, using IQuery interface in both SQL 2005 and SQL 2000. In SQL 2005 I liked too much the query NH generated (using

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread armin-landscheidt
Ok I've tested it on MySQL and MS-SQL and there it doesn't matter. Your Test wokrs on my machine. It seems, this is an Oracle sepcific thing. Mybe I know how to fix it. Give me a second :-D It matters on Oracle database: select 'X' from dual where lower('ABCDE') like 'A%' Does not return

[nhusers] Re: batch_size

2009-08-21 Thread Fabio Maulo
When you make a question here, in general, you are reading the answer ? I'm asking because the fist response to your request has a link to a blog post. 2009/8/21 srf scott.fl...@cmgl.ca I tried setting the adonet.batch_size=100 and 1000 and 2000 without any effect .maybe its the generator

[nhusers] Re: IgnoreCase not working

2009-08-21 Thread Joe
Thank you for all your work and help on this. On Aug 21, 3:19 pm, armin-landscheidt saij...@gmail.com wrote: Puhhh some minutes more then i thought ^^. I think I've found it. Ther ist no lower call for Parameter. I hope sending fils on groups works. Here is the Patch for the

[nhusers] Re: Paging with SQL 2000

2009-08-21 Thread 江名峰
the best way to do paging is using Stored Procedure. 2009/8/22 Fabio Maulo fabioma...@gmail.com We done what is possible, we are working to do the impossible, for miracles give us more time and perhaps we can work on it. 2009/8/21 Fabio Maulo fabioma...@gmail.com and which is the way to

[nhusers] Re: Paging with SQL 2000

2009-08-21 Thread Dario Quintana
Hi all I can't see how a query can be better than a query. An store procedure is just a compiled query. And there is no-way that NHibernate will work with a SP to paginate. Just wondering what exactly you mean with this approach. Cheers 2009/8/21 江名峰 hamlet.ji...@gmail.com the best way to do

[nhusers] Re: batch_size

2009-08-21 Thread srf
Ya, I set the generator to assigned and set the adonet.batch_size to 100 but the nhprof still shows alerts about the separate inserts so im not sure what im still missing . maybe ill debug into nhibernate to bet a better understanding of whats going on. thanks scott On Aug 21, 5:36 pm, Fabio

[nhusers] Re: Paging with SQL 2000

2009-08-21 Thread 江名峰
NHibernate will not work with a SP to paginate,but when we get the data we can do anything.In any case, we want to achieve is the best way for paging.NHibernate is a mapping tool,not for paging. 2009/8/22 Dario Quintana conta...@darioquintana.com.ar Hi all I can't see how a query can be

[nhusers] Re: batch_size

2009-08-21 Thread Fabio Maulo
repeat When you make a question here, in general, you are reading the answer ? because even when somebody point you to something you are continuing with the same question. native mean identity when you are working with MsSQL and identity nullify the batcher. 2009/8/22 srf scott.fl...@cmgl.ca