Devart Forums

Hey
You still know: I use VB.NET 2008+your latest controls

I use a hierachial structure
On a from I put 2 BindingSources
BindingSourceMaster.DataSource = From Query in Master
BindingSourceDetail.DataSource = BindingSourceMaster.DataSource
BindingSourceDetail.DataMember = "Child"

When I now input one child, Submit Changes works, but if I add more than one Child, I get an LostConnection Error

By looking around & trying around, I found out, that the TransactionScope is the problem.
When I enter one master, related with one detail, it works. - When there are more than one detail, I got an lostConnection error. - When I delete the TransactionScope, then it works.
I sent you an example.

THX

Thank you for the report, we have reproduced the problem.
I will let you konow about the results of our investigation.

Would be nice

THX

Hi,
I have the same problem - since I use dotConnect for MySQL 5.40.39, my app hangs after SubmitChanges() inside TransactionScope, then I receive LostConnection Error. With 5.40.37 the same code works fine.

Please, let me know when the problem is solved.
Thanks.

We have made some changes in the SubmitChanges method.
If the problem persists, please try to wrap the SubmitChanges call into the TransactionScope
with RepeatableRead IsolationLevel, this should help.
Also please check that you have set the Auto Generated Values porperty to true for db-generated timestamp clolumn, if this is the case.
If something goes wrong, please let me know.