In My API Controller Shows an Error

Question

Hi In my API Controller shows an error like teamID Does not exist. this is my code : [HttpGet] [Route({teamId}/members)] [OverrideAuthorization] public List GetTeamMember() { return _team.GetTeamMember(teamID); }

Sivakumar · Answer

thank you manas for giving suggestions i resolved the problem

Manas Mohapatra · Answer

1. Make sure that you are passing correct temID not any string to your SP. 2. Collect temID from your controller and execute your sp by following command in your DB. Make sure that it s working fine: execute uspGetAllTeamMembers 123 If you are getting exception here please provide your sp code here.

Sivakumar · Answer

if am executes this project shows an error like An exception of type 'System.InvalidCastException' occurred in System.Data.dll but was not handled in user code Additional information: Specified cast is not valid. in my api controller code is : [HttpGet] [Route({teamId}/members)] [OverrideAuthorization] public List GetTeamMembers(int teamId) { //TODO member doesn't have team - member type. This has to be handled return _team.GetTeamMember(teamId); } and in my data access layer code is : public List GetTeamMember(int teamID) { var getteammember = (from tm in _DataContext.uspGetAllTeamMembers(teamID) select new TeamMemberData {TeamID=tm.TeamID}).ToList(); return getteammember; } here shows an error

Shuvojit Halder · Answer

This will be [HttpGet] [ Route ( methodname/{ teamId } )] [OverrideAuthorization] public List GetTeamMember(int teamId) { return _team.GetTeamMember(teamID); }

Manas Mohapatra · Answer

Try below one: 1. Change code to return _team.GetTeamMember( teamId ); 2. Make sure that you are typing correct URL(12/members)