Ria using EFExtensions to get Multiple Result Sets from Stored Procedure in a single call ?

 hello,

i trying solution following problem:

a. silverlight client loads query entity , related entities. (i have declared [include] in metadata)

b. domainservice uses efextensions materializer entity , related entities single call 1 stored procedure returns entities in multiple result sets.

c. domainservice shall return entity , related entities silverlight client.

here problem. when add .include("...") gets related entities again database don't want because stored procedure returned related entities , materializer bound them context.

 does has solution problem?

thanks

bernd

 ok, figured out.

in scenario domainservice function has have return type ienumerable<t> instead of iqueryable<t>.

to force domainservice return related entities context not enough add [include] attribute link entity, has set other related entity metadata.

this result in nice , simple "all @ once" transfer single stored procedure call silverlight client context.

 

i aware english not best hoping people understand asking for. seems me many people here not read questions or not try understand scenarios before come more or less useless answers. frustrating , makes many forums useless.

please answer questions when sure you've understood question !

cheers

bernd

Silverlight  >  WCF RIA Services with Silverlight