stored procedure can not import to nhydrate Model

May 24, 2013 at 3:22 AM
hi everybody,
I am new to nHydrate (v5.1)
I created a simple StoredProcedure ,
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE ProcTest @employeeID INT
AS
BEGIN

    SET NOCOUNT ON;

    SELECT  ID ,
            EmployeeName ,
            EmployeeNo
    FROM    dbo.Employee
    WHERE   ID = @employeeID

END
GO

when I import it to the Model , I got the errors
"The output fields could not be determined for the following stored procedures.
The fields collection of each will not be modified."

Please Help

Many Thanks,

Evan
Coordinator
Jun 11, 2013 at 1:19 AM
Edited Jun 11, 2013 at 1:19 AM
I have seen this. Please add parenthesis to your stored proc like this.

ALTER PROCEDURE ProcTest (@employeeID INT ) AS

The parser needs to know how to separate the parameters.