partial entity loading and management in silverlight / wcf ria

Posted by Dan Wray on Stack Overflow See other posts from Stack Overflow or by Dan Wray
Published on 2010-04-16T13:08:57Z Indexed on 2010/04/16 13:13 UTC
Read the original article Hit count: 355

I have a Silverlight 4 app which pulls entities down from a database using WCF RIA services. These data objects are fairly simple, just a few fields but one of those fields contains binary data of an arbitrarily size. The application needs access to this data basically asap after a user has logged in, to display in a list, enable selection etc.

My problem is because of the size of this data, the load times are not acceptable and can approach the default timeout of the RIA service.

I'd like to somehow partially load the objects into my local data context so that I have the IDs, names etc but not the binary data. I could then at a later point (ie when it's actually needed) populate the binary fields of those objects I need to display.

Any suggestions on how to accomplish this would be welcome.

Another approach which has occurred to me whilst writing this question (how often does that happen?!) is that I could move the binary data into a seperate database table joined to the original record 1:1 which would allow me to make use of RIA's lazy loading on that binary data.

again.. comments welcome! Thanks.

© Stack Overflow or respective owner

Related posts about Silverlight

Related posts about wcf-ria-services