given a team id I need to retrieve the list of members

Question

Hi Given a team id i need to retrieve the list of members who are in that team.using stored procedure. please give a suggestions.

Upendra Pratap Shahi · Answer

CREATE PROCEDURE usp_GetALLTeamMembers ( @TeamID INT ) AS BEGIN SELECT m . MemberID  m . MemberName  m . MemberStatus  ml . MemberLoginName  tm . MemberJoinedDate  tm . MemberLeftDate FROM TeamMember tm INNER JOIN MemberLogin ml ON tm . MemberLoginID = ml . MemberLoginID INNER JOIN Member m ON m . MemberID = ml . MemberLoginID WHERE tm . TeamID = @TeamID END

Azeem Anzari · Answer

Of course you will get error because the return types doesn't match. You should cast the result back to teammemver type before saving that type of variable.

Sivakumar · Answer

Please give me some suggestions

Sivakumar · Answer

why iam getting error like this : my code is like below : public TeamMemberData GetAllTeamMembers(int teamid) { TeamMember getteammember = _DataContext.uspGetAllTeamMembers(teamid).SingleOrDefault(); return new TeamMemberData { TeamID = getteammember.TeamID MemberLoginID = getteammember.MemberLoginID MemberjoinedDate = getteammember.MemberJoinedDate }; } its shows an error : Error 1 Cannot implicitly convert type 'Kiwi.Service.DL.uspGetAllTeamMembersResult' to 'Kiwi.Service.DL.TeamMember' E:\Kiwi Project\service\Kiwi.Service.DL\DataAccess.cs 59 40 Kiwi.Service.DL please help me.

Sivakumar · Answer

public TeamMemberData GetAllTeamMembers(int teamid) { TeamMember GetTeamMember = _DataContext.usp_GetALLTeamMembers(teamid).SingleOrDefault(); return new TeamMemberData { TeamID=GetTeamMember.TeamID MemberLoginID = GetTeamMember.MemberLoginID MemberjoinedDate = GetTeamMember.MemberJoinedDate }; } this is my code. i get error like this : Error 1 Cannot implicitly convert type 'Kiwi.Service.DL.usp_GetALLTeamMembersResult1' to 'Kiwi.Service.DL.TeamMember' E:\Kiwi Project\service\Kiwi.Service.DL\DataAccess.cs 59 40 Kiwi.Service.DL please help me.

given a team id, I need to retrieve the list of members