DevForce Community Forum : Using the new methods with fetchOptions

Using the new methods with fetchOptions : Really nice Marcel, thank you...

Thu, 20 Dec 2012 10:03:38 -700

Author: cefernan
Subject: 3860
Posted: 20-Dec-2012 at 10:03am

Really nice Marcel, thank you very much.

Using the new methods with fetchOptions : Sorry, haven't had...

Thu, 20 Dec 2012 09:38:17 -700

Author: mgood
Subject: 3860
Posted: 20-Dec-2012 at 9:38am

Sorry, haven't had my coffee yet. Just realized that's an ambiguous signature. We have to name the extension method something else like IncludeMany.

public static void IncludeMany<T>(this IFetchOptions<T> fetchOptions, string includeProperties)

{

if (string.IsNullOrWhiteSpace(includeProperties)) return;

ParseIncludeProperties(includeProperties)

.ForEach(x => fetchOptions.Include(x));

}

private static IEnumerable<string> ParseIncludeProperties(string includeProperties)

{

return includeProperties.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

}

var entityData = await _unitOfWork.Entities.FindAsync(SetPredicate(), T => T.OrderBySelector(sortSelector),

options => options.IncludeMany(includeProperties));

Or better yet, ditch the comma separated list and go with an IEnumerable. You probably already have an IEnumerable from which you currently build the comma separated list.

        public static void Include<T>(this IFetchOptions<T> fetchOptions, IEnumerable<string> properties)
        {
            properties.ForEach(x => fetchOptions.Include(x));
        }
 
var properties = new [] { "A", "B", "C" };
var entityData = await _unitOfWork.Entities.FindAsync(SetPredicate(), T => T.OrderBySelector(sortSelector), 
             options => options.Include(properties ));

Edited by mgood - 20-Dec-2012 at 9:39am

Using the new methods with fetchOptions : If you want to eager fetch...

Thu, 20 Dec 2012 09:11:34 -700

Author: mgood
Subject: 3860
Posted: 20-Dec-2012 at 9:11am

If you want to eager fetch multiple related entities, you simply chain together several Includes as in options => options.Include("A").Include("B").Include(x => x.C) and so forth.

If you have an exisiting comma separated list, you could write a little extension method like so:

        public static void Include<T>(this IFetchOptions<T> fetchOptions, string includeProperties)
        {
            if (string.IsNullOrWhiteSpace(includeProperties)) return;
            ParseIncludeProperties(includeProperties)
                .ForEach(x => fetchOptions.Include(x));
        }
        private static IEnumerable<string> ParseIncludeProperties(string includeProperties)
        {
            return includeProperties.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
        }
 
var entityData = await _unitOfWork.Entities.FindAsync(SetPredicate(), T => T.OrderBySelector(sortSelector), 
                                options => options.Include(includeProperties));

Using the new methods with fetchOptions : Hi,First of all, thanks for update...

Thu, 20 Dec 2012 04:05:07 -700

Author: cefernan
Subject: 3860
Posted: 20-Dec-2012 at 4:05am

Hi,

First of all, thanks for update Cocktail and release new interesting features.

I've updated to Cocktail 2.2.0 and I've seen the new way to configure eager fetching using fetchOptions.

I have this call:

var entityData = await _unitOfWork.Entities.FindAsync(SetPredicate(), T => T.OrderBySelector(sortSelector), IncludeProperties);

I'd like to change and use fetchOptions. My property "IncludeProperties" is a string separated by comma.

How to do that?