Hello al, I'm new to the NHibernate world and am trying to convert the
following sql statement to QueryOver. I've not had much success using
google to find what i need. Here is the statement. Thanks in advance.
select
CommunicationMaster.CommunicationID as CommunicationID,
Staff.StaffID as StaffID,
CommunicationDetail.Status as Status
from
dbo.[shr_PC_Communication] CommunicationMaster
inner join
dbo.[shr_PC_Communication_Detail] CommunicationDetail
on
CommunicationMaster.CommunicationID=CommunicationDetail.CommunicationID
left outer join
dbo.[shr_Staffs] Staff
on CommunicationDetail.StaffID=Staff.StaffID
where
(
CommunicationMaster.Created_Date between @p0 and @p1
)
and (
CommunicationMaster.IsRemoved is null
)
and (
CommunicationDetail.IsArchived is null
)
and (
CommunicationDetail.Status in (
@p3
)
)
and (
Staff.StaffID in (
@p4
)
);
--
---
You received this message because you are subscribed to the Google Groups
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
