SSRS?!?! - HAHAHAHHA jokes yeah?
No, seriously, hahhahahha oh man you're killing me... On Wed, Apr 8, 2009 at 2:34 PM, Colin Ramsay <colinram...@gmail.com> wrote: > > 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 <wa...@codingvista.com> > 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 > > <mauricioschef...@gmail.com> 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 <novnov...@gmail.com> 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 <mauricioschef...@gmail.com> > >> > 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 <novnov...@gmail.com> 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:// > > > > > > > > > > > > -- 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 castle-project-users@googlegroups.com To unsubscribe from this group, send email to castle-project-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
