Entity Framework 6 - Knowledge Base (KB)

DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID

I have the following code (Database is SQL Server Compact 4.0):...Dim competitor=context.Competitors.Find(id) ...When I profile this the Find method takes 300+ms to retrieve the competitor from a table of just 60 records....When I change the code to:...Di...

Entity Framework 6 Update Graph

What is the correct way to save a graph of objects whose state you don't know? By state I mean whether they are new or existing database entries that are being updated....For instance, if I have:...public class Person { public int Id { get; set; } ...

ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' could not be loaded

The Entity Framework provider type 'System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' could not...

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

PROBLEM: I had a website that was working with my local dev machine (VS2013, EF6.1.3, SQl Server CE 4.0, EF Tools installed). I maintain the website using a git repo locally and in VS OnLine....I am at a different (temporary) location with a new machine....