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
Post a Comment