SQL query to criteria nhibernate

Question

Hello. I have a problem with the creation of a Hibernate Criteria object. I'm new to Hibernate.

Can someone help me with the creation of a complex Criteria object and explain how this is done? Here is the sample SQL select statement to emulate:

select * from Company join Employees on Company.IDCompany = Employees.IDCompany;

i wanna make criteria from that sql query with all prosperties of Company and all properties of Employees that join on IDCompany. return as ICollection or IList — Endiss, Mar 19 '12 at 15:11
what do u mean? Do you want c# properties declarations of 2 classes? — Endiss, Mar 19 '12 at 15:20
We can't assume questions and give answers here.... U need to post the question properly.... — Teja, Mar 19 '12 at 15:21
Have you done the slightest bit of research before asking? The [docs](http://www.nhforge.org/doc/nh/en/index.html#querycriteria) would be a good place to start — Diego Mijelshon, Mar 19 '12 at 17:26
Thx i was looking for that, and yes i was looking whole day... Starts are always bad;) — Endiss, Mar 19 '12 at 19:59

Anton · Accepted Answer · 2012-03-19T15:28:46.353

1

If you user NH3 you can use QueryOver instead of ICriteria, as for me QueryOver expressions are better than ICriteria strings.

Session.QueryOver<Company>()
 .JoinQueryOver(company => company.Employees)
 .Where(...) // some restrictions
 .List<Company>();

http://nhforge.org/blogs/nhibernate/archive/2009/12/17/queryover-in-nh-3-0.aspx

edited Mar 19 '12 at 15:28

answered Mar 19 '12 at 15:23

Anton

1,583
12
17

session.QueryOver().JoinQueryOver((Company=> Company.Employees)).Where(Company.IDCompany = Employees.IDCompany).List(); It show's me that Connot resolve symbol Employees so it wont work;/ – Endiss Mar 19 '12 at 15:34
"Employees" should be a class property name, for example: class Company { public virtual Employee Employees { get; set; } } – Anton Mar 19 '12 at 15:38

SQL query to criteria nhibernate

1 Answers1