See https://world.episerver.com/blogs/Jonas-Bergqvist/Dates/2010/3/Dynamic-Data-Store-LINQ-implementation--from-the-inside/
Thanks Paul,
but I was not able to fix my problem with the link you have provided.
The blog post you provided is not about this particular problem.
The question in here is: How can i querry nested collections using DDS.
Using a different qyerry, based on the blog:
var config = (from myCon in store.Items<MyConfiguration>()
where myCon.MyNumber == 1
from myConChoosedPage in myCon.ChoosedPages
where myConChoosedPage.IsSelected
select myCon).ToList();
I still get 'The method 'SelectMany' is not supported' exception.
Getting all items from DDS and then quering them works:
var items = store.Items<MyConfiguration>()
.ToList()
.FirstOrDefault( item => item.MyNumber == 0 &&
item.ChoosedPages.Any( y => y.IsSelected ));
But I dont want to load all items. I want to run the querry on the data in the database.
Hi!
I want to save some data with DDS, but keep having NotSupported exceptions when using linq querries.
I have done it with Entity Framework, but I wanted to migrate to Episerver API.
Is it even possible with the Episerver querry provider?
Code example:
This compiles, but throws 'Method 'Any' Not supported' exception.
Please help.