DbSet doesn’t have a Find method in EF7

by

Here’s a very crude, incomplete, and untested implementation of .Find() as an extension method. If nothing else, it should get you pointed in the right direction.

The real implementation is tracked by #797.

static TEntity Find<TEntity>(this DbSet<TEntity> set, params object[] keyValues)
    where TEntity : class
{
    var context = ((IAccessor<IServiceProvider>)set).Service.GetService<DbContext>();

    var entityType = context.Model.GetEntityType(typeof(TEntity));
    var key = entityType.GetPrimaryKey();

    var entries = context.ChangeTracker.Entries<TEntity>();

    var i = 0;
    foreach (var property in key.Properties)
    {
        var keyValue = keyValues[i];
        entries = entries.Where(e => e.Property(property.Name).CurrentValue == keyValue);
        i++;
    }

    var entry = entries.FirstOrDefault();
    if (entry != null)
    {
        // Return the local object if it exists.
        return entry.Entity;
    }

    // TODO: Build the real LINQ Expression
    // set.Where(x => x.Id == keyValues[0]);
    var parameter = Expression.Parameter(typeof(TEntity), "x");
    var query = set.Where((Expression<Func<TEntity, bool>>)
        Expression.Lambda(
            Expression.Equal(
                Expression.Property(parameter, "Id"),
                Expression.Constant(keyValues[0])),
            parameter));

    // Look in the database
    return query.FirstOrDefault();
}

More Related Contents:

  1. Dynamically change connection string in Asp.Net Core
  2. Many-to-many self referencing relationship
  3. navigation property should be virtual – not required in ef core?
  4. auto create database in Entity Framework Core
  5. Filter all queries (trying to achieve soft delete)
  6. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  7. How to add the same column to all entities in EF Core?
  8. Unable to create migrations after upgrading to ASP.NET Core 2.0
  9. Dynamically changing schema in Entity Framework Core
  10. How to store JSON in an entity field with EF Core?
  11. EF CORE 2.1 HasConversion on all properties of type datetime
  12. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  13. Include with FromSqlRaw and stored procedure in EF Core 3.1
  14. Azure Function, EF Core, Can’t load ComponentModel.Annotations 4.2.0.0
  15. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  16. Entity framework EF.Functions.Like vs string.Contains
  17. The LINQ expression could not be translated and will be evaluated locally
  18. Avoid or control circular references in Entity Framework Core
  19. Entity Framework Core: Guid Greater Than for Paging
  20. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  21. Add migration with different assembly
  22. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  23. How to load navigation properties on an IdentityUser with UserManager
  24. How to get user information in DbContext using Net Core
  25. How to create a password protected database?
  26. Implementing recursive property loading in EF Core
  27. How to set Identity Seed value in code-first?
  28. EF Core takes a lot of time, sometimes, to perform SELECT query
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. How to access DbContext in .NET 6 minimal API Program.cs

Leave a Comment