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 -~----------~----~----~----~------~----~------~--~---
