Thanks, I will play around with it a bit and see how I like the results. I knew it was possible to map a View I just wanted to see if people thought it was a good idea.
Chris On Mon, Jun 15, 2009 at 2:01 PM, Fabio Maulo <[email protected]> wrote: > Sorry ... I meanyou can use a view *with or without* a specific mapped > entity. > > 2009/6/15 Fabio Maulo <[email protected]> > > In general an HQL is enough, btw you can use a view with our with a >> specific mapped entity.If you want use an entity2view remember to use >> schema-action="none". >> >> 2009/6/15 Chris Nicola <[email protected]> >> >> I am wondering if this is sensible in a "best practices" sense. I have >>> what is pretty much a reporting situation with data being displayed to the >>> user inside my WPF app. The query required involves a slightly compliated >>> group by and sum query which is pretty easy for me to do in SQL as a view, >>> but is a fair bit more complex to do using simply Criteria or HQL. The >>> results are obviously read-only. >>> >>> I have heard it said that you should use nHibernate for CRUD but to use >>> something else for reporting. However, I was wondering if creating this >>> query as a read-only SQL View and loading it into a custom entity using >>> nHibernate would be a simple and sensible approach. If not, perhaps someone >>> could offer how they might solve this problem. >>> >>> Thanks, >>> Chris >>> >>> >>> >> >> >> -- >> Fabio Maulo >> > > > > -- > 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] 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 -~----------~----~----~----~------~----~------~--~---
