R – Silverlight 3 – RIA Services and LINQ

linqsilverlightsilverlight-3.0

This is a basic LINQ question.

In my RIA Services Application, I have a Family object with Contacts in a child list. This is a entity framework application.

I am wondering why when I select my fam the child list of Contacts are not loaded, well I know that it must because of lazy loading but how to I get my query to load the children.

var fam = from f in ContextContainer.FamilyCtx.Families
                        where f.familyId == fID
                        select f;

Best Answer

I think you should have something similar to:

ContextContainer.LoadFamilies(fam, null);

The "LoadFamilies" is autogenerated from RIA services.

there should then be an OnLoaded event when the async result has been completed.

you can then say somelistbox.ItemSource = e.LoadedEntities

Related Solutions

C# – LINQ query on a DataTable

You can't query against the DataTable's Rows collection, since DataRowCollection doesn't implement IEnumerable<T>. You need to use the AsEnumerable() extension for DataTable. Like so:

var results = from myRow in myDataTable.AsEnumerable()
where myRow.Field<int>("RowNo") == 1
select myRow;

And as @Keith says, you'll need to add a reference to System.Data.DataSetExtensions

AsEnumerable() returns IEnumerable<DataRow>. If you need to convert IEnumerable<DataRow> to a DataTable, use the CopyToDataTable() extension.

Below is query with Lambda Expression,

var result = myDataTable
    .AsEnumerable()
    .Where(myRow => myRow.Field<int>("RowNo") == 1);

Linq – Multiple “order by” in LINQ

This should work for you:

var movies = _db.Movies.OrderBy(c => c.Category).ThenBy(n => n.Name)

Best Answer

Related Solutions

C# – LINQ query on a DataTable

Linq – Multiple “order by” in LINQ

Related Topic