实体框架6运行时错误：＆QUOT;给定的密钥是不是在字典＆QUOT present; [英] Entity Framework 6 Runtime Error: "given key was not present in the dictionary"

问题描述

我使用EF6 code-第一，每个层级表写一个ASP.Net应用

I am writing an ASP.Net app using EF6 code-first and table per hierarchy

我得到这个错误，每当我试图做任何有意义与我的DbContext（如查询，更新等）：

I get this error whenever I attempt to do anything meaningful with my dbcontext (such as a query, update, etc.):

{
  "Message": "An error has occurred.",
  "ExceptionMessage": "An error occurred while preparing the command definition. See the inner exception for details.",
  "ExceptionType": "System.Data.Entity.Core.EntityCommandCompilationException",
  "StackTrace": "  at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree, DbInterceptionContext interceptionContext, IDbDependencyResolver resolver, BridgeDataReaderFactory bridgeDataReaderFactory, ColumnMapFactory columnMapFactory)\r\n  at System.Data.Entity.Core.EntityClient.Internal.EntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree, DbInterceptionContext interceptionContext)\r\n  at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlanFactory.CreateCommandDefinition(ObjectContext context, DbQueryCommandTree tree)\r\n  at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlanFactory.Prepare(ObjectContext context, DbQueryCommandTree tree, Type elementType, MergeOption mergeOption, Boolean streaming, Span span, IEnumerable`1 compiledQueryParameters, AliasGenerator aliasGenerator)\r\n  at System.Data.Entity.Core.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption)\r\n  at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()\r\n  at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)\r\n  at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()\r\n  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)\r\n  at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)\r\n  at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()\r\n  at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()\r\n  at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n  at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n  at SealingServer.Controllers.PdfsController.<PostPdf>d__4.MoveNext() in C:\Users\thoma_000\Documents\All Code\SealingServer\SealingServer\Controllers\PdfsController.cs:line 93\r\n--- End of stack trace from previous location where exception was thrown ---\r\n  at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n  at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n  at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n  at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n  at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n  at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n  at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n  at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n  at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()",
  "InnerException": {
    "Message": "An error has occurred.",
    "ExceptionMessage": "The given key was not present in the dictionary.",
    "ExceptionType": "System.Collections.Generic.KeyNotFoundException",
    "StackTrace": "  at System.Collections.Generic.Dictionary`2.get_Item(TKey key)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.Structures.MemberDomainMap.GetDomainInternal(MemberPath path)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.QueryRewriting.FragmentQueryKB.CreateIsOfTypeCondition(MemberPath currentPath, IEnumerable`1 derivedTypes, MemberDomainMap domainMap)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.QueryRewriting.FragmentQueryKB.CreateVariableConstraintsRecursion(EdmType edmType, MemberPath currentPath, MemberDomainMap domainMap, EdmItemCollection edmItemCollection)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.QueryRewriting.FragmentQueryKB.CreateVariableConstraintsRecursion(EdmType edmType, MemberPath currentPath, MemberDomainMap domainMap, EdmItemCollection edmItemCollection)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.ViewgenContext..ctor(ViewTarget viewTarget, EntitySetBase extent, IList`1 extentCells, CqlIdentifiers identifiers, ConfigViewGenerator config, MemberDomainMap queryDomainMap, MemberDomainMap updateDomainMap, EntityContainerMapping entityContainerMapping)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.ViewGenerator.CreateViewgenContext(EntitySetBase extent, ViewTarget viewTarget, CqlIdentifiers identifiers)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.ViewGenerator.GenerateDirectionalViewsForExtent(ViewTarget viewTarget, EntitySetBase extent, CqlIdentifiers identifiers, KeyToListMap`2 views)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.ViewGenerator.GenerateDirectionalViews(ViewTarget viewTarget, CqlIdentifiers identifiers, KeyToListMap`2 views)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.ViewGenerator.GenerateAllBidirectionalViews(KeyToListMap`2 views, CqlIdentifiers identifiers)\r\n  at System.Data.Entity.Core.Mapping.ViewGeneration.ViewgenGatekeeper.GenerateViewsFromCells(List`1 cells, ConfigViewGenerator config, CqlIdentifiers identifiers, EntityContainerMapping containerMapping)\r\n  at System.Data.Entity.Core.Mapping.StorageMappingItemCollection.ViewDictionary.SerializedGenerateViews(EntityContainerMapping entityContainerMap, Dictionary`2 resultDictionary)\r\n  at System.Data.Entity.Core.Mapping.StorageMappingItemCollection.ViewDictionary.SerializedGetGeneratedViews(EntityContainer container)\r\n  at System.Data.Entity.Core.Common.Utils.Memoizer`2.Result.GetValue()\r\n  at System.Data.Entity.Core.Common.Utils.Memoizer`2.Evaluate(TArg arg)\r\n  at System.Data.Entity.Core.Mapping.StorageMappingItemCollection.ViewDictionary.GetGeneratedView(EntitySetBase extent, MetadataWorkspace workspace, StorageMappingItemCollection storageMappingItemCollection)\r\n  at System.Data.Entity.Core.Metadata.Edm.MetadataWorkspace.GetGeneratedView(EntitySetBase extent)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.ExpandView(ScanTableOp scanTableOp, IsOfOp& typeFilter)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.ProcessScanTable(Node scanTableNode, ScanTableOp scanTableOp, IsOfOp& typeFilter)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Visit(ScanTableOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Visit(FilterOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.InternalTrees.BasicOpVisitorOfNode.VisitDefault(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.VisitScalarOpDefault(ScalarOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.VisitNavPropertyOp(PropertyOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Visit(PropertyOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.VisitScalarOpDefault(ScalarOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.InternalTrees.BasicOpVisitorOfNode.VisitDefault(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.InternalTrees.BasicOpVisitorOfNode.VisitDefault(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Visit(ProjectOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Visit(ProjectOp op, Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n)\r\n  at System.Data.Entity.Core.Query.InternalTrees.BasicOpVisitorOfNode.VisitDefault(Node n)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Process(Dictionary`2& tvfResultKeys)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PreProcessor.Process(PlanCompiler planCompilerState, StructuredTypeInfo& typeInfo, Dictionary`2& tvfResultKeys)\r\n  at System.Data.Entity.Core.Query.PlanCompiler.PlanCompiler.Compile(List`1& providerCommands, ColumnMap& resultColumnMap, Int32& columnCount, Set`1& entitySets)\r\n  at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree, DbInterceptionContext interceptionContext, IDbDependencyResolver resolver, BridgeDataReaderFactory bridgeDataReaderFactory, ColumnMapFactory columnMapFactory)"
  }
}

