Zdravim,

valcim dneska s NHibernatem a mam tento dotaz:

ISQLQuery = sesssion.createSQLQuery("SELECT DISTINCT Station_W.*" +
" FROM BasinSchema_W INNER JOIN" + " Channel_W ON BasinSchema_W.id = Channel_W.basinSchemaId INNER JOIN" + " Station_W ON Channel_W.endRiverStationId = Station_W.id OR Channel_W.sourceRiverStationId = Station_W.id" + " WHERE (BasinSchema_W.id = :id)").AddEntity(typeof (RiverStation));

Problem mam v tom, ze to ma vratit vsechny stanice, ktere jsou jak pocatecni, tak koncove na kanalech daneho schematizace povodi. V HQL se mi to podarilo pres 2 dotazy a ty pak sloucit v HashedSetu, ale radeji bych neco peknejsiho nez tento SQL nebo 2 HQL.
Jde to vubec? V manualu jsem nic podobneho nenasel.

Lumi(r)

P.S. EndRiverStation na associaci mezi channel-riverstation 1-1 a SourceRiverStation 1-0..1 a BasinSchema-channel aggreguje na 1-*
(Notace : kardinality u trid v  UML diagramu)

Odpovedet emailem