将IQueryable转换为自定义类 [英] Convert IQueryable to Custom Class

问题描述

我有一个如下的LINQ查询，

I have a LINQ query as below,

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;
        }
    }

但是我的resultSet要求进行Cast，而我收到的消息是

But my resultSet asks for a Cast and the message I get is

无法隐式转换类型 'System.Linq.IQueryable'到 "ICMAdministration.Data.AddXferData".存在显式转换 (您是否缺少演员表?)

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

我需要强制转换结果集以键入AddXferData.您能告诉我如何实现吗?非常感谢您在这方面的帮助.

I need to cast the resultset to type AddXferData. Can you let me know how this can be achieved. Your help in this regard is very much appreciated.

关于， 拉古

推荐答案

如果是单个AddXferData，请尝试:

return resultSet.First();

或

return resultSet.FirstOrDefault();

如果它可以返回null(如未找到ID之类的东西)

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

这篇关于将IQueryable转换为自定义类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！