c# - Output parameters may only be mapped through the RowsAffectedParameter property -

c# - Output parameters may only be mapped through the RowsAffectedParameter property -

i have stored procedure in want homecoming output value , access on application in accessing through entity framework.

my stored procedure:

alter procedure [dbo].[insert_studentdetails] ( @name varchar(150), @city varchar(150), @returnvalue int out ) begin --declare if not exists(select name pupil name=@name , city=@city) begin insert student(name, city) values(@name, @city) set @returnvalue=1 end else begin set @returnvalue=0 end select @returnvalue end

now after right click on table in edmx file showing following:

when import function take none in return.

i accessing next code:

public bool insertstudentdata(student student) { using (collegedataentities context = new collegedataentities()) { objectparameter returnedvalue = new objectparameter("returnvalue", typeof(int)); context.insertstudentdata(student.name, student.city, returnedvalue); if (convert.toint32(returnedvalue) == 1) { homecoming true; } else { homecoming false; } } }

while running, showing next exception:

in error list, next exception coming:

please help..

yes. solved it.

i changed lastly line of stored procedure:

select @returnvalue= scope_identity()

after updating model, in mapping part, added returnvalue in result column bindings to. nail come in button after writing out value. please tick adjacent checkbox of out value

c# entity-framework stored-procedures entity-framework-6.1