search

Jeff-Lewis / codesmith

Automatically exported from code.google.com/p/codesmith
0 stars 0 forks source link

Stored Procedure output parameter is not returned as ByRef in the generated DataContext Class #162

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create Stroed procedure with output parameter
2. call the datacontext method for this sp
3. the output parameter is always come back zero

What is the expected output? What do you see instead?
the return value , i see instead zero

What version of the product are you using?
code smith 5.1.6 , plinqo nightly build 996 also the last offical release 
2.x

Please provide any additional information below.
just change the parameter in the mapped methode for the stored procedure 
to ByRef(i know easy to say but to do is a diffrent matter!!! :-)  )

Original issue reported on code.google.com by eng.moha...@gmail.com on 13 Oct 2009 at 6:38

GoogleCodeExporter commented 9 years ago 
Sorry my bad i didnt select the Template its PLinqo i couldnt edit the post

Original comment by eng.moha...@gmail.com on 13 Oct 2009 at 6:40

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 13 Oct 2009 at 2:49

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 13 Oct 2009 at 3:16

GoogleCodeExporter commented 9 years ago 
Can you post a sample of your stored proc?

I attempted to recreate by creating a test stored proc in the tracker sample 
and it 
generated a byref parameter and returned the expected result.

Original comment by shannon....@gmail.com on 13 Oct 2009 at 5:02

GoogleCodeExporter commented 9 years ago 
yes sure ,,

Create PROCEDURE [dbo].[InsertSomething]
    @A nvarchar(150),
    @B nvarchar(150),
    @C int,
    @ID int OUTPUT
AS

SET NOCOUNT ON

INSERT INTO [dbo].[X] (
    [A],
    [B],
    [C]
) VALUES (
    @A,
    @B,
    @C 
)

SET @PID = SCOPE_IDENTITY()

Original comment by eng.moha...@gmail.com on 14 Oct 2009 at 5:41

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 14 Oct 2009 at 3:19

GoogleCodeExporter commented 9 years ago 
This appears to be corrected in the latest nightly build of PLINQO which you 
can find 
on the plinqo downloads page at http://plinqo.com/Download.ashx.  Click the 
nightly 
builds link.

Original comment by shannon....@gmail.com on 14 Oct 2009 at 3:31

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 30 Dec 2009 at 5:43

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 30 Dec 2009 at 6:04

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 30 Dec 2009 at 9:16