将匿名类型转换为名义类型

Question

我这里有一种方法应该返回 Rpt_IncidentWithConfirm 对象，但我不知道如何轻松地将其转换为对象。我知道它如何做我下面的事情的唯一方法是非常低效的。

    public Rpt_IncidentWithConfirm GetIncident(string IncidentID)
    {
        db = new IncidentsDataContext();

        var incident = (from i in db.Rpt_IncidentWithConfirms
                       join d in db.DropDowns on i.incidentType equals d.value
                       where i.incidentID == Convert.ToInt32(IncidentID)
                       select new
                       {
                           i, d.text
                       }).SingleOrDefault();
        Rpt_IncidentWithConfirm r = new Rpt_IncidentWithConfirm();
        // I didn't want to have to type all this here because I have too many fields to map.

        r.bhaIncident = incident.i.bhaIncident;
        r.bitType = incident.i.bitType;
        r.Bottom_Connection = incident.i.Bottom_Connection;
        // And so on.


        return r;
    }

Answer 1

您可以直接在查询表达式中实例化 Rpt_IncidentWithConfirm 对象，并仅引用您需要的数据库值：

var incident = (from i in db.Rpt_IncidentWithConfirms
                join d in db.DropDowns on i.incidentType equals d.value
                where i.incidentID == Convert.ToInt32(IncidentID)
                select new Rpt_IncidentWithConfirm
                {
                   bhaIncident = i.bhaIncident
                 , bitType = i.bitType
                 , Bottom_Connection = i.Bottom_Connection
                }).SingleOrDefault();

Answer 2

不要使用匿名类型，您可以使用必须返回

 select new Rpt_IncidentWithConfirm 
                   {
                       // set all properties you need
                   }).SingleOrDefault();

编辑的类型：
如果您的查询是要返回的集合类型，您可以简单地使用查询结果：

 return db.Rpt_IncidentWithConfirms.Where( ... ).FirstOrDefault();

或者如果您需要文本值，请使用：

//do something with incident.Text
return incident.i;

Answer 3

我实际上使用下面链接的答案来解决我的问题。这并不完全是我想要做的，但我现在不必手动输入所有内容。
返回匿名类型结果？

        public class IncidentWithDropDown
    {
        public Rpt_IncidentWithConfirm Incident { get; set; }
        public string IncidentTypeText { get; set; }
    }
    public IncidentWithDropDown GetIncident(string IncidentID)
    {
        db = new IncidentsDataContext();

        var incident = (from i in db.Rpt_IncidentWithConfirms
                       join d in db.DropDowns on i.incidentType equals d.value
                       where i.incidentID == Convert.ToInt32(IncidentID)
                       select new IncidentWithDropDown()
                       {
                           Incident = i,
                           IncidentTypeText = d.text
                       }).SingleOrDefault();

        return incident;
    }

Answer 4

您不需要在选择中创建匿名类型，只需创建命名类型的对象即可

public Rpt_IncidentWithConfirm GetIncident(string IncidentID)
    {
        db = new IncidentsDataContext();

        var return (from i in db.Rpt_IncidentWithConfirms
                       join d in db.DropDowns on i.incidentType equals d.value
                       where i.incidentID == Convert.ToInt32(IncidentID)
                       select new Rpt_IncidentWithConfirm(){

                           bhaIncident =i.bhaIncident,
                           bitType = i.bitType,
                           Bottom_Connection = i.Bottom_Connection,
                           // And so on.
                        }).SingleOrDefault()
    }