Nhibernate select query with subquery?

Question

I am new to Nhibernate with C#.

Here is my SQL query:

select * from advis_productattributes where ID in 
(select attributeid from advis_productattributes_products where productid=1);

I know about simple select query in HQL:

string hql = @"select p from ProductAttributes_Products p.ProductId :id"; 
var query = new SimpleQuery<ProductAttributes_Products>(hql); 
query.SetParameter("id", ProductId); 
return query.Execute();

I have searched on net but remained failure. How do I write HQL with a subquery?

Here is design of classes. enter image description here

Could you show related model classes?

Claudio Redi
– Claudio Redi

2012-07-03 01:28:17 +00:00
Commented Jul 3, 2012 at 1:28 — Claudio Redi
– Claudio Redi, Commented Jul 3, 2012 at 1:28
@ClaudioRedi I have updated question with diagrame. Thanks

user576510
– user576510

2012-07-03 01:36:42 +00:00
Commented Jul 3, 2012 at 1:36 — user576510
– user576510, Commented Jul 3, 2012 at 1:36

Community · Accepted Answer · 2017-05-23 10:30:28Z

1

I believe you can accomplish this by using NHibernate LINQ. Please refer these Stack overflow Answer #1 and Answer #2

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Jul 3, 2012 at 1:47

Aravinth Kannan

5356 silver badges8 bronze badges

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

2 Comments

user576510 Over a year ago

Thanks @Aravinth Kannan, I am sorry I am fist day with NHibarnate. Is Nhibarnate Linq Linq for Nhibarnate ? Will I need some other classes/ controls to use it ? thanks

Aravinth Kannan Over a year ago

Hi, you don't need any additional controls to use Linq for NHibernate. It all bundled with you NHibernate library. You can refer this Tutorial to start with..

Diego Mijelshon · Accepted Answer · 2012-07-03 13:54:32Z

0

I don't know exactly where on the net you searched... but the official docs have all you need to know about subqueries in HQL

It's pretty much the same as SQL.

answered Jul 3, 2012 at 13:54

Diego Mijelshon

52.7k16 gold badges119 silver badges159 bronze badges

Collectives™ on Stack Overflow

Nhibernate select query with subquery?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related