session.CreateSQLQuery("...").SetParameter("key", value).List<Dto>();
or you can embed the query in a mapping file
<sql-query name="query unmapped tables">
select field1, field2 from table where ...
</sql-query>
and access the query by name
session.GetNamedQuery("query unmapped tables").SetParameter("key",
value).List<Dto>();
On Nov 10, 3:19 pm, Monkfish <[email protected]> wrote:
> I'm new to nhibernate and I'm stumped by something that I believe
> should be easy to achieve. Essentially I have 2 tables in my model,
> say Company and Employee, representing a one to many relationship. I
> want to filter the employee rows returned based on values from a
> third
> table that I do not want to include in my model (as I need no data
> from it). Is this possible, I can't see an obvious solution.
>
> Essentially I'm trying to achieve a join such as:
>
> SELECT *
> FROM
> company c
> JOIN employee e ON e.companyid = c.companyid
> JOIN payroll p ON p.employee = c.employeeid
> WHERE
> p.blah = 'blah'
>
> Any help greatfully recieved.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
