Get the return value?

[julian Welby Everard]

Hi

I have a simple stored procedure as follows :-

CREATE PROCEDURE SelectCar
    @CarID Int = null
AS
BEGIN
    SET NOCOUNT ON;
    Select *
    from Cars
    where CarID = @CarID or @CarID is Null

    return 10
END
GO

This i have cust down a bit, but in essence it takes a single parameter and returns a dataset and also sets a return code in this case its 10.

ORM generates the code below to call the stored procedure

Public Shared Function SelectCar(ByVal scope As IObjectScope,ByVal carID As Nullable(Of Integer)) As IQueryResult

    Dim query As IQuery = scope.GetSqlQuery("[SelectCar] ?", Nothing, "INTEGER CarID")

    Dim res As IQueryResult = query.Execute(New Object() {carID})

    Dim count As Integer = res.Count 'executes the query

    

    Return res

End Function

I then call this and process each row returned

Dim scope As IObjectScope = ObjectScopeProvider.GetNewObjectScope()

Dim result As IQueryResult = StoredProcedure.SelectCar(scope, Nothing)

For Each pr As Object() In result

   


Next

But how do I get the returned value as well, I could add it as a return outpout parameter, but the code is used by other systems and therefor I cant change the stored procedure definiation, in good old .net SQL classes i create the parameter as a 'Return' type and get it that way,

I just cant see how to do this in ORM, there seems to be a ParameterAttribute in the documentation nut no indication on how this is used

Julian

[julian Welby Everard]

As no one seems to know the answer to this, I will have to reject the idea of using ORM to access my database, while eveything so far has been very good, the problem with not able to get the Return value from a stored procedure is a major one as a lot o f systems use this method to return status/error codes from stored procedures.

I do not want to rewrite over 10 different systems just to change the way i implment for a new one.

Julian

[PetarP]

Hello julian Welby Everard,

 Currently there is no possible workaround to use the return value parameters. But since several more users have requested it we are implementing it right now. Once the implementation is ready you will be able to access the return parameters in a collection much like the out parameters.
We are sorry for any inconvenience this might be causing you.

Kind regards,
Petar
the Telerik team