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