| | | 1 | | namespace Pozitron.QuerySpecification; |
| | | 2 | | |
| | | 3 | | public abstract class RepositoryBase<T> : IRepositoryBase<T> where T : class |
| | | 4 | | { |
| | | 5 | | private readonly DbContext _dbContext; |
| | | 6 | | private readonly SpecificationEvaluator _evaluator; |
| | | 7 | | |
| | | 8 | | protected RepositoryBase(DbContext dbContext) |
| | 49 | 9 | | : this(dbContext, SpecificationEvaluator.Default) |
| | | 10 | | { |
| | 49 | 11 | | } |
| | 51 | 12 | | protected RepositoryBase(DbContext dbContext, SpecificationEvaluator specificationEvaluator) |
| | | 13 | | { |
| | 51 | 14 | | _dbContext = dbContext; |
| | 51 | 15 | | _evaluator = specificationEvaluator; |
| | 51 | 16 | | } |
| | | 17 | | |
| | | 18 | | public virtual async Task<T> AddAsync(T entity, CancellationToken cancellationToken = default) |
| | | 19 | | { |
| | 1 | 20 | | _dbContext.Set<T>().Add(entity); |
| | | 21 | | |
| | 1 | 22 | | await SaveChangesAsync(cancellationToken); |
| | | 23 | | |
| | 1 | 24 | | return entity; |
| | 1 | 25 | | } |
| | | 26 | | public virtual async Task<IEnumerable<T>> AddRangeAsync(IEnumerable<T> entities, CancellationToken cancellationToken |
| | | 27 | | { |
| | 1 | 28 | | _dbContext.Set<T>().AddRange(entities); |
| | | 29 | | |
| | 1 | 30 | | await SaveChangesAsync(cancellationToken); |
| | | 31 | | |
| | 1 | 32 | | return entities; |
| | 1 | 33 | | } |
| | | 34 | | public virtual async Task UpdateAsync(T entity, CancellationToken cancellationToken = default) |
| | | 35 | | { |
| | | 36 | | //dbContext.Set<T>().Update(entity); |
| | | 37 | | |
| | 1 | 38 | | await SaveChangesAsync(cancellationToken); |
| | 1 | 39 | | } |
| | | 40 | | public virtual async Task DeleteAsync(T entity, CancellationToken cancellationToken = default) |
| | | 41 | | { |
| | 1 | 42 | | _dbContext.Set<T>().Remove(entity); |
| | | 43 | | |
| | 1 | 44 | | await SaveChangesAsync(cancellationToken); |
| | 1 | 45 | | } |
| | | 46 | | public virtual async Task DeleteRangeAsync(IEnumerable<T> entities, CancellationToken cancellationToken = default) |
| | | 47 | | { |
| | 1 | 48 | | _dbContext.Set<T>().RemoveRange(entities); |
| | | 49 | | |
| | 1 | 50 | | await SaveChangesAsync(cancellationToken); |
| | 1 | 51 | | } |
| | | 52 | | public virtual async Task<int> SaveChangesAsync(CancellationToken cancellationToken = default) |
| | | 53 | | { |
| | 5 | 54 | | return await _dbContext.SaveChangesAsync(cancellationToken); |
| | 5 | 55 | | } |
| | | 56 | | |
| | | 57 | | public virtual async ValueTask<T?> FindAsync<TId>(TId id, CancellationToken cancellationToken = default) where TId : |
| | | 58 | | { |
| | 3 | 59 | | return await _dbContext.Set<T>().FindAsync([id], cancellationToken: cancellationToken); |
| | 3 | 60 | | } |
| | | 61 | | public virtual async Task<T> FirstAsync(Specification<T> specification, CancellationToken cancellationToken = defaul |
| | | 62 | | { |
| | 2 | 63 | | var result = await GenerateQuery(specification).FirstOrDefaultAsync(cancellationToken); |
| | 2 | 64 | | return result ?? throw new EntityNotFoundException(typeof(T).Name); |
| | 1 | 65 | | } |
| | | 66 | | public virtual async Task<TResult> FirstAsync<TResult>(Specification<T, TResult> specification, CancellationToken ca |
| | | 67 | | { |
| | 2 | 68 | | var result = await GenerateQuery(specification).FirstOrDefaultAsync(cancellationToken); |
| | 2 | 69 | | return result ?? throw new EntityNotFoundException(typeof(T).Name); |
| | 1 | 70 | | } |
| | | 71 | | public virtual async Task<T?> FirstOrDefaultAsync(Specification<T> specification, CancellationToken cancellationToke |
| | | 72 | | { |
| | 2 | 73 | | return await GenerateQuery(specification).FirstOrDefaultAsync(cancellationToken); |
| | 2 | 74 | | } |
| | | 75 | | public virtual async Task<TResult?> FirstOrDefaultAsync<TResult>(Specification<T, TResult> specification, Cancellati |
| | | 76 | | { |
| | 2 | 77 | | return await GenerateQuery(specification).FirstOrDefaultAsync(cancellationToken); |
| | 2 | 78 | | } |
| | | 79 | | public virtual async Task<T?> SingleOrDefaultAsync(Specification<T> specification, CancellationToken cancellationTok |
| | | 80 | | { |
| | 3 | 81 | | return await GenerateQuery(specification).SingleOrDefaultAsync(cancellationToken); |
| | 2 | 82 | | } |
| | | 83 | | public virtual async Task<TResult?> SingleOrDefaultAsync<TResult>(Specification<T, TResult> specification, Cancellat |
| | | 84 | | { |
| | 3 | 85 | | return await GenerateQuery(specification).SingleOrDefaultAsync(cancellationToken); |
| | 2 | 86 | | } |
| | | 87 | | public virtual async Task<List<T>> ListAsync(CancellationToken cancellationToken = default) |
| | | 88 | | { |
| | 1 | 89 | | return await _dbContext.Set<T>().ToListAsync(cancellationToken); |
| | 1 | 90 | | } |
| | | 91 | | public virtual async Task<List<T>> ListAsync(Specification<T> specification, CancellationToken cancellationToken = d |
| | | 92 | | { |
| | 1 | 93 | | return await GenerateQuery(specification).ToListAsync(cancellationToken); |
| | 1 | 94 | | } |
| | | 95 | | public virtual async Task<List<TResult>> ListAsync<TResult>(Specification<T, TResult> specification, CancellationTok |
| | | 96 | | { |
| | 1 | 97 | | return await GenerateQuery(specification).ToListAsync(cancellationToken); |
| | 1 | 98 | | } |
| | | 99 | | public virtual async Task<int> CountAsync(CancellationToken cancellationToken = default) |
| | | 100 | | { |
| | 2 | 101 | | return await _dbContext.Set<T>().CountAsync(cancellationToken); |
| | 2 | 102 | | } |
| | | 103 | | public virtual async Task<int> CountAsync(Specification<T> specification, CancellationToken cancellationToken = defa |
| | | 104 | | { |
| | 3 | 105 | | return await GenerateQuery(specification, true).CountAsync(cancellationToken); |
| | 3 | 106 | | } |
| | | 107 | | public virtual async Task<int> CountAsync<TResult>(Specification<T, TResult> specification, CancellationToken cancel |
| | | 108 | | { |
| | 2 | 109 | | return await GenerateQuery(specification, true).CountAsync(cancellationToken); |
| | 2 | 110 | | } |
| | | 111 | | public virtual async Task<bool> AnyAsync(CancellationToken cancellationToken = default) |
| | | 112 | | { |
| | 2 | 113 | | return await _dbContext.Set<T>().AnyAsync(cancellationToken); |
| | 2 | 114 | | } |
| | | 115 | | public virtual async Task<bool> AnyAsync(Specification<T> specification, CancellationToken cancellationToken = defau |
| | | 116 | | { |
| | 3 | 117 | | return await GenerateQuery(specification, true).AnyAsync(cancellationToken); |
| | 3 | 118 | | } |
| | | 119 | | public virtual async Task<bool> AnyAsync<TResult>(Specification<T, TResult> specification, CancellationToken cancell |
| | | 120 | | { |
| | 2 | 121 | | return await GenerateQuery(specification, true).AnyAsync(cancellationToken); |
| | 2 | 122 | | } |
| | | 123 | | |
| | | 124 | | public virtual IAsyncEnumerable<T> AsAsyncEnumerable(Specification<T> specification) |
| | | 125 | | { |
| | 1 | 126 | | return GenerateQuery(specification).AsAsyncEnumerable(); |
| | | 127 | | } |
| | | 128 | | |
| | | 129 | | protected virtual IQueryable<T> GenerateQuery(Specification<T> specification, bool ignorePaging = false) |
| | | 130 | | { |
| | 22 | 131 | | var query = _evaluator.Evaluate(_dbContext.Set<T>(), specification, ignorePaging); |
| | 22 | 132 | | return query; |
| | | 133 | | } |
| | | 134 | | protected virtual IQueryable<TResult> GenerateQuery<TResult>(Specification<T, TResult> specification, bool ignorePag |
| | | 135 | | { |
| | 12 | 136 | | var query = _evaluator.Evaluate(_dbContext.Set<T>(), specification, ignorePaging); |
| | 12 | 137 | | return query; |
| | | 138 | | } |
| | | 139 | | } |