是否可能与0关联?1RIA服务的数据?-Isitpossibletogetassociatedlike0..1databyRIAServices?

I can get 1..0 data by RIA Services fine.

我可以1 . .0数据由RIA服务完成。

 var sFiltered = this.ObjectContext.Sequences.Include("Schedules").Include("Events")
                                    .Include("Events.EventFrames")
                                    .Include("Events.EventRules")
                                    .Include("Events.EventFrames.EventFramePlugins")
                                    .Include("Events.EventFrames.EventFramePlugins.EventFramePluginParameters")
                                    .Include("Events.EventFrames.EventFramePlugins.EventFramePluginContentItems")
                                    .Where(s => s.ID == schedule.SequenceID).FirstOrDefault();

So the code above works great.

上面的代码很好。

The problem is that I want to get data by ClientContentItemID [EventFramePlugins] from [ClientContentItemElements]

问题是我想从[ClientContentItemElements]获取ClientContentItemID [EventFramePlugins]的数据

Please have a look at the image below. But what I don't like to do is to use 1 extra request from the WPF client to get this data. So the idea is use 1 request to get ALL data I need.

请看下面的图片。但是我不喜欢使用WPF客户端的1个额外请求来获取这些数据。这个想法是用一个请求来获取我需要的所有数据。

Thank you!!!

谢谢! ! !

1 个解决方案

sequences.Include.....Where(s => s.ID == schedule.SequenceID).SelectMany(s => s.Events).SelectMany(e => e.EventFrames).SelectMany(ef => ef.EventFramePlugins)
    .SelectMany(efp => efp.EventFramePluginContents).SelectMany(efpc => efpc.ClientContentItems).
    SelectMany(cci => cci.ClientContentItemElemts).Where(ccie => ccie.ClientCOntentItemElementId== myValue).
    Select(
        ccie =>
        new
            {
                ccie,
                ccie.ClientContentItem.EventFramePluginContentItem.EventFramePlugin.EventFrame.Event.
            Sequence
            });