UnitOfWork not executing Insert statements when UnitOfWork.SaveChanges() method is called

Hi there,

I am currently experiencing an issue in Lightspeed where if a UnitOfWork is:

• Not Null during runtime
• Has the correct connection strings and connection properties
• Is declared in Singleton Scope
• Can execute select statements when UnitOfWork..Count() is executed
• Version used is Mindscape.Lightspeed ver 4.0.1235.20117

When I declare my UnitOfWork, it is using this code (via Ninject):

Bind<UnitOfWorkScopeBase<myUntOfWork>>()
.ToConstant(
    new MyPerRequestUnitOfWorkScope<myUntOfWork>(
    new LightSpeedContext<myUntOfWork>("default")
    {
        AutoTimestampMode           = AutoTimestampMode.Utc,
        CustomAutoTimestampStrategy = new myDateTimeAutoTimestampStrategy(),
        NamingStrategy              = new myNamingStrategy()
    }
    )
).InSingletonScope();

And is called when I do this:

...
var mynewObject = new MyObject {
    Name = myName
};
...
UnitOfWork.Add(myNewObject);
UnitOfWork.SaveChanges();

My confusion is, when the SaveChanges() method gets called, the insert statement that needs to get executed does not fire at all.

I have also checked my code and majority of the SaveChanges() are all implicit.

Was wondering if there are others who have encountered this issue, and if so, what would be the workaround?

Thank you!

Cheers, Ann

Hi Ann,

Can you check if myNewObject.UnitOfWork is the same object as UnitOfWork, and if you enumerate the UnitOfWork (which will return the list of entities in its identity map) that myNewObject is in that set.

Also just prior to the SaveChanges() call is myNewObject.EntityState set as EntityState.Default (it should have this value assigned automatically from instantiation).

Lastly are you implementing any hooks for events such as Entity.Saving?

Jeremy