I hate reading (and hence writing) those kinds of replies, but since Fabio already mentioned it as:
> *Legacy-DB + strongly DBA restriction = legacy DAL* = big PITA > I think his post is into more details about the same point really (worth reading): http://fabiomaulo.blogspot.com/2009/06/database-eliot-ness-of-it.html However, in the case when restriction means SPROCs with OUT parameters, I think you have more options than just "legacy DAL". LLBLGen Pro ORM for example tries pretty much to make SPROCs a relatively easy task. Also, LINQ To SQL works with output parameters, but of course we still have the DB2 restriction so don't count this one. Entity Framework (.NET 3.5) has some workarounds to work with output parameters (sample), Entity Framework (.NET 4.0. pre-release) works naitvely as I understand. The point I'm trying to make is that yes, it's great if you support what you believe is "right",but to expect that everyone who does not follow this would naturally suffer and this would be the normal way of the world, is not an accurate point of view, although so common in ALT.NET kind of lists (which I really like and respect, same as I like and respect all the guys in this thread). Regards, -- Mohamed Meligy Senior Developer, Team Lead Backup (.Net Technologies - TDG - Applications) Injazat Data Systems P.O. Box: 8230 Abu Dhabi, UAE. Phone: +971 2 6992700 Direct: +971 2 4045385 Mobile: +971 50 2623624, +971 55 2017 621 E-mail: [email protected] Weblog: http://weblogs.asp.net/meligy On Mon, Feb 1, 2010 at 4:28 PM, Fabio Maulo <[email protected]> wrote: > you can do it using CreateSQLQuery (probably but I'm not so sure). > Legacy-DB + strongly DBA restriction = legacy DAL = big PITA > > 2010/2/1 Asier <[email protected]> > > Hi to all. >> >> The reason for my question was that, I am working with a legacy DB >> (IBM DB2). There is an access restriction, and we can only use stored >> procedures. I thought NHibernate was a good approach for this but >> maybe no. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> >> > > > -- > Fabio Maulo > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en.
