This question is locked. New answers and comments are not allowed.
Hello,
I'm using WCF RIA Services 1.0 not the SP1 and latest silverlight libs...
I used the code from the Data Virtualization first look demo...
Straight cut&paste.
My grid looks like that:
<telerik:RadGridView Grid.Row="1" Name="grdHistory" Margin="0,5" IsReadOnly="True" AutoGenerateColumns="False" ShowInsertRow="False" ItemsSource="{Binding HistoryOrderLines}" ShowGroupFooters="True" ShowColumnFooters="True" Exporting="grdHistory_Exporting" CanUserInsertRows="False" CanUserDeleteRows="False" ScrollViewer.HorizontalScrollBarVisibility="Visible" ScrollViewer.VerticalScrollBarVisibility="Visible" > <telerik:RadGridView.Columns> <telerik:GridViewDataColumn Header="Année" DataMemberBinding="{Binding PeriodeAnnee}" UniqueName="PeriodeAnnee" /> <telerik:GridViewDataColumn Header="Mois" DataMemberBinding="{Binding PeriodeMois}" UniqueName="PeriodeMois" /> <telerik:GridViewDataColumn Header="Code Client" DataMemberBinding="{Binding CodeClient}" UniqueName="CodeClient" /> <telerik:GridViewDataColumn Header="Distribution" DataMemberBinding="{Binding Distribution}" UniqueName="Distribution" /> <telerik:GridViewDataColumn Header="Matricule" DataMemberBinding="{Binding Matricule}" UniqueName="Matricule" /> <telerik:GridViewDataColumn Header="Badge" DataMemberBinding="{Binding Badge}" UniqueName="Badge"> etc...Nothing special.
Now when I load my data, the first lines come already selected. See my screenshot.
The only thing I see is that I use composition. Here is my query:
public IQueryable<CustomerPresentationModel> GetBeneficiaryOrderLinesHisto()
{
var ctx = this.ObjectContext;
var customers = from o in ctx.OrderLines // where o.CreatedOn >= begin && o.CreatedOn <= end
join b in ctx.Beneficiaries.Include("FacialValue") on o.BenID equals b.BenID
join c in ctx.Commands on o.CmdID equals c.CmdID where c.IsHistory == true
select new CustomerPresentationModel()
{
PeriodeMois = c.PeriodeMois,
PeriodeAnnee = c.PeriodeAnnee,
Abscence = o.Abscence,
//Anomalie, empty message storage
Badge = b.Badge,
BenID = b.BenID,
Civ = b.Civ,
CodeClient = b.CodeClient,
etc...
};
return customers.OrderBy(e => e.CodeClient).ThenBy(e => e.Distribution).ThenBy(e => e.Nom);
}
My object definition:public partial class CustomerPresentationModel { public int Abscence { get; set; } public string Badge { get; set; } [Key] public int BenID { get; set; } public string Civ { get; set; } public Nullable<DateTime> CreatedOn { get; set; } public int CmdID { get; set; }
public int OdlID { get; set; } public string PeriodeMois { get; set; } public string PeriodeAnnee { get; set; } public string Personalisation { get; set; } etc... }Any help would be much appreciated...
Thanks a lot in advance,
John.
