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-using-stored-procedures http://stackoverflow.com/questions/676997/object-relational-mappers-in-net-and-stored-procedure-usage 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-castle-activerecord 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#. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
