Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Mapping Stored Procedures
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  13 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Calin  
View profile  
 More options Oct 6, 3:21 pm
From: Calin <calinusw...@gmail.com>
Date: Tue, 6 Oct 2009 12:21:48 -0700 (PDT)
Local: Tues, Oct 6 2009 3:21 pm
Subject: Mapping Stored Procedures
Hi,

 Does Fluent support mapping store procedures ?
 I've found 2 possibilities:
 - http://merbla.blogspot.com/2009/02/fluent-nhibernate-with-stored.html,
mixed configuration, I don't like it very much because is not very
'fluent'
 - http://maonet.wordpress.com/2009/05/06/create-your-own-parts-to-merge...,
and this implementation but I am not very sure it helps.

Regards,


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Paul Batum  
View profile  
 More options Oct 7, 6:39 am
From: Paul Batum <paul.ba...@gmail.com>
Date: Wed, 7 Oct 2009 21:39:10 +1100
Local: Wed, Oct 7 2009 6:39 am
Subject: Re: [fluent-nhib] Mapping Stored Procedures

Yeah we don't have any support for stored procedures yet so the first link
is the way to go in the meantime.


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Calin  
View profile  
 More options Oct 7, 8:47 am
From: Calin <calinusw...@gmail.com>
Date: Wed, 7 Oct 2009 05:47:20 -0700 (PDT)
Local: Wed, Oct 7 2009 8:47 am
Subject: Re: Mapping Stored Procedures
Hi Paul,

 Thank you for your answer.
 Are you planning to add this in the near future ?

Regards,

On Oct 7, 1:39 pm, Paul Batum <paul.ba...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Hudson Akridge  
View profile  
 More options Oct 7, 9:03 am
From: Hudson Akridge <hudson.akri...@gmail.com>
Date: Wed, 7 Oct 2009 08:03:54 -0500
Local: Wed, Oct 7 2009 9:03 am
Subject: Re: [fluent-nhib] Re: Mapping Stored Procedures

One of the ongoing goals of FNH has always been parity with NH. So yes,
we're planning on adding this feature in. Along with a couple other features
of NH we don't currently support.

--
- Hudson
http://www.bestguesstheory.com
http://twitter.com/HudsonAkridge

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
James Gregory  
View profile  
 More options Oct 7, 9:09 am
From: James Gregory <jagregory....@gmail.com>
Date: Wed, 7 Oct 2009 14:09:17 +0100
Local: Wed, Oct 7 2009 9:09 am
Subject: Re: [fluent-nhib] Re: Mapping Stored Procedures

"Near future" may not be the case though. Future perhaps, near future
probably not.

On Wed, Oct 7, 2009 at 2:03 PM, Hudson Akridge <hudson.akri...@gmail.com>wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
James Newton-King  
View profile  
 More options Oct 7, 5:15 pm
From: James Newton-King <james.newtonk...@gmail.com>
Date: Wed, 7 Oct 2009 14:15:10 -0700 (PDT)
Local: Wed, Oct 7 2009 5:15 pm
Subject: Re: Mapping Stored Procedures
I'd like to voice my support for this to be added. It is a shame that
we have to mix and match both approaches currently.

On Oct 8, 2:09 am, James Gregory <jagregory....@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
James Gregory  
View profile  
 More options Oct 7, 6:21 pm
From: James Gregory <jagregory....@gmail.com>
Date: Wed, 7 Oct 2009 23:21:49 +0100
Local: Wed, Oct 7 2009 6:21 pm
Subject: Re: [fluent-nhib] Re: Mapping Stored Procedures

Patches are welcome :)

On Wed, Oct 7, 2009 at 10:15 PM, James Newton-King <


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
FrankM  
View profile  
 More options Nov 5, 4:51 pm
From: FrankM <maodd...@gmail.com>
Date: Thu, 5 Nov 2009 13:51:08 -0800 (PST)
Local: Thurs, Nov 5 2009 4:51 pm
Subject: Re: Mapping Stored Procedures
I have uploaded my patch here: http://podcast.overseakids.com/dotnet/sp.patch

