Hi David,

Can you post the razor snippet ? (I don't think nuPickers should query the DB on rendering - unless it's using DB relations)

Thanks, Hendy

Well my extension method nuPickers.Picker.AsGuids() appears to be the last place that it touches my code, which is this:

public static IEnumerable<Guid> AsGuids(this nuPickers.Picker picker)
{
    return picker == null ? new Guid[0] : picker.PickedKeys.AsGuids();
}

To be clear, the reference to AsGuids in the code above is a reference to a different method of the same name(below), but the stack trace suggests this is never called.

public static IEnumerable<Guid> AsGuids(this IEnumerable<string> source)
{
    foreach (var s in source)
    {
        Guid r;
        if (Guid.TryParse(s, out r))
            yield return r;
    }
}

It is a dotnet source though. This is the source:

public class NewsSubjectPickerSource : IDotNetDataSource
{
    IEnumerable<KeyValuePair<string, string>> IDotNetDataSource.GetEditorDataItems(int contextId)
    {
        var newsService = new NewsService(UmbracoContext.Current);
        return newsService.Subjects.Distinct().ToDictionary(c => c.UniqueId.ToString(), c => c.SubjectName);
    }
}

In GetEditorDataItems the call to newsService.Subjects just results in loading from cache (or fetching) some nested content IPublishedContent items, but I can't see anything here relating to nuPickers to which the DB call relates.

Is there any way to step the code and see at what point that DB call is made?

Hi Hendy,

That makes sense. I think it might be doing some caching already (though it could be my own caching) as I wasn't seeing this everytime.

Thanks for identifying the issue, I'll live with it for now and upgrade when I can.

Ta!

is working on a reply...