I think NHibernate projections and Transformers.AliasToBean would let you pick out the columns you want and bring them back into an arbitrary C# object. That's not to say this would be the best approach. I've even seen a method for using NHibernate to power SSRS, though why you'd want to inflict SSRS on yourself is beyond me.
On Wed, Apr 8, 2009 at 2:10 PM, Wayne Douglas <[email protected]> wrote: > Stored procedures allow you to easilly shape data the way you need - very > handy for reporting apps - I find the whole ORM thing comes crumbling a bit > in this scenario - how does everyone else deal with reporting? > > w:// > > On Wed, Apr 8, 2009 at 2:05 PM, Mauricio Scheffer > <[email protected]> wrote: >> >> One of the main features of NHibernate and other ORMs is that they let >> you work against any RDBMS transparently. If you change the database >> engine, all you have to do is change a single line of configuration. >> This feature is also very convenient for testing (see >> >> http://ayende.com/Blog/archive/2006/10/14/UnitTestingWithNHibernateActiveRecord.aspx >> ). If you use stored procedures, you lose that ability. >> >> If you call your procedures directly from a IDbConnection, you lose >> NHibernate's caching. >> >> Also take a look at >> http://ayende.com/Blog/archive/2006/10/04/ShouldYouUseNHibernateWithStoredProcedure.aspx >> >> On Apr 7, 3:43 pm, novnov <[email protected]> wrote: >> > One thing you mentioned was that procedures would make it much harder >> > to change databases. Can you shed some more light on that? Obviously >> > sprocs vary in how the work across dbs. Assuming that we're willing to >> > maintain two sets of sprocs, oracle and postgres, is there any reason >> > that an ORM couldn't use the procs from either? >> > >> > On Apr 5, 6:33 pm, Mauricio Scheffer <[email protected]> >> > wrote: >> > >> > >> > >> > > Well, I don't know if this is the right place to ask such a >> > > question... I mean, this is a Castle / ActiveRecord list so many of us >> > > are happily using ActiveRecord, therefore the answers will probably be >> > > biased. >> > >> > > Stackoverflow has a lot of questions about ORM >> > > (http://stackoverflow.com/questions/tagged/orm), many are concrete >> > > about support of stored procedures: >> > >> > >> > > >http://stackoverflow.com/questions/687762/which-orm-is-the-best-when-...... >> > >> > > and recommendations: >> > >> > >http://stackoverflow.com/questions/660743/what-orm-would-you-recommend >> > >> > > and opinions on ActiveRecord: >> > >> > >> > > >http://stackoverflow.com/questions/516238/whats-your-opinion-of-castl... >> > >> > > That said, I've been using NHibernate and ActiveRecord for years and >> > > they've never let me down. NHibernate is not trivial but it's very >> > > flexible. >> > >> > > About sproc support, it really depends on what level of integration >> > > you need. I don't know about postgresql specifically but you can >> > > always get a raw IDbConnection from ActiveRecord and do anything you >> > > want with it. But if you really need to deploy to different databases, >> > > sprocs are obviously not the way to go. >> > >> > > And yes, ActiveRecord works just fine in VB.NET. Here's some sample >> > > code:http://forum.castleproject.org/viewtopic.php?t=5102 >> > >> > > I recommend that you try NHibernate, ActiveRecord, Subsonic, etc and >> > > judge for yourself. >> > >> > > On Apr 5, 4:31 pm, novnov <[email protected]> wrote: >> > >> > > > This is really a scattershot question because I have little exposure >> > > > to ORMs and only vaguely formulated requirements. >> > >> > > > Some background...I like postgresql a lot and also use sql server >> > > > and >> > > > oracle. I/we are usually responsible for all of the parts of an app, >> > > > from the rdbms to the user interface. We do a lot on Windows with >> > > > .net >> > > > (visual basic) but are getting exposure to flex on the interface >> > > > side >> > > > of things. So far we've been able to keep clear of ORMs and code >> > > > generators. >> > >> > > > A project is coming up which will need be be deployed against both >> > > > postgresql and oracle (different deploys). This may be forcing us to >> > > > use an ORM so that the interface is more independent of the rdbms. >> > >> > > > Is NHibernate and maybe Castle Project Active Record a good solution >> > > > for our needs? The ORM would not have to be open source, ie we could >> > > > buy something. We want it to be as simple to pick up and use as >> > > > possible. We don't want to lose the ability to execute procs in >> > > > postgres and I'm worried that nhibernate has that limitation, as the >> > > > front page states that stored procedures are supported for sql >> > > > server. >> > >> > > > Finally, is Active Record ok with visual basic? Most if not all of >> > > > the >> > > > examples are in C#.- Hide quoted text - >> > >> > > - Show quoted text - >> >> > > > > -- > Cheers, > > w:// > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
