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.