Silverlight client - simple RIA select where clause

Question

Hi

The following code for RIA works in my silverlight client. But I dont want all the data from table "tbLeagues" - so how would i filter it?

            JasonsDomainContext context = new JasonsDomainContext();
        dgLeagues.ItemsSource = context.tbLeagues;
        context.Load(context.GetTbLeagueQuery());

Reading many articles out there the norm seems to do this.... ( With a where clause) but even this normal select gives me no records in my datagrid.

JasonsDomainContext context = new JasonsDomainContext();
        dgLeagues.ItemsSource = from l in context.tbLeagues
                                select l.dbLeagueName;

        context.Load(context.GetTbLeagueQuery());

1. What am I doing wrong?
2. Is this the best approach?

thanks, jason

Answer 1

Have you tried to add the where clause in your JasonsDomainServices GetTbLeague method?