It's based on r647. The example code will look like this:

StoredProcedurePart<T>("sql-insert", INSERT_SP).Check.None();
StoredProcedurePart<T>("sql-update", UPDATE_SP).Check.None();
StoredProcedurePart<T>("sql-delete", DELETE_SP).Check.None();

On Oct 7, 3:21 pm, James Gregory <jagregory....@gmail.com> wrote:


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rob Gibbens  
View profile  
 More options Nov 5, 10:05 pm
From: Rob Gibbens <robgibb...@gmail.com>
Date: Thu, 5 Nov 2009 19:05:30 -0800 (PST)
Local: Thurs, Nov 5 2009 10:05 pm
Subject: Re: Mapping Stored Procedures
I blogged about this a few days ago.

http://robgibbens.blogspot.com/2009/10/nhibernate-sql-query-with-stor...

On Oct 6, 2:21 pm, Calin <calinusw...@gmail.com> wrote:


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Paul Batum  
View profile  
 More options Nov 6, 7:08 am
From: Paul Batum <paul.ba...@gmail.com>
Date: Fri, 6 Nov 2009 23:08:42 +1100
Local: Fri, Nov 6 2009 7:08 am
Subject: Re: [fluent-nhib] Re: Mapping Stored Procedures

Hi Frank,

I'm in the process of reviewing your patch, but I'm a bit of a noob when it
comes to using NH with stored procedures so I'm going to have to ask what
may be a dumb question...

Why do you pass the operation type as a string? From what I can tell of the
NH mappings schema, the only valid values are "sql-insert", "sql-update",
"sql-delete", and "sql-delete-all". If thats a case, wouldn't it be better
to use an enum, such as:

StoredProcedure<T>(StoredProcedureType.SqlInsert, INSERT_SP);

or even:

SqlInsert(INSERT_SP);

My concern is that by having the user type in the string, you are requiring
them to have good knowledge of HBM XML, which is something that FNH attempts
to avoid!

Otherwise it looks good! Once we've got this sorted out, I'll write a couple
of tests to demonstrate the fluent interface and get it into the trunk asap.

Thanks,

Paul Batum


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
FrankM  
View profile  
 More options Nov 6, 8:39 am
From: FrankM <maodd...@gmail.com>
Date: Fri, 6 Nov 2009 05:39:56 -0800 (PST)
Local: Fri, Nov 6 2009 8:39 am
Subject: Re: Mapping Stored Procedures
Thanks Paul, You are right, this is a very good improment I should
add. I'll change it to

             SqlInsert(INSERT_SP);

once I back to work. then send you another patch? I just figured out
how to do generationTest for my part.

This solution doesn't cover retrieve. For reading data from SP, please
refer to Rob's way.

I know SP is bad, but some developers like me have to work on a legacy
database.

On 11月6日, 上午5时08分, Paul Batum <paul.ba...@gmail.com> wrote:


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Wayne Douglas  
View profile  
 More options Nov 6, 8:41 am
From: Wayne Douglas <codingvi...@googlemail.com>
Date: Fri, 6 Nov 2009 13:41:48 +0000
Local: Fri, Nov 6 2009 8:41 am
Subject: Re: [fluent-nhib] Re: Mapping Stored Procedures
we have some pretty huge sps that would be a royal pain in the
proverbial to do any other way. sps are the only way to go for us in a
lot of cases :)

--
Cheers,

w://


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Paul Batum  
View profile  
 More options Nov 6, 8:27 pm
From: Paul Batum <paul.ba...@gmail.com>
Date: Sat, 7 Nov 2009 12:27:50 +1100
Local: Fri, Nov 6 2009 8:27 pm
Subject: Re: [fluent-nhib] Re: Mapping Stored Procedures

I've recieved another patch from Frank and incorporated it into my branch
along with some other minor changes I made. Its now available on my dev
branch <http://github.com/paulbatum/fluent-nhibernate/tree/dev>, and should
be in the trunk in a few days.


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google