On Apr 24, 11:02 am, wind cloud <[email protected]> wrote: > Hi! I just wonder if it is my misunderstanding of Linq usage or if > it's really a lacking in DbLinq. > > I am using DbLinq 0.20.1 with MySql and run into a situation, say I > want to insert 1 row with 2 columns each referencing 2 parent tables.
Thank you for reporting the problem. It seems that the problem is closely related to issue 246 and I have added a test-case, inspired by your problem but using the Northwind schema, to the bug: http://code.google.com/p/dblinq2007/issues/detail?id=246 One workaround would, I guess, be to call SubmitChanges after calling InsertOnSubmit for the two child tables, table_a and table_b, and again after calling InsertOnSubmit for table_c. I realize that this is not a real solution, e.g. since it won't execute all inserts in the same transaction. -- Anders -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
