Question

我有下文所述准则问题。

public AddXferData DisplayXferDataToBeModified(int ID)
    {
        try
        {
            var resultSet = (from items in DataContext.Transfers
                             where items.Transfer_ID.Equals(ID)
                             select new AddXferData
                             {
                                 XferID = items.Transfer_ID,
                                 LogicalName = items.Logical_Name,
                                 RoutCode = items.Route_Code,
                                 Label = items.Label,
                                 OnNetDNA = items.On_Net_DNA,
                                 OnNetDNB = items.On_Net_DNB,
                                 FailMessage = items.Failure_Message,
                             });
            return resultSet;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

但我的结果要求获得种姓和我获得的信息

"Cannot implicitly convert type System.Linq.IQueryable to ICMAdministration.Data.AddXferData . An explicit conversion exists (are you missing a cast?)

我需要将结果归入“AddXferData”类。让我知道如何能够做到这一点。你在这方面的帮助非常受赞赏。

Regards, Raghu

Answer 1

如果是单一<代码>AddXferData,则尝试:

return resultSet.First();

或

return resultSet.FirstOrDefault();

If it can return null (as in ID not found 或something)

Answer 2

return resultSet.SingleOrDefault();

Answer 3

您的询问将回复到AddXferData物体的收集工作。如果你打算取得单一结果,改变功能签名。

 public list<AddXferData> DisplayXferDataToBeModified(int ID)

and return the list resultSet.ToList();

友情链接