UsingAGridBuilder

 

Now i have an error wen accessing an navigational property for ex. Product.Supplier

 

{"Index was outside the bounds of the array."}

 

I have this problem with all my apps i ported to vs 2010

 

Where does this come from ?

 

StackTrace :

 

   at IdeaBlade.EntityModel.EntityQueryBuilder.<>c__DisplayClass7.<BuildMultiEqualExpr>b__6(MemberExpression expr, Int32 i)
   at System.Linq.Enumerable.<SelectIterator>d__7`2.MoveNext()
   at IdeaBlade.EntityModel.EntityQueryBuilder.And(IEnumerable`1 expressions)
   at IdeaBlade.EntityModel.EntityQueryBuilder.BuildMultiEqualExpr(IEnumerable`1 propExpressions, Object[] values)
   at IdeaBlade.EntityModel.EntityQueryBuilder.<>c__DisplayClass4.<BuildLambdaKeyQuery>b__3(EntityKey key)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at IdeaBlade.EntityModel.EntityQueryBuilder.Or(IEnumerable`1 expressions)
   at IdeaBlade.EntityModel.EntityQueryBuilder.BuildLambdaKeyQuery(IEnumerable`1 keys)
   at IdeaBlade.EntityModel.EntityQueryBuilder.BuildQuery(IEnumerable`1 keys)
   at IdeaBlade.EntityModel.EntityKeyFinder.Execute()
   at IdeaBlade.EntityModel.EntityManager.ExecuteQueryCore(IEntityQuery query, Boolean isAsync)
   at IdeaBlade.EntityModel.EntityManager.FirstOrNullEntity(IEntityQuery query)
   at IdeaBlade.EntityModel.ScalarEntityReference`1.QueryForEntity(EntityReferenceStrategy strategy)
   at IdeaBlade.EntityModel.ScalarEntityReference`1.GetEntity(EntityReferenceStrategy strategy)
   at IdeaBlade.EntityModel.NavigationScalarEntityProperty`2.<.ctor>b__0(NavigationEntityPropertyGetInterceptorArgs`2 args)
   at IdeaBlade.Core.PropertyInterceptor`3.HandleAction(Action`1 action, TArgs args)
   at IdeaBlade.Core.PropertyInterceptor`3.<BuildTargetedCombinedAction>b__3(TArgs args)
   at IdeaBlade.Core.PropertyInterceptor`3.ExecuteActions(TArgs args)
   at IdeaBlade.Core.PropertyInterceptor`3.GetValue(TInstance instance, Object context)
   at IdeaBlade.EntityModel.NavigationScalarEntityProperty`2.GetValue(TInstance instance)
   at ServerModelNorthwindIB.Employee.get_Manager() in C:\Users\Public\Documents\DevForce 2010\Learning Resources\200WNF_GridBuilder\CodeCS\ServerModelNorthwindIB\ServerModelNorthwindIB.IB.Designer.cs:line 713

private BindableList<Employee> _employees = new BindableList<Employee>();

var query = _em.BasePersons
                .Include(Employee.PathFor(sa => sa.CommissionCode))
                .Include(Employee.PathFor(sa => sa.SalesInvoiceAgents))
                .Include(Employee.PathFor(sa => sa.Address))
                .Include(Employee.PathFor(sa => sa.Address.Country))  <-- the moment i include this it fails
                 .OfType<Employee>();

_employees.ReplaceRange(query.ToList());

 

I made sure every employee had an address and each address has a country assigned to it

 

Then I create my grid and bind the data

 

GridControl employeeGridControl;
 XtraGridBindingManager bindingManager;
_GridBuilder2.CreateGrid(out employeeGridControl, out bindingManager,  _employeeBS, typeof(Employee));

 

_GridBuilder2.AddColumn(bindingManager, Employee.PathFor(e => e.Name));
_GridBuilder2.AddColumn(bindingManager, Employee.PathFor(e => e.CommissionCode.AlfaCode));
_GridBuilder2.AddColumn(bindingManager, Employee.PathFor(e => e.NumberOfUnpaidInvoices));
_GridBuilder2.AddColumn(bindingManager, Employee.PathFor(e => e.Address.City));
_GridBuilder2.AddColumn(bindingManager, Employee.PathFor(e => e.Address.Country.NameNld));

 

I had the same problem before with other data and then I could resolve the problem by adding an include in the loaddata of the extra data needed

 

 

 

Now I only seem to have the problem when the entity is inherited.

 

Employee.Commissioncode.Procent

 

where Commissioncode is inherited from a Basecode (TPH).