I personally see using procs for your crud operations as a waste of time and defeats the use of the Orm anyway.
Fair enough if you have a very complex query use a proc but in 100 percent of my cases I leave nh to generate SQL for me. IMHO this is 1 of the reasons why I am using an orm to begin with. In terms of performance by executed parametized queries and there execution plan is cached by SQL sever so this is not an issue. My 2c Stefan Sedich On 29/12/2008, at 10:09 PM, "Fabio Maulo" <[email protected]> wrote: > 2008/12/28 socamb <[email protected]> > > I can also see some DBAs cringing at SQL generated by an application. > > Do you have some idea about why a generated SQL is worst than an > hand-made SQL ? > (I mean "in general" because you are talking "in general"). > > -- > 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] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