修改

我开始了一个全新的数据库，我得到任何实体同样的结果。这使我相信这与我的DbContext做。它看起来是这样的：

I started over with a fresh database and I get the same result for any entity. This leads me to believe it has to do with my DbContext. It looks like this:

public class SealingServerContext : DbContext
    {
        public SealingServerContext() : base("name=TFMContext")
        {
            this.Database.Log = Console.Write;
            this.Configuration.LazyLoadingEnabled = false;
        }
    public DbSet<Organization> Organizations { get; set; }

    public DbSet<User> Users { get; set; }

    public DbSet<Role> Roles { get; set; }

    public DbSet<ReviewerRole> ReviewerRoles { get; set; }
    public DbSet<AnnotationTemplate> AnnotationTemplates { get; set; }
    public DbSet<PaperItem> PaperItems { get; set; }
    public DbSet<PaperRaster> PaperRasters { get; set; }

    public DbSet<EngineerRole> EngineerRoles { get; set; }
    public DbSet<Seal> Seals { get; set; }
    public DbSet<Signature> Signatures { get; set; }


    public DbSet<Job> Jobs { get; set; }
    public DbSet<JobFile> JobFiles { get; set; }
    public DbSet<Pdf> Pdfs { get; set; }
    public DbSet<PdfPage> PdfPages { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<AnnotationTemplate>()
            .HasKey(annotationTemplate => annotationTemplate.ID);

        modelBuilder.Entity<JobFile>()
            .HasKey(pdf => pdf.ID);
        modelBuilder.Entity<Pdf>()
            .HasKey(pdf => pdf.ID)
            .HasMany(pdf => pdf.PdfPages)
            .WithRequired()
            .HasForeignKey(pdfPage => pdfPage.Pdf_ID)
            .WillCascadeOnDelete(true);

        modelBuilder.Entity<Job>()
            .HasKey(job => job.ID);
        modelBuilder.Entity<Job>()
            .HasMany(job => job.Files)
            .WithRequired()
            .HasForeignKey(jobFile => jobFile.Job_ID);
        modelBuilder.Entity<Job>()
            .HasMany(job => job.Regions)
            .WithRequired()
            .HasForeignKey(region => region.Job_ID);

        modelBuilder.Entity<Organization>()
            .HasKey(organization => organization.ID)
            .HasMany(org => org.Users)
            .WithRequired()
            .HasForeignKey(user => user.Organization_ID);

        modelBuilder.Entity<PaperItem>()
            .HasKey(paperItem => paperItem.ID);

        modelBuilder.Entity<PaperRaster>()
            .HasKey(paperRaster => paperRaster.ID);

        modelBuilder.Entity<Models.Files.PdfPage>()
            .HasKey(pdfPage => pdfPage.ID);

        modelBuilder.Entity<Region>()
            .HasKey(region => region.ID);

        modelBuilder.Entity<Role>()
            .HasKey(role => role.ID);

        modelBuilder.Entity<EngineerRole>()
            .HasKey(role => role.ID);
        modelBuilder.Entity<EngineerRole>()
            .HasMany(engineerRole => engineerRole.Seals)
            .WithRequired()
            .HasForeignKey(seal => seal.EngineerRole_ID);
        modelBuilder.Entity<EngineerRole>()
            .HasMany(engineerRole => engineerRole.Signatures)
            .WithRequired()
            .HasForeignKey(signature => signature.EngineerRole_ID);

        modelBuilder.Entity<EngineerAdminRole>()
            .HasKey(role => role.ID);

        modelBuilder.Entity<ReviewerAdminRole>()
            .HasKey(role => role.ID);

        modelBuilder.Entity<ReviewerRole>()
            .HasKey(reviewerRole => reviewerRole.ID)
            .HasMany(reviewerRole => reviewerRole.AnnotationTemplates)
            .WithOptional()
            .HasForeignKey(annotation => annotation.ReviewerRole_ID);

        modelBuilder.Entity<Seal>()
            .HasKey(seal => seal.ID);

        modelBuilder.Entity<Signature>()
            .HasKey(signature => signature.ID);

        modelBuilder.Entity<User>()
            .HasKey(user => user.ID);
        modelBuilder.Entity<User>()
            .HasMany(user => user.Roles)
            .WithOptional()
            .HasForeignKey(role => role.User_ID);
    }
}

