asp.net mvc - Trouble with OUTPUT parameter in SQL Server 2008R2 -


i have strange stored procedure call using entity framework 6.1.3

 var p = _dataprovider.getparameter();          ...  var pseasonstageid = _dataprovider.getparameter();  pseasonstageid.parametername = "seasonstageid";  pseasonstageid.value = seasonstageid;  pseasonstageid.dbtype = dbtype.int32;   var ptotalrecords = _dataprovider.getparameter();  ptotalrecords.parametername = "totalrecords";  ptotalrecords.direction = parameterdirection.output;  ptotalrecords.dbtype = dbtype.int32;   var playerstats = _dbcontext.executestoredprocedurelist<leagueplayerstatsmodel>(             "leagueplayerstats2",             pcategoryid,             pteamid,             pseasonstageid,             pfixtureid,             pplayerid,             pcountapp,             porderby,             ppageindex,             ppagesize,             ptotalrecords); 

and in stored procedure leagueplayerstats2:

alter procedure [dbo].[leagueplayerstats2]     @shotspergame   bit = null,     @rating bit = null,     @assist bit = null,     @aggression bit = null,     @dribble bit =null,     @categoryid int =0,     @teamid int=0,     @playerid int =0,     @fixtureid int=0,     @seasonstageid int =0,     @orderby int =0,  -- 0: rating, 1: goals/teamgoals     @passacc bit =null,     @pageindex          int = 0,      @pagesize           int = 2147483644,     @countapp bit=0,     @totalrecords       int = 0 output 

it shows message:

the formal parameter "@seasonstageid" not declared output parameter, actual parameter passed in requested output.

though on debug param @seasonstageid direction = input.

any ideas , thoughts appreciated


Comments