[nhusers] SQL Server 2008R2 with NH = Slow ?

2010-04-24 Thread Kris-I
Hello there, I did a fresh install of Windows 7 and I installed VS2010Ultimate, SQLServer R2. I use Gallio Version 3.1 build 397 with Testdriven .NET 3 RC 3. The method is a very simple select around 1sec before (VS2008, SQL Server 2008, Testdriven .NET 2.0) now it's .. 31 sec ! It's the

[nhusers] Exe call thru web-service, nhibernate issue

2010-04-24 Thread sjpk
i have a c# Dot Net Windows application in that i am using nhibernate to connect to SQL server,in the form load event i can easily able to open the Nhibernate session if the exe is clicked manually,but if the same EXE is called thru webservice using Diagnostics process.start(EXE path), exe is

Re: [nhusers] SQL Server 2008R2 with NH = Slow ?

2010-04-24 Thread Diego Mijelshon
Have you run a profiler to determine where are those 31 seconds being spent? Diego On Sat, Apr 24, 2010 at 03:29, Kris-I kris.i@gmail.com wrote: Hello there, I did a fresh install of Windows 7 and I installed VS2010Ultimate, SQLServer R2. I use Gallio Version 3.1 build 397 with

Re: [nhusers] Exe call thru web-service, nhibernate issue

2010-04-24 Thread Diego Mijelshon
Stack trace/full exception message? Diego On Sat, Apr 24, 2010 at 05:16, sjpk sjpks...@gmail.com wrote: i have a c# Dot Net Windows application in that i am using nhibernate to connect to SQL server,in the form load event i can easily able to open the Nhibernate session if the exe is

[nhusers] Re: why do we need to connect relation on both side of related entites?

2010-04-24 Thread Vladan Strigo
lets imagine a standard form to db scenario where you have related entites (not what nh was meant to be, but nevertheless, it DOES happen)... you have an entity called Prospect, it has properties: - Name (string) - Surname (string) - InterestedInProduct (Product, many-to-one) than you have an

Re: [nhusers] Re: why do we need to connect relation on both side of related entites?

2010-04-24 Thread Diego Mijelshon
For saving, you can get away with the latter, assuming that's the non-inverse side. Of course, the in-memory state of Prospect will NOT reflect that. Diego On Sat, Apr 24, 2010 at 08:22, Vladan Strigo vladan.str...@gmail.comwrote: lets imagine a standard form to db scenario where you have

[nhusers] Re: mapping: multiple members instead of collection

2010-04-24 Thread Datvi
Suppose they are auto-implemented {get;set;} properties without additional logic. On 23 Nisan, 23:06, Fabio Maulo fabioma...@gmail.com wrote: show us the setter of Wheel1, please. On Thu, Apr 22, 2010 at 1:21 PM, Datvi ahm...@gmail.com wrote: Hello, How can i map kind of relation?

[nhusers] NHibernate.Linq Where clause doesn't do strings correctly

2010-04-24 Thread Sam
I'm new to nh so I could be doing something wrong, but here's my issue: I have an object that has a string property and I'm doing a NHib.Linq query, but the string portion is never enclosed in single quotes. In the meantime, I had to handwrite the query. code: var value =

[nhusers] Re: Exe call thru web-service, nhibernate issue

2010-04-24 Thread sjpk
its a exception message On Apr 24, 4:15 pm, Diego Mijelshon di...@mijelshon.com.ar wrote: Stack trace/full exception message?    Diego On Sat, Apr 24, 2010 at 05:16, sjpk sjpks...@gmail.com wrote: i have a c# Dot Net Windows application in that i am using nhibernate to connect to SQL

Re: [nhusers] Re: Exe call thru web-service, nhibernate issue

2010-04-24 Thread Diego Mijelshon
No, that's a truncated, generic exception message without the inner exceptions, nor the source of the problem. Gives us the full exception.ToString(). Psychic debugging is not fun. Diego On Sat, Apr 24, 2010 at 09:13, sjpk sjpks...@gmail.com wrote: its a exception message On Apr 24, 4:15

Re: [nhusers] Re: mapping: multiple members instead of collection

2010-04-24 Thread Fabio Maulo
Ok, and how look the creation of a new wheel... to be short, are you assigning the property Owner some where ? On Sat, Apr 24, 2010 at 9:09 AM, Datvi ahm...@gmail.com wrote: Suppose they are auto-implemented {get;set;} properties without additional logic. On 23 Nisan, 23:06, Fabio Maulo

Re: [nhusers] Exe call thru web-service, nhibernate issue

2010-04-24 Thread Fabio Maulo
probably the hibernate.cfg.xml is not where it should be On Sat, Apr 24, 2010 at 5:16 AM, sjpk sjpks...@gmail.com wrote: i have a c# Dot Net Windows application in that i am using nhibernate to connect to SQL server,in the form load event i can easily able to open the Nhibernate session if

Re: [nhusers] NHibernate.Linq Where clause doesn't do strings correctly

2010-04-24 Thread Oskar Berggren
Do you have an actual error? How do you know it's not enclosed in single quotes? I'm not very familiar with the LINQ-implementation, but shouldn't the values be sent using parameterized queries. No enclosing or escaping necessary. /Oskar 2010/4/24 Sam sam@gmail.com: I'm new to nh so I

Re: [nhusers] NHibernate.Linq Where clause doesn't do strings correctly

2010-04-24 Thread Tuna Toksoz
That being said, it would be cool if we can see NHProf or SQL Prof output for this query. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Sat, Apr 24, 2010 at 4:30 PM, Oskar Berggren

Re: [nhusers] Re: why do we need to connect relation on both side of related entites?

