nHibernate/Fluent - SQL Query Question

Question

I am new to nHibernate. I understand how to use mapping using Fluent nHibernate. Now I would like to use a little more complex query. However I am not sure how I would map or even approach this. Here is what I would like to do in an sql query:

SELET 
  Zone,
  CountOfStyles = (Select Count(1) from anotherTable Where StoreZoneId = zone.ZoneID),
  ZoneId,
  ZoneTitle,
  ZoneDescription
FROM
  Zones

How would I map this using fluent nHibernate?

mxmissile · Accepted Answer · 2009-10-30 16:21:36Z

2

I think this might get you started...

UPDATE:

mapping

Map(x => x.CountOfStyles).Formula("(Select Count(1) from anotherTable Where StoreZoneId = ZoneID)");

edited Oct 30, 2009 at 16:21

answered Oct 30, 2009 at 15:14

mxmissile

11.7k6 gold badges57 silver badges85 bronze badges

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

5 Comments

Darren Kopp Over a year ago

he wants the count to be part of the query for the entity, not to eager load the list of styles just to get the count.

vikasde Over a year ago

I could do that, but the whole idea to use nhibernate was to get away from views/sprocs. There is no other way? My query is not really complex :)

mxmissile Over a year ago

Just found this: stackoverflow.com/questions/887474/…

mxmissile Over a year ago

And more here... ayende.com/Blog/archive/2006/12/26/…

vikasde Over a year ago

I got it working. Since both of my fields are called the same in both tables, I did not know exactly how to use the parent field. I just had to add the anotherTable into the where clause. Map(x => x.CountOfStyles).Formula("(Select Count(1) from anotherTable Where anotherTable.StoreZoneId = ZoneID)");

Collectives™ on Stack Overflow

nHibernate/Fluent - SQL Query Question

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related