New Bug with SubmitChanges

New Bug with SubmitChanges

Postby Zero-G. » Sun 04 Oct 2009 13:02

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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Mon 05 Oct 2009 14:19

Thank you for the report, we have reproduced the problem.
I will let you konow about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Zero-G. » Mon 05 Oct 2009 14:48

Would be nice

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby daleksandrowicz » Tue 06 Oct 2009 14:26

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.
daleksandrowicz
 
Posts: 1
Joined: Fri 13 Mar 2009 13:03
Location: Poland

Postby AndreyR » Wed 25 Nov 2009 16:34

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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)