Hi,

I created a behaviour using dynamic properties using examples in this thread. XamPivotGrid/XamPivotDataSelector still does not work(does not show anything in the selector). The documentation is not helpful too. Could you please look into the code below and suggest if i am missing something.

Thanks! 

public class XamPivotDataSelectorBehavior : Behavior<XamPivotDataSelector>
{

public Type ModelType
{
get { return (Type)(GetValue(ModelTypeProperty));}
set { SetValue(ModelTypeProperty, value);}
}

public static readonly DependencyProperty ModelTypeProperty =
DependencyProperty.Register("ModelType", typeof(Type), typeof(XamPivotDataSelectorBehavior));

public IEnumerable DataSource
{
get { return (IEnumerable)GetValue(DataSourceProperty); }
set { SetValue(DataSourceProperty, value); }
}

public static readonly DependencyProperty DataSourceProperty =
DependencyProperty.Register("DataSource", typeof(IEnumerable), typeof(XamPivotDataSelectorBehavior));

private static void DataSourceChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
{
if (d is XamPivotDataSelectorBehavior)
{
var obj = d as XamPivotDataSelectorBehavior;
if (obj != null)
{
try
{
var grid = obj.AssociatedObject as XamPivotDataSelector;
obj.DataSourceChanged(grid);
// point datasource to flat source, no need to rebind

}
catch (Exception ex)
{
}
}
}
}

public static readonly DependencyProperty GridDataChangedProperty =
DependencyProperty.Register("GridDataChanged", typeof(bool), typeof(XamPivotDataSelectorBehavior), new PropertyMetadata(DataSourceChanged));

public bool GridDataChanged
{
get { return (bool)GetValue(GridDataChangedProperty); }
set { SetValue(GridDataChangedProperty, value); }
}

protected virtual void DataSourceChanged(XamPivotDataSelector selector)
{
if (selector.DataSource == null)
{
var dataSource = new FlatDataSource();

selector.DataSource = dataSource;

}

((FlatDataSource)selector.DataSource).ItemsSource = GenerateTypedList(DataSource);

}

protected virtual IList GenerateTypedList(IEnumerable dataSource)
{

DynamicTypeBuilder typeBuilder = new DynamicTypeBuilder
{
DynamicTypeName = ModelType.FullName,
DynamicAssemblyName = "TrendsAssembly"
};

var dynamicPropertyList = new List<DynamicTypePropertyInfo>();
foreach (PropertyInfo propertyInfo in ModelType.GetProperties(BindingFlags.Public))
{
DynamicTypePropertyInfo dtpi = new DynamicTypePropertyInfo();
dtpi.PropertyName = propertyInfo.Name;
dtpi.PropertyType = propertyInfo.PropertyType;
dynamicPropertyList.Add(dtpi);

}

var dynamicType = typeBuilder.GenerateType(dynamicPropertyList);

//var type = dataSource.GetType().GetGenericArguments().First();

Type listType = typeof(List<>);
Type genericListType = listType.MakeGenericType(dynamicType);
var list = (IList)Activator.CreateInstance(genericListType);

foreach (var item in dataSource)
{

var dynamicInstance = Activator.CreateInstance(dynamicType);

foreach (var pi in dynamicType.GetProperties(BindingFlags.Public))
{
var modelPI = ModelType.GetProperty(pi.Name);
pi.SetValue(dynamicInstance, modelPI.GetValue(item,null),null);

}

list.Add(dynamicInstance);
}

return list;

}

}

Hello, I'm trying to do something similar in SL4 using the the 10.3 version of NetAdvantage and the InfragisticsSL4.Olap.v10.3.dll doesn't exist.  I checked to see if it got renamed but it appears as if the assembly is no longer available in 10.3.  Do you know if this can still be done in 10.3?

Thanks.

Excellent answer and suggestion. This solves our problem. We created a quick test on it, and now can create object collections on the fly from definitions in the database and then pass on to the data visualization controls.

Thank you very much for the quick and informative answer.