Ria Services loading foreign keys with Linq-to-SQL

Posted by Stephan on Stack Overflow See other posts from Stack Overflow or by Stephan
Published on 2010-03-31T15:57:01Z Indexed on 2010/04/20 21:23 UTC
Read the original article Hit count: 252

Filed under:

Silverlight

|

ria-services

|

linq-to-sql

I have a database that consists of 5 tables : Course, Category, Location, CourseCategories, and CourseLocations. The last 2 tables just contain the two foreign keys. A Course has many-to-many relationships with both category and location.

I am trying to load the data into a Silverlight app using Ria Services. My DB model is Linq-to-SQL. I have tried adding the [Include] attribute to the metadata classes and I have added the DataLoadOptions so it should load the all tables when you ask for a Course. However on the client side I am never getting back any entries in the CourseCategories and CourseLocations properties.

What else needs to be done to get the foreign key relationships to exist across the serialization.

© Stack Overflow or respective owner

Related posts about Silverlight

Silverlight 4 Released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
The final release of Silverlight 4 is now available. What is in the Silverlight 4 Release Silverlight 4 contains a ton of new features and capabilities. In particular we focused on three scenarios with this release: Further enhancing media support Building great business… >>> More
Performance of Silverlight Datagrid in Silverlight 3 vs Silverlight 4 on a mac

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Silverlight Beta 4 for a LOB application. After finding out today that I'll have to wait perhaps 4 months to be able to develop with SL4 on Visual Studio 2010 I'm thinking I need to downgrade my application to SL3 but thats another question. The problem is I'm noticing absolutely abismal… >>> More
Silverlight TV 15: Announcing Silverlight 4 RC at MIX 10

as seen on Dot net Slackers - Search for 'Dot net Slackers'
John and Adam discuss Silverlight 4 RC, following up the MIX10 keynote announcement of Silverlight 4 RC by discussing what is new and what materials have been released on the Channel 9 learning center website. They cover their picks for some of the most impactful features in Silverlight 4 RC… >>> More
Silverlight TV 14: Developing for Windows Phone 7 with Silverlight

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Silverlight TV is here at MIX10 where Windows Phone 7 (WP7) and Silverlight just became the best match since peanut butter and chocolate! Mike Harsh, Program Manager for the Silverlight team working on WP7, joins John Papa to demonstrate the WP7 device and the tooling used to create applications for… >>> More
Silverlight Commands Hacks: Passing EventArgs as CommandParameter to DelegateCommand triggered by Ev

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Today I've tried to find a way how to pass EventArgs as CommandParameter to DelegateCommand triggered by EventTrigger. By reverse engineering of default InvokeCommandAction I find that blend team just ignores event args.To resolve this issue I have created my own action for triggering delegate commands… >>> More

Related posts about ria-services

Upgrading to WCF RIA Services v1.0 and Ria Services Toolkit

as seen on Dot net Slackers - Search for 'Dot net Slackers'
The kind folks on the Silverlight and RIA Services teams have come out with v1.0 of RIA Services. However, the instructions they provide can be a bit misleading as to What does what.Heres the skinny:1) You can download the Silverlight 4 Tools installer, dated 5/13/2010 here. This will uninstall previous… >>> More
Setting up a new Silverlight 4 Project with WCF RIA Services

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Many of my clients are actively using Silverlight 4 and RIA Services to build powerful line of business applications. Getting things set up correctly is critical to being to being able to take full advantage of the RIA services plumbing and when developers struggle with the setup they tend to shy… >>> More
RIA Services vs ADO.NET Data Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience… >>> More
A WaspKiller Game with Silverlight 3, .NET RIA Services, MVP and MVVM Patterns Part 2

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this second part, we will continue to discuss the WaspKiller game development—to extend the functionalities with the server-side database support. As mentioned in the first part, we’re going to rest upon another well-known design pattern, MVVM, to achieve the extension, and at the same time, introduce… >>> More
WCF Ria Services For Real

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In my previous post I discussed creating the database and tables for the Silverlight HVP configuration data. All that was great, and worked just dandy until it was time to get the data from the database server to the application running on the client. But, I thought, How hard can it be? … >>> More