Details
Details
Assignee
Unassigned
UnassignedReporter
Chris Martindale
Chris Martindale(Deactivated)Labels
Components
Affects versions
Priority
Who's Looking?
Open Who's Looking?
Created September 17, 2010 at 1:06 PM
Updated September 9, 2014 at 1:02 PM
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 against an Oracle instance 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 (0 is null) or table0_.REQUESTOR_ID=0) and ((table0_.PROCESS_CD is null) and (1 is null) or table0_.PROCESS_CD=1)
Now that SQL looks correct but NHibernate somehow is messing up the bind variables. It thinks they are the following:
Name1 - Value:10773 Name2 - Value
Technically p1 SHOULD be labeled as p0 and p2 SHOULD be labeled as p1.