Csla and [Transactional(TransactionalTypes.TransactionScope)]

[Chicagoan2016]

We have a Csla 4.XX project and we thought of using [Transactional(TransactionalTypes.TransactionScope)] for updates and inserts.
But when FieldManager.UpdateChildren(this); is called we are getting
'INSERT statement conflicted with FOREIGN key constraint' error in child object data access layer.

I debugged the code and the primarykey from parent table ( also a property in root object ) is passed correctly to the child object's DAL.
We are using stored procs and ADO.NET.

Kind Regards

[rockfordlhotka]

And your code works without the transactional wrapper?

[Chicagoan2016]

@rockfordlhotka yes, it works without the transactional wrapper.

[rockfordlhotka]

That's strange, and I have no idea why this would be happening. Something about being in a transaction must be changing how the database is handling the key relationship or enforcement.