EDIT2

我已经评论的东西出来，做数据库迁移，并已经把范围缩小到这一继承层次：

I've been commenting things out and doing db migrations and have narrowed it down to this inheritance hierarchy:

[KnownType(typeof(PaperRaster))]
public class PaperItem
{
    public int ID { get; set; }

    public PointF PdfPosition { get; set; }

    public string ItemType { get; set; }

    public virtual void Move(PointF coordinatesTranslation)
    {
    }

    protected PaperItem(string paperItemType, PointF pdfPosition)
    {
        ItemType = paperItemType;
        PdfPosition = pdfPosition;
    }

    public virtual PaperItem DeepCopy()
    {
        return new PaperItem("PaperItem", new PointF());
    }


    public virtual string ToJson()
    {
        //turn all of my properties into Json
        return "";
    }
}

和它的子类：

public class PaperRaster : PaperItem
{
    public string Source { get; set; }
    public string CrossOrigin { get; set; }
    public Matrix Matrix { get; set; }

    public PaperRaster(string source, string crossOrigin, Matrix matrix, PointF pdfPosition)
        : base("Raster", pdfPosition)
    {
        this.Source = source;
        this.CrossOrigin = crossOrigin;
        this.Matrix = matrix;
    }

    public PaperRaster(string json) : base("Raster", new PointF())
    {
        JArray array = JArray.Parse(json);

        JToken type = array[0];
        JToken properties = array[1];
        JToken position = array[2]["pdfPosition"];


        if (type.ToString() != "Raster")
        {
            throw new Exception("Not a PaperRaster");
        }

        var matrix = properties["matrix"];
        this.Matrix = new Matrix(float.Parse(matrix[0].ToString()), float.Parse(matrix[1].ToString()),
            float.Parse(matrix[2].ToString()), float.Parse(matrix[3].ToString()),
            float.Parse(matrix[4].ToString()), float.Parse(matrix[5].ToString()));

        // Custom encoded properties

        // Bottom left point of annotation (that's how iTextSharp inserts it)

        var x = position["x"].ToString();
        var y = position["y"].ToString();

        this.PdfPosition = new PointF()
        {
            X = float.Parse(x),
            Y = float.Parse(y)
        };
    }

    public override void Move(PointF coordinatesTranslation)
    {
        this.Matrix.Translate(coordinatesTranslation.X, coordinatesTranslation.Y);
    }

    public override PaperItem DeepCopy()
    {
        return new PaperRaster(this.Source, this.CrossOrigin, this.Matrix, this.PdfPosition);
    }

    public override string ToJson()
    {
        //turn all of my properties into Json
        return "";
    }
}

如果我注释掉子类，做一个数据库迁移。一切恢复正常工作。在这种继承层次是什么原因导致EF错误地生成表

If I comment out the child class and do a db migration. Everything goes back to working. What in this inheritance hierarchy causes EF to incorrectly generate the tables

的其他注意事项的

奇怪阿里纳斯，这样工作的：

Strange sidenote, doing this works:

var result = context.dbset.Single(x => x.ID == 10000);

不过使用查找像这样：

var result = context.dbset.Find(10000);

将导致上述错误。

causes the error above.

推荐答案

我已经弄清楚这个问题对我来说，用不对应的属性派生实体内（有关，可能也发生当整个派生类没有映射）。我最好discribed它这个答案。

I have figure out the problem to me, it was related with a not mapped property inside the derived entity (and could also occurs when the entire derived class is not mapped). I discribed it better in this answer.

这篇关于实体框架6运行时错误：＆QUOT;给定的密钥是不是在字典＆QUOT present;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！