René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Issue with Inlinecount with navigation properties","articleBody":"Hi,\n\nI'm having some trouble with using the inlinecount with a child navigation property using projections.\n\nHere are the classes:\n\n```\npublic class Person\n{\n    public int ID { get; set; }\n    public string FirstName { get; set; }\n    public string LastName { get; set; }\n    public ICollection\u003cAddress\u003e Addresses { get; set; }\n}\n\npublic class Address\n{\n    public int ID { get; set; }\n    public string FirstLine { get; set; }\n    public string SecondLine { get; set; }\n}\n```\n\nAnd here is the relevant code:\n\n_unitOfWork.PersonRepository.GetDbSet()\n        .Select(p =\u003e new PersonDTO\n        {\n            ID = p.ID,\n            FirstName = p.FirstName,\n            LastName = p.LastName,\n            Address = p.Address.Select(x =\u003e new AddressDTO { Id = x.ID, FirstLine = x.FirstLine, SecondLine = x.SecondLine}).ToList()\n        })\n        .LinqToQuerystring(typeof(PersonDTO), query));\n\nEverything works fine (including filtering, sorting) except when I introduce the Inlinecount=allpages querystring. The inner exception that i'm getting is: \n\n\"There is already an open DataReader associated with this Command which must be closed first.\"\n\nIf I do a ToList().AsQueryable() between the .linqToQueryString and the Select statement it works fine but that means that first the entire dataset is queried and then the filtering happens on the returned dataset. I would like to avoid that as we're dealing with a large dataset. Is there any way I can get the required data with a single call to the API?\n\nThanks\nBest Regards\n\nVishal\n","author":{"url":"https://github.com/maganuk","@type":"Person","name":"maganuk"},"datePublished":"2015-11-17T17:26:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/63/LinqToQuerystring/issues/63"}