public int Count(Expression <Func <Game, bool> > filter = null)
{
var entitiesSql = _sqlGameRepository.GetMany(0, int.MaxValue, filter).ToList();
var entitiesMongo = _mongoGameRepository
.GetMany()
.Where(filter.Compile())
.ToList();
var result = entitiesSql
.Concat(entitiesMongo)
.AsQueryable()
.GroupBy(x => x.Id)
.Select(x => x.First())
.Count(x => !x.IsDeleted);
return(result);
}
public IEnumerable <TEntity> GetMany(int skip = 0,
int take = Int32.MaxValue,
Expression <Func <TEntity, bool> > filter = null,
Expression <Func <TEntity, object> > orderBy = null,
SortDirection sortingDirection = SortDirection.Ascending,
params Expression <Func <TEntity, object> >[] includes)
{
var entitiesSql =
_sqlRepository.GetMany(0, int.MaxValue, filter, orderBy, SortDirection.Ascending, includes);
var entitesMongo = _mongoRepository.GetMany(filter: filter).ToList();
var allEntities = entitiesSql.Concat(entitesMongo)
.AsQueryable()
.GroupBy(x => x.Id)
.Select(p => p.First())
.Skip(skip)
.Take(take)
.ToList();
return(allEntities);
}
public IEnumerable <ShipperModel> GetAllShippers()
{
return(_mongoRepository.GetMany());
}