Thank you, Sir!!!! Now it works!!
Many Thanks. antoschka On 13 Feb., 03:48, Ayende Rahien <[email protected]> wrote: > "BusinessObjects.Order,BusinessObjects" > > Missing space between Order, and Business objects? > > On Fri, Feb 13, 2009 at 4:46 AM, antoschka <[email protected]> wrote: > > > After I solved my performance Problem I'd like to exctract the sql in > > a named sql > > The SQL Statement looks like that: > > SELECT > > Order.*, > > OrderItem.Type, > > Order.Type, > > OrderItem.ValidFrom, > > OrderItem.ValidTo > > FROM > > Order > > INNER JOIN OrderItem ON > > Order.Type = OrderItem.Type AND > > Order.SubType = OrderItem.SubType > > WHERE > > (OrderItem.Type = 'bundled') AND > > (Order.Type = 'new') AND > > (OrderItem.ValidFrom < DateTime.TODAY) AND > > (OrderItem.ValidTo > DateTime.TODAY) > > > I created an hbm.xml file as embetted ressource (copy always to output > > folder) and created a the following contents > > <?xml version="1.0" encoding="utf-8" ?> > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> > > <sql-query name="ValidOrders" cacheable="false" read-only="true"> > > <return alias="order" > > class="BusinessObjects.Order,BusinessObjects"/> > > <![CDATA[ > > SELECT > > {order.*} > > FROM > > Order {order} > > INNER JOIN OrderItem ON > > Order.Type = OrderItem.Type AND > > Order.SubType = OrderItem.SubType > > WHERE > > (OrderItem.Type = :orderItemType) AND > > (Order.Type = :orderType) AND > > (OrderItem.ValidFrom < :dateTimeNow) AND > > (OrderItem.ValidTo > :dateTimeNow) > > ]]> > > </sql-query> > > </hibernate-mapping> > > for some reason I get an error message while I open the session: > > Could not load type Order. Possible cause: no assembly name specified. > > > What am I doing wrong with in my named SQL approach? > > > Thank you so much in advance for reading that and maybe you find some > > time for feedback. > > > Thanks > > > antoschka > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
