DevForce Community Forum : IPager<T> http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : Community Forum : IPager<T> Fri, 10 Apr 2026 19:41:49 -700 Thu, 21 Nov 2013 06:38:41 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4605 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ IPager<T> : Thank you for you answer.We have... http://www.ideablade.com/forum/forum_posts.asp?TID=4605&PID=17252#17252 Author: cypher
Subject: 4605
Posted: 21-Nov-2013 at 6:38am

Thank you for you answer.

We have stripped out the generation of Predicates (Filters on an Entity) and pass it now into a SearchService, that has a Count And IPager Method.


   /// <summary>
    ///     Predicate to filter the entities.
    /// </summary>
    /// <typeparam name="T">the Model/Projection to apply the filter on</typeparam>
    public interface IPredicate<T> : where T : IEntity
    {
        #region Public Methods

        /// <summary>
        ///     Applies the filter.
        /// </summary>
        /// <returns></returns>
        Expression<Func<T, bool>> ApplyFilter(Expression<Func<T, bool>> filters);

        #endregion
    }

Here is a sample implementation:

 public class CustomerFreeTextPredicate : IPredicate<Customer>
    {
        #region Fields

        private readonly string _searchTerm;

        #endregion

        #region Constructors and Destructors

        public CustomerFreeTextPredicate(string searchTerm)
        {
            _searchTerm = searchTerm;
          //  DisplayName = string.Format(Resources.CustomerFreeTextPredicate, _searchTerm);
        }

        #endregion

        #region IPredicate<Customer> Members

        public string DisplayName { get; set; }

        public Expression<Func<Customer, bool>> ApplyFilter(Expression<Func<Customer, bool>> filter)
        {
            return
                filter.And(
                    x =>
                    (x.CustomerName.Contains(_searchTerm) || x.CustomerNumber.Contains(_searchTerm)) &&
                    x.LegalEntityRefs.Any(
                        ler =>
                        ler.LegalEntityID.Equals(VisUser.LegalEntityId) && (ler.IsDeleted.HasValue && ler.IsDeleted.Value == false) &&
                        ler.IsActive.Equals(true)));
        }

        #endregion
    }


That all works, due to you fantastic implementaion of IRepository<T> !
]]> Thu, 21 Nov 2013 06:38:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4605&PID=17252#17252 IPager<T> : Unfortunately, there is not. EF... http://www.ideablade.com/forum/forum_posts.asp?TID=4605&PID=17250#17250 Author: mgood
Subject: 4605
Posted: 20-Nov-2013 at 12:58pm

Unfortunately, there is not. EF doesn't provide an inline count. You either have to run a count query or fetch the last page to know how many total records there are. That's just how it is. I recommend not to use the Total properties from IPager<> and instead just make a call to CountAsync() to get the total count and use that to calculate the number of pages etc. ]]> Wed, 20 Nov 2013 12:58:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4605&PID=17250#17250 IPager<T> : We have started to Implement... http://www.ideablade.com/forum/forum_posts.asp?TID=4605&PID=17246#17246 Author: cypher
Subject: 4605
Posted: 20-Nov-2013 at 7:31am

We have started to Implement the IPagerRepository<T> with Cocktail.

The Implementation is straight forward with the help of you'r Documentation.

But we are really not happy, that we have to Query the complete last Page, in order to have the TotalAmount initalized in The 
IPager<T>

We have traced the Querys on SQL Profiler, and found out, that we have to fire three Querys 

1.(Count) 
2. LastPage
3. FirstPage

To initialize the IPager<T> to show the Pager.TotalDataSourceItemCount.

This is really sad, because we would like to query the database for the cound, if the first query starts.

Is there a Way for you to implement the IPager<T> from Cocktail, to have it initialize (Count) if the Pager.TotalDataSourceItemCount == -1 without loading the last page?

We really want to avoid, loading the last page, just to initialize the pager (get the TotalSourceItem)



Edited by cypher - 20-Nov-2013 at 7:36am]]> Wed, 20 Nov 2013 07:31:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4605&PID=17246#17246