how to write nhibernate query for this sql statement

Question

How can I write a fluent nhibernate query for the below SQL query statement :

select iseat.companynr, mdata.Employeenr from IDepartment as iseat inner join 
Employee as i on i.pkey = iseat.employeefk 
inner join employeedata as edata on edata.employeefk = i.pkey

I have already created classes IDepartment , Employee and Employeedata and also I have created a class CompanyNr2EmployeeNrMap , which contains 2 properties CompanyNr and EmployeeNr.

The query needs to take a list of companynr as parameters and return a list of CompanyNr2EmployeeNrMap.

Firo · Accepted Answer · 2013-09-26 14:33:33Z

1

var query = from emp in session.Query<Employee>()
            from department in emp.Departments
            select new CompanyNr2EmployeeNrMap
            {
                CompanyNr = department.CompanyNr,
                EmployeeNr = emp.Data.EmployeeNr
            };

return query.ToList();

answered Sep 26, 2013 at 14:33

Firo

30.8k4 gold badges57 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to write nhibernate query for this sql statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related