DevForce Community Forum : Lazy load sort order http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Lazy load sort order Wed, 13 May 2026 22:41:38 -700 Mon, 15 Aug 2011 12:44:27 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2872 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Lazy load sort order : PerfectThanks Silvio http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11435#11435 Author: Togas
Subject: 2872
Posted: 15-Aug-2011 at 12:44pm

Perfect

Thanks Silvio
]]> Mon, 15 Aug 2011 12:44:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11435#11435 Lazy load sort order : Hi Togas,Since you're... http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11433#11433 Author: sbelini
Subject: 2872
Posted: 15-Aug-2011 at 12:17pm

Hi Togas,
 
Since you're doing the binding to the DataGrid in the XAML, you will need to use a CollectionViewSource. There you can set the sort order there and then bind it to your DataGrid.
 
Take for instance our Silverlight Tour of DevForce sample (in the DevForce Resource Center).
 
Instead of binding the Orders of currentEmployee directly into the DataGrid
 
<sdk:DataGrid Name="EmployeeOrdersGrid"
              ItemsSource="{Binding ElementName=EmployeeDataForm,
                                    Path=CurrentItem.Orders}" />
 
 
you'd bind the Orders to the CollectionViewSource, sort it, and bind the CollectionViewSource to the DataGrid
 
 
<Grid.Resources>
  <CollectionViewSource x:Key="OrdersViewSource" Source="{Binding ElementName=EmployeeDataForm,
                                                                   Path=CurrentItem.Orders}">
    <CollectionViewSource.SortDescriptions>
      <scm:SortDescription PropertyName="Freight"/>
    </CollectionViewSource.SortDescriptions>
  </CollectionViewSource>
</Grid.Resources>
 
...
 
<sdk:DataGrid Name="EmployeeOrdersGrid"
              ItemsSource="{Binding Source={StaticResource OrdersViewSource}}"
/>
 
Regards,
   Silvio.
]]> Mon, 15 Aug 2011 12:17:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11433#11433 Lazy load sort order : Yourassumptionwas correct, I&#039;m... http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11396#11396 Author: Togas
Subject: 2872
Posted: 10-Aug-2011 at 11:50am

Your assumption was correct, I'm binding to a datagrid.  It's a basic Master-Detail type page.






<sdk:DataGrid AutoGenerateColumns="False" 
	ItemsSource="{Binding SelectedOrder.OshkoshEquipments}"
	SelectedItem="{Binding SelectedEquipment, Mode=TwoWay}">
...

</sdk:DataGrid>


Here is the relevant code from my view model

Public Property OshkoshOrders As ObservableCollection(Of Oshkosh)
Private Sub LoadData
      OshkoshOrders = New ObservableCollection(Of Oshkosh)
 
      Dim qOrders = _mgr.Oshkoshes
      qOrders.ExecuteAsync(Sub(o)
                             If o.HasError Then
                               Throw New InvalidOperationException("Query failed")
                             End If
                             o.Results.ForEach(Sub(oe)
                                                 OshkoshOrders.Add(oe)
                                               End Sub)
 
                             SelectedOrder = OshkoshOrders.FirstOrDefault
                           End Sub)
End Sub



Edited by Togas - 10-Aug-2011 at 11:53am]]> Wed, 10 Aug 2011 11:50:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11396#11396 Lazy load sort order : Hi Togas, I assume that if... http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11395#11395 Author: sbelini
Subject: 2872
Posted: 10-Aug-2011 at 11:39am

Hi Togas,
I assume that if you want to sort the order of a navigation property (i.e. lazy loading) you are probably binding it to something.
If you want to load related entities during your initial load query, then you will need to use .Include:
 
var initialLoadQuery = mgr.Customer
                          .Include("Orders");
 
in the case above, Orders are not being ordered because it's not bound to anything. (it was simply loaded in the EntityCache using eager loading)
 
Could you explain in detail what you are trying to accomplish, so I can better understand your issue?
 
Regards,
   Silvio.
]]> Wed, 10 Aug 2011 11:39:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11395#11395 Lazy load sort order : Silvio,Where would I put that?... http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11393#11393 Author: Togas
Subject: 2872
Posted: 10-Aug-2011 at 7:16am

Silvio,

Where would I put that?  My initial thought was that should be part of my initial load query but my child table isn't an option when I query the parent table and I also noticed you are only referencing a single customer.

The 2 tables are linked in my model
]]> Wed, 10 Aug 2011 07:16:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11393#11393 Lazy load sort order : Hi Togas,TryaCustumer.Orders.OrderBy(ord... http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11381#11381 Author: sbelini
Subject: 2872
Posted: 09-Aug-2011 at 3:45pm

Hi Togas,
 
Try
 
aCustumer.Orders.OrderBy(ord => ord.Freight)
 
Regards,
   Silvio.
]]> Tue, 09 Aug 2011 15:45:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11381#11381 Lazy load sort order : Is there a way to set the sort... http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11366#11366 Author: Togas
Subject: 2872
Posted: 08-Aug-2011 at 7:23am

Is there a way to set the sort order when you are using lazy loading?]]> Mon, 08 Aug 2011 07:23:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2872&PID=11366#11366