How to define where clause for ExecuteDelete/ExecuteUpdate methods of EF core 7 with generic type properties?

Question

I have a generic repository with the following definition :

public class DataRepository<TEntity, TEntityIdType> : IDataRepository<TEntity, TEntityIdType>where TEntity : class , IEntity<TEntityIdType>, new()

public interface IEntity<T>{T _EntityId {get; set;}}

I want to implement Delete method of my repository by using ExecuteDelete method of EF Core 7 which is more efficient than querying the DB for specific instance and remove it.

So i tried something like :

var deletedItems = await m_dbContext.Set<TEntity>.Where(entity => 
                                                entity._EntityId == idToDelete).ExecuteDeleteAsync();

idToDelete is a variable of type TEntityIdType which i get as a parameter of the Delete method of the repository.

The problem is that generic type TEntityIdType does not have overloaded operator == . So the above implementation does not compile. I tried to use method Equals inside Where clause instead of operator == but EF Core failed to translate this code to proper Where clause of SQL query.

What can i do in this situation ? Thank you.

Answer 1

I'm not sure of the patterns that you're using and wheather your logic requires only checking by Id. However, for more flexibility, you can implement the methods as below.

public int BulkDelete(Expression<Func<TEntity, bool>> query)
{
    return this.context.Set<TEntity>().Where(query).ExecuteDelete();
}

public int BulkUpdate(Expression<Func<TEntity, bool>> query, Expression<Func<SetPropertyCalls<TEntity>, SetPropertyCalls<TEntity>>> expression)
{
    return context.Set<TEntity>().Where(query).ExecuteUpdate(expression);
}

Of course you will use the async versions but this allows you to write any conditions that you wish.

The delete method can then be called by e.g.

var deletedItems = DataRepository<User>().BulkDelete(user => user.Id == 3);