Upgrading from LS 3.0 to LS 4.0 issues

Hi,

I'm upgrading our application from LS 3.0 to LS 4.0 and encountering an exception when I create the first Unit of Work.

 Mindscape.LightSpeed.LightSpeedException Unable to materialize field [Id] on type 
 [####.Lightspeed.Sentinel.SentinelStat]. 

 Check your table has an Id column and that your mappings are correct. See inner exception for details.  
 Void Throw(System.Exception, System.String, System.Object[]) Unable to materialize field [Id] on type 
 [####.Lightspeed.Sentinel.SentinelStat]. Check your table has an Id 
 column and that your mappings are correct. See inner exception for details.  Void Throw(System.Exception, 
 System.String, System.Object[])

The table does have an Id field, however it is named StatId, not Id. I have searched the forums (which is a lot easier with the new update!) and couldn't find a solutions that worked. Closest thread was: http://www.mindscapehq.com/forums/thread/3215

Attached is a screen grab of the Properties Window in VS2010. The LightspeedContext is using IdentityColumn for it's IdentityMethod.

I have also opened the Lightspeed Designer, moved something, and re-saved to see if there was difference in the generated code (there was none).

Generated code for SentinelStat is also attached (as SentinelStat_LSGenerated.cs).

Can you explain the error / suggest any solutions?

What is the inner exception?

Sorry, I thought the inner exception was in the original post. Below are the both exception messages and call stacks.

Exception 1:

Unable to materialize field [Id] on type [NinjaTheory.NinjaPerformanceMonitor.Lightspeed.Sentinel.SentinelStat]. Check your table has an Id column and that your mappings are correct. See inner exception for details.

at Mindscape.LightSpeed.LightSpeedException.Throw(Exception innerException, String format, Object[] values) in \Src\Framework\LightSpeedException.cs:line 62
   at Mindscape.LightSpeed.Model.FieldModel.Materialize(IDataProviderAdapter dataProviderAdapter, Object target, Object[] values, Int32& index) in \Src\Framework\Model\FieldModel.cs:line 305
   at Mindscape.LightSpeed.Mapping.EntityLoader.LoadEntityByFieldOrder(UnitOfWorkBase unitOfWork, String aggregateName, Entity entity, Object[] values, IColumnPermutation permutation, Boolean isDirect) in \Src\Framework\Mapping\EntityLoader.cs:line 180
   at Mindscape.LightSpeed.Mapping.EntityLoader.LoadEntityFromReader(AliasedTypeModel typeModel, Object id, Boolean allowUnscopedIdentifiers, Boolean isDirect) in \Src\Framework\Mapping\EntityLoader.cs:line 95
   at Mindscape.LightSpeed.Mapping.ObjectLoader.VisitTypeModel(AliasedTypeModel typeModel, QueryExpression queryExpression, Order order, Group group, String aggregateName, Boolean includeDeleted, Boolean identifiersOnly) in \Src\Framework\Mapping\ObjectLoader.cs:line 225
   at Mindscape.LightSpeed.Mapping.QueryTraversal.Visit(LightSpeedContext context, List`1 typeModels, QueryExpression queryExpression, Order order, Group group, String aggregateName, Boolean includeDeleted, Boolean identifiersOnly) in \Src\Framework\Mapping\QueryTraversal.cs:line 35
   at Mindscape.LightSpeed.Mapping.ObjectLoader.LoadFromQueryStrategy(AliasedTypeModel typeModel, IList results, String aggregateName, Boolean identifiersOnly) in \Src\Framework\Mapping\ObjectLoader.cs:line 159
   at Mindscape.LightSpeed.Mapping.ObjectLoader.LoadInternal(TypeModel typeModel, Query query, IList results) in \Src\Framework\Mapping\ObjectLoader.cs:line 72
   at Mindscape.LightSpeed.Mapping.ObjectLoader.Load(UnitOfWorkBase unitOfWork, TypeModel typeModel, Query query, IList results) in \Src\Framework\Mapping\ObjectLoader.cs:line 19
   at Mindscape.LightSpeed.QueryingEngine.FindInternal(Query query, TypeModel typeModel, IList results) in \Src\Framework\QueryingEngine.cs:line 395
   at Mindscape.LightSpeed.QueryingEngine.Find(Query query, IList results) in \Src\Framework\QueryingEngine.cs:line 135
   at Mindscape.LightSpeed.UnitOfWork.Find(Query query, IList results) in \Src\Framework\UnitOfWork.cs:line 281
   at Mindscape.LightSpeed.UnitOfWorkBase.Find(Query query) in \Src\Framework\UnitOfWorkBase.cs:line 431
   at Mindscape.LightSpeed.Linq.Plan.SingleQueryPlan.ExecuteImmediate(IUnitOfWork unitOfWork, Type returnType) in \Src\Framework.Linq\Plan\SingleQueryPlan.cs:line 54
   at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression) in \Src\Framework.Linq\QueryProvider.cs:line 92
   at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) in \Src\Framework.Linq\QueryProvider.cs:line 62
   at Mindscape.LightSpeed.Linq.LinqQuery`1.GetEnumerator() in \Src\Framework.Linq\Query.cs:line 57

Exception 2:

Operation could destabilize the runtime.

   at setfast__id(Object , Int32 )
   at Mindscape.LightSpeed.Model.PrimitiveIdFieldModel.<>c__DisplayClassc0.<CreateValueSetter>b__be(IDataProviderAdapter dataProviderAdapter, Object target, Object[] values, Int32 index) in \Src\Framework\Model\PrimitiveIdFieldModel.cs:line 57
   at Mindscape.LightSpeed.Model.FieldModel.Materialize(IDataProviderAdapter dataProviderAdapter, Object target, Object[] values, Int32& index) in \Src\Framework\Model\FieldModel.cs:line 294   

There are a couple of possibilities here.

The first is that this is an ASP.NET medium trust issue, but if the same code worked under LightSpeed 3.x, that seems unlikely. (I also think you would get a different exception in this case.) However, if you have changed anything other than the LightSpeed version that could have resulted in going into medium trust, then this could be the issue.

The second is that this is an internal error possibly related to the data type or value being returned from the database (though this would normally result in an InvalidCastException). Unfortunately we have not been able to reproduce the error here, so we haven't been able to investigate this. Does it happen on all SentinelStat records or only specific ones? How is the StatID column declared in the database? What database provider are you using? Is it possible for you to create a minimal repro (console or NUnit test project, and minimal database) so that we can try to progress this for you?

I doubt that is the first possibility as it is a desktop application running under full-trust and nothing else has changed other than the LightSpeed version (if I change to point to the LS 3.0 assemblies, it works again).

More information below:

1. The exception is thrown the first time that we try to access the uow.SentinelStats in a foreach (IQueryable<SentinelStat> SentinelStats).

   using (var uow = Context.CreateUnitOfWork())
   {
       foreach (var stat in uow.SentinelStats)
       {
          // ...
       }
   }
   

2. The StatID column is an int, is the primary key for the table, and auto-increment (Identity Specification).

3. Using the MSSQL database provider.

If the above does not help narrow this issue down I could create a minimal repro.

Sorry, nothing jumps out from that as a possible cause (though I agree we can rule out the medium trust theory). I think we're going to need the repro. Thanks!

OK. I will try to create a minimal repro of this issue tomorrow. Are you able to create a test MSSQL database/table on your end? I will provide the CREATE scripts.

Yes, SQL Server is fine. Thanks!

I have resolved the error that I was having by doing a complete uninstall of LS 3.0 and then installing the latest LS 4.0 nightly build (21 November).

It is possible that I was using the LS 3.0 custom tool with LS 4.0 assembly.