NHibernate 3 LINQ not assigning variables correctly

2 views
Skip to first unread message

Chris

unread,
Sep 17, 2010, 3:57:37 PM9/17/10
to nhusers
Hello,

I'm attempting to use NHibernate 3.0.0 Alpha 2 and I'm running into
issues with the LINQ provider. If I do a simple query such as

var query = rep.AvailableProjects.Where(o => o.RequestorId ==
searchDto.RequestorId && o.ProcessCd == searchDto.ProcessCd);

I get the following SQL as output:

select table0_.REQUESTOR_ID as REQUESTOR21_, table0_.PROCESS_CD as
EVENT1_21 from TABLE table0_ where ((table0_.REQUESTOR_ID is null) and
(:p0 is null) or table0_.REQUESTOR_ID=:p0) and ((table0_.PROCESS_CD is
null) and (:p1 is null) or table0_.PROCESS_CD=:p1)

Now that SQL looks correct but NHibernate somehow is messing up the
bind variables. It thinks they are the following:

Name:p1 - Value:10773 Name:p2 - Value:D

Technically p1 SHOULD be labeled as p0 and p2 SHOULD be labeled as p1.

Can anyone provide me with any guidance on why something like this is
happening and what I can do to overcome this?
Reply all
Reply to author
Forward
0 new messages