R – Consuming Database Result Sets with Silverlight DataGrid

datagriddatatableessbasesilverlightxml

So I have a WCF Service that gets a result set from a database (not SQL) – I can get this data as a DataTable, string[][], etc.

I can't use LINQ or ADO.NET Entity Framework very easily as it's not coming from an SQL DB.

So my question is:

What's the best way to package this data for transmission across the wire? I can use any data structure supported in Silverlight.
What's a good way to consume it?
Is there any easy way to connect it to a DataGrid?

You should package data into service entities that are exposed by your WCF Service.
WCF basic HTTP binding in SL2, in SL3 you have many more options
<DataGrid ItemsSource="{Binding MyCollectionOfObjects}" />

After Much Googling, this tutorial proved to help me do exactly what I wanted to do and was a fantastic help!

Good luck to anyone who continues with this implementation.

:-D

Then don't forget to "include" your child table in the Query lookup on your domain service class.

ex:

public IQueryable<Car> GetCars()
{
    return this.ObjectContext.Cars.Include("Make");
}

replace the names with your own.

PS: remember to do all the steps that the blog indicates.