One use case that comes to mind is having stored procedures that implement full-text search. Those are the only stored procedures we've got in my current project - everything else uses the orm.
Chad Myers wrote: > It's certainly lower priority, I'll give you that. > > But using stored procedures with NHibernate has some friction and opportunity > for typos, misnaming, etc, so I think there's value that FN could add here > somehow to help reduce typos and such. > > -c > > ________________________________ > > From: fluent-nhibernate@googlegroups.com on behalf of Ayende Rahien > Sent: Tue 12/23/2008 9:49 AM > To: fluent-nhibernate@googlegroups.com > Subject: [fluent-nhib] Re: Stored Procedure automapping > > > Why? > This is certainly not something that can be called fluent. You allow to mix & > match xml & fluent config anyway. > I would say that this should be out of scope for FN > > > On Tue, Dec 23, 2008 at 4:49 PM, Chad Myers <c...@chadmyers.com> wrote: > > > > Hey now, there are a few reasons you might use an sp with nhib. And > anyhow, nhib supports it, so should we. > > > ---------------------- > Sent from my phone. Please excuse typos and extra characters > > > -----Original Message----- > From: Paul Batum <paul.ba...@gmail.com> > Sent: Tuesday, December 23, 2008 3:48 AM > To: fluent-nhibernate@googlegroups.com > <fluent-nhibernate@googlegroups.com> > Subject: [fluent-nhib] Re: Stored Procedure automapping > > Ahh I see. That looks ok. > > Of course, it won't protect you from changes made on the SP side, but > thats > one of the many reasons why we both hate SP's, isnt it! > > On Tue, Dec 23, 2008 at 8:40 PM, James Gregory <jagregory.com > <http://jagregory.com/> @gmail.com <http://gmail.com/> >wrote: > > > Chris, really, why would you want to use stored procedures in > NHibernate? > > @Paul: I'd say the return-property element could be mapped using > > expressions. > > > > Something along the lines of: > > > > class EmploymentMap : ClassMap<Employment> > > { > > public EmploymentMap() > > { > > Map(x => x.Employee); > > Map(x => x.Employer); > > > > SqlQuery("selectAllEmployments_SP", sql => > > { > > sql.Return > > .Property(x => x.Employee, "EMPLOYEE") > > .Property(x => x.Employer, "EMPLOYER"); > > > > sql.Text = "exec selectAllEmployments"; > > }); > > } > > } > > > > It's not brilliant, but it wouldn't break with renaming of > properties. I vehemously > > oppose using stored procedures, but this feature can also be applied > to > > performance tweaked sql queries, so it's probably something we should > pursue > > at some point. > > > > > > On Tue, Dec 23, 2008 at 3:47 AM, Paul Batum <paul.ba...@gmail.com> > wrote: > > > >> It looks like its all strings and none of it would be derivable from > the > >> domain model. I'm struggling to imagine an API that would be worth > it. Did > >> you have any ideas? > >> > >> > >> On Tue, Dec 23, 2008 at 10:52 AM, Chris Marisic > <chrismari...@hotmail.com > >> > wrote: > >> > >>> > >>> This is a mapping I found quick online > >>> > >>> <sql-query name="selectAllEmployments_SP"> > >>> <return alias="emp" class="Employment"> > >>> <return-property name="employee" column="EMPLOYEE"/> > >>> <return-property name="employer" column="EMPLOYER"/> > >>> <return-property name="startDate" column="STARTDATE"/> > >>> <return-property name="endDate" column="ENDDATE"/> > >>> <return-property name="regionCode" column="REGIONCODE"/> > >>> <return-property name="id" column="EID"/> > >>> <return-property name="salary"> > >>> <return-column name="VALUE"/> > >>> <return-column name="CURRENCY"/> > >>> </return-property> > >>> </return> > >>> exec selectAllEmployments > >>> </sql-query> > >>> > >>> > >> > >> > >> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to fluent-nhibernate@googlegroups.com To unsubscribe from this group, send email to fluent-nhibernate+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
