views:

34

answers:

0

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?