[nhusers] Inner join when using Criteria, left outer join using LINQ

2010-01-19 Thread Brian Sullivan
I'm trying to figure out why using the LINQ provider produces LEFT OUTER JOINs for all my associations, but the Criteria API produces inner joins, using exactly the same mapping with both methods. The LINQ statement looks like th following: var inspections = (from i in session.Linq()

[nhusers] Re: Float column being persisted with slightly off values

2010-01-13 Thread Brian Sullivan
ersion there. > Either change the db type to real, the .net type to double, or both to > decimal. > >    Diego > > > > On Wed, Jan 13, 2010 at 00:38, Brian Sullivan wrote: > > I've got a property on a persistent object that's a float in .NET, > > mapp

[nhusers] Float column being persisted with slightly off values

2010-01-12 Thread Brian Sullivan
I've got a property on a persistent object that's a float in .NET, mapped as a System.Single via Fluent NH, to a float column in a SQL Server database. When I save my entity, I get values in this float column that are slightly off. Say, if the user enters .65, I get 0.64976158142 stored in th

[nhusers] Re: Equivalent of CountDistinct projection in NHibernate.Linq

2009-08-12 Thread Brian Sullivan
aging Microsoft or the NHibernate team to make "count(distinct x)" in the resulting SQL query possible thru LINQ? On Aug 11, 2:35 pm, Brian Sullivan wrote: > Thanks, Tuna!  Good to know.  I may just have to stick with my > Criteria queries for now. > > On Aug 11, 11:07 am, T

[nhusers] Re: Equivalent of CountDistinct projection in NHibernate.Linq

2009-08-11 Thread Brian Sullivan
gs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > On Tue, Aug 11, 2009 at 7:04 PM, Brian Sullivan wrote: > > > > > > > No takers?  If I need to provide clarification on something, I'd be > > more than happy to.  I still can't figure this out! > > &g

[nhusers] Re: Equivalent of CountDistinct projection in NHibernate.Linq

2009-08-11 Thread Brian Sullivan
No takers? If I need to provide clarification on something, I'd be more than happy to. I still can't figure this out! On Aug 8, 5:15 pm, Brian Sullivan wrote: > I'm in the midst of trying to replace a the Criteria queries I'm using > for a multi-field search page w

[nhusers] Equivalent of CountDistinct projection in NHibernate.Linq

2009-08-08 Thread Brian Sullivan
I'm in the midst of trying to replace a the Criteria queries I'm using for a multi-field search page with LINQ queries using the new LINQ provider. However, I'm running into a problem getting record counts so that I can implement paging. I'm trying to achieve a result equivalent to that produced

[nhusers] Re: Why is NHibernate doing an Update when I Databind?

2009-06-29 Thread Brian Sullivan
Contacts. Thanks for the help! It's wonderful to see such a responsive community around a tool like this! Eat your heart out, StackOverflow! ;-) -Brian On Jun 29, 3:13 pm, Oskar Berggren wrote: > 2009/6/29 Brian Sullivan : > > > > > Oskar, > > > Thanks for the re

[nhusers] Re: Why is NHibernate doing an Update when I Databind?

2009-06-29 Thread Brian Sullivan
lumn somewhere being coerced into an > empty string, which NHibernate then sees as a dirty object. Or the > other way around. Does this happen even if you comment out the two > rows involving dlContact, but call ToList() on contacts to force it to > "materialize"? > > /Os

[nhusers] Why is NHibernate doing an Update when I Databind?

2009-06-29 Thread Brian Sullivan
I'm starting to play with NHibernate to make a case for its use in our company's projects. I've created a branch of one of our solutions and have started to convert some of the data access to using NHibernate as a proof-of-concept. However, while looking at SQL Profiler, I discovered that NHiberna