blocks|key|417118|text|您可以在查询表达式中直接实例化Rpt_IncidentWithConfirm对象，并且只引用所需的数据库值：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|417119|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();|code-block|syntax|javascript|417120|entityMap^0|F|N|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You can instantiate the <code>Rpt_IncidentWithConfirm</code> object directly in the query expression and only refer to the database values you need:

<pre><code>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();
</code></pre>

blocks|key|417139|text|不要使用anonymus+type，可以使用必须返回的类型|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|417140|+select+new+Rpt_IncidentWithConfirm+
+++++++++++++++++++{
+++++++++++++++++++++++//+set+all+properties+you+need
+++++++++++++++++++}).SingleOrDefault();|code-block|syntax|javascript|417141|编辑:如果你的查询是关于你想要返回的集合类型，你可以简单地使用查询的结果：|417142|+return+db.Rpt_IncidentWithConfirms.Where(+...+).FirstOrDefault();|417143|或者如果您需要文本的值，请使用：|417144|//do+something+with+incident.Text
return+incident.i;|417145|entityMap^0|4|D|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|10|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

Don't use <code>anonymus type</code> you can use the type you have to return

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

Edit:
If your query is on collection type you want to return you can simply use result of query:

<pre><code> return db.Rpt_IncidentWithConfirms.Where( ... ).FirstOrDefault();
</code></pre>

or if u need value of text use :

<pre><code>//do something with incident.Text
return incident.i;
</code></pre>

blocks|key|4271165|text|不需要在select中创建匿名类型，只需创建命名类型的对象即可|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4271166|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()
++++}|code-block|syntax|javascript|4271167|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you are not required to create an anonymous type in the select just create an object of the the named type instead

<pre><code>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()
 }
</code></pre>

blocks|key|4271223|text|我实际上使用了下面链接的答案来解决我的问题。这并不完全是我想要做的，但我现在不必手动键入所有内容。Return+anonymous+type+results?|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4271224|++++++++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;
++++}|code-block|syntax|javascript|4271225|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/534690/linq-to-sql-return-anonymous-type/534794#534794^0|1D|U|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

I actually used the answer linked below to solve my problem. It isn't exactly what I wanted to do but I don't have to type everything manually now.
<a href="https://stackoverflow.com/questions/534690/linq-to-sql-return-anonymous-type/534794#534794">Return anonymous type results?</a>

<pre><code> 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;
 }
</code></pre>

I have a method here that should return a Rpt_IncidentWithConfirm object but I have no clue how to easily convert it to one. The only way I know how it do do what I have below which is very inefficient.

<pre><code> 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;
 }
</code></pre>

Converting Anonymous Type To Nominal Type

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我这里有一个方法，它应该返回一个Rpt_IncidentWithConfirm对象，但我不知道如何轻松地将其转换为一个对象。我所知道的唯一方法是如何做下面的事情，这是非常低效的。    public Rpt_IncidentWithConfirm GetIncident(string IncidentID)    { ...

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

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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