'System.InvalidOperationException'类型的例外 [英] An exception of type 'System.InvalidOperationException'

问题描述

Hi,

I Get a Error Like this :

An exception of type 'System.InvalidOperationException' occurred in System.Core.dll but was not handled in user code

Additional information: Sequence contains more than one element

i want to get team member details based on teamid
this is my tables :

this is my stored procedure :

GO
ALTER PROCEDURE [dbo].[uspGetAllTeamMembers](@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.MemberID

WHERE tm.TeamID = @TeamID


END
and this is my backend code :

 public TeamMemberData GetAllTeamMembers(int teamid)
        {
            var getteam = (from t in _DataContext.uspGetAllTeamMembers(teamid) select new TeamMemberData { MemberID=t.MemberID, MemberName=t.MemberName,MemberStatus=t.MemberStatus }).SingleOrDefault();

            return getteam;
        }

I'm using linq to sql stored procedure
please give a help

推荐答案

如果序列包含两个或更多元素，SingleOrDefault会返回异常 - 文档非常清楚： https://msdn.microsoft.com/en-us/library/vstudio/bb342451（v = VS.100）的.aspx [ ^ ]



这意味着您的TeamMember表包含至少两个与您提供的ID相匹配的TeamID值。

查看您的数据，或改为使用FirstOrDefault。

SingleOrDefault returns an exception if the sequence contains two or more elements - the documentation makes that very clear: https://msdn.microsoft.com/en-us/library/vstudio/bb342451(v=vs.100).aspx[^]

Which means that your TeamMember table contains at least two TeamID values which match the ID you supplied.
Look at your data, or use FirstOrDefault instead.

这篇关于'System.InvalidOperationException'类型的例外的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！