Viv,
For the single value it worked.
However, I discovered that this code didn't work correctly:
matrixTemplateViewModel.AllPossibleValues = _matrixTemplateValuesAdapter.GetAll().Select(v => new ValueAttribute
{
ValueName = v.ValueName,
AttributeId = v.AtnameId,
Hidden = v.Hidden
}).Distinct().OrderBy(x=>x.AttributeId).ThenBy(y=>y.ValueName).ToList();
The list I got back contained all rows form the templates table, not just distinct values by these 3 columns.
Do you see what may be wrong here?
I also tried
var allValues = _matrixTemplateValuesAdapter.GetAll().Select(v => new ValueAttribute
{
ValueName = v.ValueName,
AttributeId = v.AtnameId,
Hidden = v.Hidden
}).OrderBy(x=>x.AttributeId).ThenBy(y=>y.ValueName).ToList();
matrixTemplateViewModel.AllPossibleValues = allValues.Distinct().ToList();
but still got 192 values in both lists. I am supposed to get only 95 in the second list after selecting only distinct values.
Thanks in advance.
If it's not broken, fix it until it is.
My Blog