2010-04-24 Thread Jason Dentler
Yep. Like Diego said, you can get away with that. In memory, Product.Prospects will be incorrect, but it sounds like you don't care about that. I might be wrong, but you could also get away with a Load of Product instead of a Get, which saves you a SELECT, as long as you don't use the Product. If

[nhusers] Re: Criteria count returns Int32, HQL count returns Int64

2010-04-24 Thread FlukeFan
Fabio, The current IQueryOver.RowCount() wraps the Projections.RowCount() ... should we change it to wrap the Projections.RowCountInt64() instead? On Apr 23, 11:04 pm, Fabio Maulo fabioma...@gmail.com wrote: HQL returns Int64 since long time ago. Criteria has 2 methods because back

[nhusers] Mapping a generic component

2010-04-24 Thread nadav s
suppose i have some properties that i wanna wrap with a component, but the values type might vary idealy i would like to use a generic ComponentT for this scenario is it possible? -- You received this message because you are subscribed to the Google Groups nhusers group. To post to this group,

Re: [nhusers] Re: why do we need to connect relation on both side of related entites?

2010-04-24 Thread Diego Mijelshon
Actually (and I forgot to mention that), Load is the correct method in this case, as it doesn't go to the DB and you're sure it exists. If a property of Product other than Id was accessed, NH would correctly retrieve it from the DB. Diego On Sat, Apr 24, 2010 at 10:43, Jason Dentler

Re: [nhusers] Mapping a generic component

2010-04-24 Thread Fabio Maulo
Yes. On Sat, Apr 24, 2010 at 10:49 AM, nadav s nadav...@gmail.com wrote: suppose i have some properties that i wanna wrap with a component, but the values type might vary idealy i would like to use a generic ComponentT for this scenario is it possible? -- You received this message because

Re: [nhusers] Mapping a generic component

2010-04-24 Thread nadav s
can you help me by telling me how please? mapping to both Component or to Componentlt;stringgt; (it was a very long shot) caused an exception: when mapping simply to Component: Message = Could not load type 'TestVSOracle.Entities.GenericComponent' from assembly 'TestVSOracle, Version=1.0.0.0,

[nhusers] My test fails on Concurrency Violation using optimistic concurrency

2010-04-24 Thread Visar Uruqi
I'm using optimistic concurrency, Version integer, my following test fails, I don't know why [Test] [ExpectedException(typeof(NHibernate.StaleObjectStateException))] public void CanThrowExceptionOnConcurrencyViolationUpdate() { Person p = new Person()

Re: [nhusers] My test fails on Concurrency Violation using optimistic concurrency

2010-04-24 Thread Paco Wensveen
It's happening because you use one session with the object still in first level cache. p1.ReferenceEquals(p2) == true. On Sat, Apr 24, 2010 at 5:43 PM, Visar Uruqi visar.ur...@gmail.com wrote: I'm using optimistic concurrency, Version integer, my following test fails, I don't know why        

Re: [nhusers] Mapping a generic component

2010-04-24 Thread nadav s
ok i got it nevermind :) Entities.GenericComponent`1[System.String] .net strange syntax On Sat, Apr 24, 2010 at 6:35 PM, nadav s nadav...@gmail.com wrote: can you help me by telling me how please? mapping to both Component or to Componentlt;stringgt; (it was a very long shot) caused an

[nhusers] Re: why do we need to connect relation on both side of related entites?

2010-04-24 Thread Vladan Strigo
Yes it would, I know that...and in other cases Load saves the day pretty good. However in this case, I am abusing the Multicriteria in a way that I first traverse the object...build up a list of query descriptors...then have a converter which converts them to ICriteria queries, after which its as

[nhusers] Re: mapping: multiple members instead of collection

2010-04-24 Thread Datvi
I noticed that car and wheels metaphor is not completly suitable with my actual case. Because car and wheels looks like a composition relation. Ok, and how look the creation of a new wheel... I guess you want to know if it is a composition for my case. No it is not. Because for my case, a Car

Re: [nhusers] Re: My test fails on Concurrency Violation using optimistic concurrency

2010-04-24 Thread Paco Wensveen
var person = new Person(); using (ISession session1 = OpenNewSession()) { session1.Save(new Person()); } using (ISession session2 = OpenNewSession()) { using (ISession session3 = OpenNewSession()) { var personInSession2 = session2.Get(person.Id); var personInSession3 =

Re: [nhusers] Re: mapping: multiple members instead of collection

2010-04-24 Thread Fabio Maulo
Well that is the problem. NH does not touch your object; you must assign it explicitly. On Sat, Apr 24, 2010 at 3:42 PM, Datvi ahm...@gmail.com wrote: I noticed that car and wheels metaphor is not completly suitable with my actual case. Because car and wheels looks like a composition

Re: [nhusers] Re: Criteria count returns Int32, HQL count returns Int64

2010-04-24 Thread Fabio Maulo
IMO, No there is not an strongly necessity to have HQL compatibility with neither QueryOver nor Criteria.. Different API different behavior... no problem On Sat, Apr 24, 2010 at 10:48 AM, FlukeFan fluke...@googlemail.com wrote: Fabio, The current IQueryOver.RowCount() wraps the

[nhusers] Re: How to check if lazy loading is working properly?

2010-04-24 Thread Afshar Mohebbi
Thanks John, Because I was not aware how can I see SQL output of NHiberante, I used MS SQL Profiler. It was a pain because other clients were sending SQL statements too, but finally I realized that NHibernate lazy loading is working greatly. Afshar Mohebbi On Apr 22, 5:22 pm, John Davidson