public DapperRepository_Tests() { _productDapperRepository = Resolve <IDapperRepository <Product> >(); _productRepository = Resolve <IRepository <Product> >(); _unitOfWorkManager = Resolve <IUnitOfWorkManager>(); _productDetailRepository = Resolve <IRepository <ProductDetail> >(); _productDetailDapperRepository = Resolve <IDapperRepository <ProductDetail> >(); _personRepository = Resolve <IRepository <Person> >(); _personDapperRepository = Resolve <IDapperRepository <Person> >(); _goodDapperRepository = Resolve <IDapperRepository <Good> >(); _dapperQueryFilterExecuter = Resolve <IDapperQueryFilterExecuter>(); }
public override IEnumerable <TEntity> GetAllPaged(Expression <Func <TEntity, bool> > predicate, int pageNumber, int itemsPerPage, string sortingProperty, bool ascending = true) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetPage <TEntity>( filteredPredicate, new List <ISort> { new Sort { Ascending = ascending, PropertyName = sortingProperty } }, pageNumber, itemsPerPage, Transaction)); }
public override IEnumerable <TEntity> GetSet(Expression <Func <TEntity, bool> > predicate, int firstResult, int maxResults, string sortingProperty, bool ascending = true) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetSet <TEntity>( filteredPredicate, new List <ISort> { new Sort { Ascending = ascending, PropertyName = sortingProperty } }, firstResult, maxResults, Transaction )); }
public override IEnumerable <TEntity> GetAll() { PredicateGroup predicateGroup = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(); return(Connection.GetList <TEntity>(predicateGroup, transaction: Transaction)); }
public override TEntity FirstOrDefault(Expression <Func <TEntity, bool> > predicate) { IPredicate pg = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetList <TEntity>(pg, transaction: Transaction).FirstOrDefault()); }
public override TEntity Single(Expression <Func <TEntity, bool> > predicate) { IPredicate pg = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetList <TEntity>(pg).Single()); }
public override IEnumerable <TEntity> GetSet(Expression <Func <TEntity, bool> > predicate, int firstResult, int maxResults, bool ascending = true, params Expression <Func <TEntity, object> >[] sortingExpression) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetSet <TEntity>(filteredPredicate, sortingExpression.ToSortable(ascending), firstResult, maxResults, Transaction)); }
public override IEnumerable <TEntity> GetAllPaged(Expression <Func <TEntity, bool> > predicate, int pageNumber, int itemsPerPage, bool ascending = true, params Expression <Func <TEntity, object> >[] sortingExpression) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetPage <TEntity>(filteredPredicate, sortingExpression.ToSortable(ascending), pageNumber, itemsPerPage, Transaction)); }
public override IEnumerable <TEntity> GetAll(Expression <Func <TEntity, bool> > predicate) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetList <TEntity>(filteredPredicate, transaction: Transaction)); }
public override int Count(Expression <Func <TEntity, bool> > predicate) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.Count <TEntity>(filteredPredicate, Transaction)); }
public DapperRepository(IUnitOfWork unitofwork, IDbConnectionProvider dbconnectionProvider, IDapperQueryFilterExecuter dapperQueryFilterExecuter) { _unitofwork = unitofwork; _dbconnectionProvider = dbconnectionProvider; _dapperQueryFilterExecuter = dapperQueryFilterExecuter; }