materialisation error - association on abstract derived class

Hi,

I have the following model:

EntityA

EntityX : EntityY : EntityZ

there is an association (1-1) from EntityY to EntityA.

When I run a query on EntityY, I get the following error:

Unable to materialize field [EntityAId] on type [EntityY]: field is type 'System.Guid' but database returned type 'System.String'. Check your table has an Id column and that your mappings are correct. See inner exception for details.

System.InvalidCastException: Specified cast is not valid.

at Mindscape.LightSpeed.Model.FieldModel.Materialize(IDataProviderAdapter, Object, Object[], ref Int32)
at Mindscape.LightSpeed.Mapping.EntityLoader.(UnitOfWorkBase , String , Entity , Object[] ,  )
at Mindscape.LightSpeed.Mapping.EntityLoader.LoadEntityFromReader(AliasedTypeModel, Object, Boolean)
at ..(AliasedTypeModel , QueryExpression , Order , Group , String , Boolean , Boolean )
at ..(LightSpeedContext , List`1 , QueryExpression , Order , Group , String , Boolean , Boolean )
at ..(AliasedTypeModel , IList , String , Boolean )
at ..(TypeModel , Query , IList )
at ..(Query , TypeModel , IList )
at ..(Query , IList )
at Mindscape.LightSpeed.UnitOfWork.Find(Query query, IList results)
at Mindscape.LightSpeed.UnitOfWorkBase.Find(Query query)
at Mindscape.LightSpeed.Linq.Plan.SingleQueryPlan.ExecuteImmediate(IUnitOfWork unitOfWork, Type returnType)
at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression)
at Mindscape.LightSpeed.Linq.LinqQuery`1.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList(IEnumerable`1 source)

I've seen this before with associations on entities in an inheritance tree but I think you mostly fixed these in the last couple of months.  The sql runs fine - all the columns are correctly mapped to column headings but when I last ran this sort of error through to the LS source code I found it was transposing fields - hence the type cast exception.  For some reason it's reading columns out of the datareader that aren't relevant for this entity.

Query is the following:

Snippet

                    var entities = UnitOfWork.EntityZ
                        .Where(j => j.Status == JobStatus.Queued || j.Status == JobStatus.Processing && j.ProcessingMachineName == "blah" && j.UpdatedOn < DateTime.UtcNow.AddMinutes(-15));
 
                    result = entities
                        .OrderByDescending(j => j.Priority)
                        .Take(3).ToList();

I'm using the nightly build from last night.

Happy to pass more details...

cheers

justin

Is it possible to get a small repro for this?

Thanks!

Jeremy

repro is with JD - through msn messenger.

email was too big.

btw, i'm using mspec as test runner.  just holler if you need pointer to test adapters.  easiest and prettiest is resharper 5.1 plugin for mspec 0.3. :)

actual failing test is "Snippet

when_querying_jobs2