>When describing llblgen -> nh/arAR - it's fair to assume we mean db first >design when saying that llblgen is database centric and ar is not..
>I think Yes, thank you for clarifying my statement. >I find the whole ORM thing comes crumbling a bit in this scenario - how does >everyone else deal with reporting? I have struggled with this on the last few apps I have written. I usually go with a projection from Criteria or HQL bypassing most of the Entities, or simply injecting the entities into a value object which is set to the report. On Apr 8, 9:10 am, 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/UnitTestingWithNHibernateAc... > > ). 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/ShouldYouUseNHibernateWithS... > > > 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 -~----------~----~----~----~------~----~------~--~---
