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?