Your better off using some sort of serialization method to convert your objects to xml _after_ they have been loaded from your query. For example:
1. Have objects you wish to serialize to xml implement IXmlSerializable - http://msdn.microsoft.com/en-us/library/system.xml.serialization.ixmlserializable.aspx 2. Load objects from your db via query from NH 3. Serialize objects to Xml (document, stream, string...whatever) 4. Apply XmlTransform to that output Alternatively you could use Linq to Xml to convert query results to Xml as well - http://msdn.microsoft.com/en-us/library/bb387098.aspx As far as using FOR XML in the database...that is the domain of the DBA, not the developer. -Jeff On Sat, Nov 6, 2010 at 10:32 PM, Fabio Maulo <[email protected]> wrote: > - Too much work for one guy (data server). > - Instead work with your domain object graph you will end working with > Table+Column (2 dimensions) > - A little change in persistence representation will mean a change in your > query > - and so on... > > btw... Taste is taste > > -- > Fabio Maulo > > > El 06/11/2010, a las 06:39, SAMI AKKUS <[email protected]> escribió: > > I am developing CMS. I have a domain model. in addition, I want to take > some data as xml and transform it. I dont want add extra ado jobs to my DAL. > Therefore I need such a spesification. > > Thank you very much. > > > 2010/11/6 Fabio Maulo < <[email protected]>[email protected]> > >> NHibernate returns entities or projections. If you don't use 'TYPE', as >> seems to be your case, you should be able to catch the result as a scalar of >> type string (you have to assign an alias to the result). >> >> After do that, ask yourself why you are using NHibernate to get such >> result. >> >> On Fri, Nov 5, 2010 at 7:33 PM, SAMI AKKUS < <[email protected]> >> [email protected]> wrote: >> >>> Yes, for example, can I use CreateSQLQuery("SELECT * FROM table FOR >>> XML AUTO"). Then NH returns string or xml. >>> >>> >>> >>> 2010/11/6 Fabio Maulo < <[email protected]>[email protected]> >>> >>>> directly from the RDBMS and not from your domain, right ? >>>> >>>> >>>> On Fri, Nov 5, 2010 at 7:09 PM, SAMI AKKUS < <[email protected]> >>>> [email protected]> wrote: >>>> >>>>> Yes i want to take data as XML and transform with xslt. >>>>> 2010/11/5, Fabio Maulo < <[email protected]>[email protected]>: >>>>> > let me understand... >>>>> > what you are looking for is create an XML directly from the data in >>>>> the DB ? >>>>> > >>>>> > On Fri, Nov 5, 2010 at 3:51 PM, zamix < <[email protected]> >>>>> [email protected]> wrote: >>>>> > >>>>> >> How can I write queries in NH, which end with FOR XML AUTO or FOR >>>>> XML >>>>> >> RAW. >>>>> >> >>>>> >> -- >>>>> >> You received this message because you are subscribed to the Google >>>>> Groups >>>>> >> "nhusers" group. >>>>> >> To post to this group, send email to <[email protected]> >>>>> [email protected]. >>>>> >> To unsubscribe from this group, send email to >>>>> >> <nhusers%[email protected]> >>>>> [email protected]< >>>>> nhusers%[email protected]<nhusers%[email protected]> >>>>> > >>>>> >> . >>>>> >> For more options, visit this group at >>>>> >> <http://groups.google.com/group/nhusers?hl=en> >>>>> http://groups.google.com/group/nhusers?hl=en. >>>>> >> >>>>> >> >>>>> > >>>>> > >>>>> > -- >>>>> > Fabio Maulo >>>>> > >>>>> > -- >>>>> > You received this message because you are subscribed to the Google >>>>> Groups >>>>> > "nhusers" group. >>>>> > To post to this group, send email to <[email protected]> >>>>> [email protected]. >>>>> > To unsubscribe from this group, send email to >>>>> > <nhusers%[email protected]> >>>>> [email protected]. >>>>> > For more options, visit this group at >>>>> > <http://groups.google.com/group/nhusers?hl=en> >>>>> http://groups.google.com/group/nhusers?hl=en. >>>>> > >>>>> > >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "nhusers" group. >>>>> To post to this group, send email to <[email protected]> >>>>> [email protected]. >>>>> To unsubscribe from this group, send email to >>>>> <nhusers%[email protected]> >>>>> [email protected]. >>>>> For more options, visit this group at >>>>> <http://groups.google.com/group/nhusers?hl=en> >>>>> http://groups.google.com/group/nhusers?hl=en. >>>>> >>>>> >>>> >>>> >>>> -- >>>> Fabio Maulo >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "nhusers" group. >>>> To post to this group, send email to <[email protected]> >>>> [email protected]. >>>> To unsubscribe from this group, send email to >>>> <nhusers%[email protected]> >>>> [email protected]. >>>> For more options, visit this group at >>>> <http://groups.google.com/group/nhusers?hl=en> >>>> http://groups.google.com/group/nhusers?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "nhusers" group. >>> To post to this group, send email to <[email protected]> >>> [email protected]. >>> To unsubscribe from this group, send email to >>> <nhusers%[email protected]> >>> [email protected]. >>> For more options, visit this group at >>> <http://groups.google.com/group/nhusers?hl=en> >>> http://groups.google.com/group/nhusers?hl=en. >>> >> >> >> >> -- >> Fabio Maulo >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to <[email protected]> >> [email protected]. >> To unsubscribe from this group, send email to >> <nhusers%[email protected]> >> [email protected]. >> For more options, visit this group at >> <http://groups.google.com/group/nhusers?hl=en> >> http://groups.google.com/group/nhusers?hl=en. >> > > -- > 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. > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- 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.
