LINQ to Entities中不支持指定的类型成员
本文关键字:类型 成员 不支持 to Entities LINQ | 更新日期: 2023-09-27 18:21:40
我有一个名为StatusTypes 的枚举类型
public enum StatusTypes
{
Open = 1,
Allocated = 2,
WorkInProgress = 3,
WaitingOnRequestor = 4,
WaitingOnThirdParty = 5,
Monitoring = 6,
Testing = 7,
OnHold = 8,
Complete = 9,
SignedOff = 10,
Reopened = 11
}
我正试图在我的存储库中使用它。。。。
public IQueryable<Incident> GetAllOutstandingIncidents()
{
return from i in db.Incidents
where i.Status != Types.StatusTypes.SignedOff && i.Status != Types.StatusTypes.Complete && i.DeletedDateTime != null
orderby i.DueDateTime
select i;
}
然后在我看来使用它。。。
<tbody>
<% foreach (var incident in Model.TotalIncidentsOutstandingList) { %>
<tr>
<td><%: incident.IncidentID %></td>
<td><%: incident.Caller.NetworkName %></td>
<td><%: incident.Title %></td>
<td><%: incident.Service.Title %> / <%: incident.Category.Title %> <% if (incident.Subcategory != null) { %> / <%: incident.Subcategory.Title %><% } %></td>
<td><%: incident.Priority %></td>
<td></td>
<td><%: incident.AllocatedTo %></td>
<td><%: incident.DueDateTime %></td>
</tr>
<% } %>
</tbody>
但我得到了错误"LINQ to Entities中不支持指定的类型成员"Status"。只支持初始化程序、实体成员和实体导航属性。"
感谢您的帮助!
显示事件的更新。cs
public class Incident
{
public int IncidentID { get; set; }
public DomainUser Caller { get; set; }
[Display(Name = "Caller Type")]
public Types.CallerTypes CallerType { get; set; }
public Service Service { get; set; }
public Category Category { get; set; }
public Subcategory Subcategory { get; set; }
public string Title { get; set; }
[Display(Name = "Problem Description")]
public string ProblemDescription { get; set; }
public Equipment Equipment { get; set; }
public Types.ImpactTypes Impact { get; set; }
public Types.UrgencyTypes Urgency { get; set; }
[Display(Name = "Priority")]
public Types.PriorityTypes Priority { get; set; }
[Display(Name="Estimated time for completion")]
public DateTime? DueDateTime { get; set; }
[Display(Name="Date/Time")]
public DateTime? CreatedDateTime { get; set; }
public DomainUser CreatedBy { get; set; }
[Display(Name = "Allocated To")]
public HelpDeskMember AllocatedTo { get; set; }
public DateTime? AllocatedDateTime { get; set; }
public DateTime? ClosedDateTime { get; set; }
public int? ClosedBy { get; set; }
public DateTime? ReopenedDateTime { get; set; }
public int? ReopenedBy { get; set; }
public DateTime? DeletedDateTime { get; set; }
public HelpDeskMember DeletedBy { get; set; }
public Decimal? EstimatedInternalCost { get; set; }
public Decimal? EstimatedResources { get; set; }
public Decimal? RealInternalCost { get; set; }
public Decimal? EstimatedExternalCost { get; set; }
public Decimal? RealExternalCost { get; set; }
public Decimal? EstimatedTotalCost { get; set; }
public Decimal? RealTotalCost { get; set; }
public string CostCode { get; set; }
public string TimeRequired { get; set; }
public string ActualTimeTaken { get; set; }
public Types.StatusTypes Status { get; set; }
public string Solution { get; set; }
public bool UserSignedOff { get; set; }
public bool OverdueEmailSent { get; set; }
public bool EscalatedEmailSent { get; set; }
public ICollection<Note> Notes { get; set; }
public ICollection<Attachment> Attachments { get; set; }
public ICollection<HistoryItem> History { get; set; }
public Incident()
{
Notes = new List<Note>();
Attachments = new List<Attachment>();
History = new List<HistoryItem>();
}
}
正如我已经说过的,尝试将两个部分都转换为int
类型的
public IQueryable<Incident> GetAllOutstandingIncidents()
{
return from i in db.Incidents
where (int)i.Status != (int)Types.StatusTypes.SignedOff
&& (int)i.Status != (int)Types.StatusTypes.Complete
&& i.DeletedDateTime != null
orderby i.DueDateTime
select i;
}
更新
这是Code First的一个特性。你应该做以下事情。改变你的班级,这样:
[Column("Status", TypeName = "int")]
public int InternalStatus { get; set; }
public StatusTypes Status { get; set; }
并使用以下查询:
context.Incidents.Where(i => i.InternalStatus == (int)StatusTypes.Allocated);
我在这里找到了这个信息
您还可以使用.AsEnumerable():转换为LINQ to对象
public IQueryable<Incident> GetAllOutstandingIncidents()
{
return from i in db.Incidents.AsEnumerable()
where i.Status != Types.StatusTypes.SignedOff && i.Status != Types.StatusTypes.Complete && i.DeletedDateTime != null
orderby i.DueDateTime
select i;
}
根据您的需要,它可能不是一个很好的解决方案:它不会只从数据库中提取一个对象,而是在您调用.AsEnumerable().
请改用
return from i in db.Incidents
where i.Status != (int)Types.StatusTypes.SignedOff && i.Status != (int)Types.StatusTypes.Complete && i.DeletedDateTime != null
orderby i.DueDateTime
select i;
在您的事件类中:
private int statusId;
public Types.StatusTypes Status
{
get
{
return (Types.StatusTypes)statusId;
}
set
{
statusId = (int)value;
}
}
public Int StatusId
{
get
{
return statusId;
}
}
然后在你的方法:
public IQueryable<Incident> GetAllOutstandingIncidents()
{
int signedOffStatusType = (int)Types.StatusTypes.SignedOff;
int completeStatusType = (int)Types.StatusTypes.Complete;
return from i in db.Incidents
where i.StatusId != signedOffStatusType
&& i.StatusId != completeStatusType
&& i.DeletedDateTime != null
orderby i.DueDateTime
select i;
}
或者使用方法语法:
public IQueryable<Incident> GetAllOutstandingIncidents()
{
int signedOffStatusType = (int)Types.StatusTypes.SignedOff;
int completeStatusType = (int)Types.StatusTypes.Complete;
return db.Incidents.Where(i => i.StatusId != signedOffStatusType
&& i.StatusId != completeStatusType
&& i.DeletedDateTime != null)
.OrderBy(i => i.DueDateTime);
}