我有一個簡單的模型[Table("InterfaceType")]public class InterfaceType{ [Key] public int InterfaceTypeId { get; set; } public string Description { get; set; }}在我的 DbContextpublic DbSet<InterfaceType> InterfaceTypes { get; set; }在我的控制器中List<InterfaceType> types = _context.InterfaceTypes.FromSql( "SELECT * FROM [Interfaces].[Control].[InterfaceType]").ToList();哪個返回錯誤：InvalidOperationException：“FromSql”操作的結果中不存在所需的列“InterfaceID”。我在與此類似的其他方法中使用 FromSql 沒有問題，盡管這些模型確實包含 InterfaceId。為什么此操作在模型中不存在時需要一個 InterfaceId。我也嘗試了以下相同的結果。List<InterfaceType> types = _context.InterfaceTypes.FromSql( "SELECT InterfaceTypeId, Description FROM [Interfaces].[Control].[InterfaceType]").ToList();我也試過：interfacesOverview.SelectedInterface.InterfaceTypes = _context.InterfaceTypes.ToList();通過 fluent api 聲明后： protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<InterfaceType>().ToTable("InterfaceType", "Control"); }結果相同。為了清楚起見，這里是 MSSQL 中的表： CREATE TABLE [Control].[InterfaceType]( [InterfaceTypeId] [tinyint] NOT NULL, [Description] [varchar](25) NULL, CONSTRAINT [PK_InterfaceType] PRIMARY KEY CLUSTERED ( [InterfaceTypeId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]更新我查看了 EF 生成的 SQL： SELECT [i].[InterfaceTypeId], [i].[Description], [i].[InterfaceID] FROM [Control].[InterfaceType] AS [i]它從哪里獲取 InterfaceID？
.NET Core 實體框架 InvalidOperationException
慕田峪7331174
2022-06-12 14:32:55
