Insert new related record

Feb 17, 2011 at 7:24 AM

Hi

I want to use LINQ to VFP in Silverlight Business Application with WCFRia Service.

I have a look of example and try to add new record in order and orderdetail table with one submit.

When insert new orderdetail has 0 for orderid.

I want to ask whether it is possible to add a new record for both parent and child and to fill correct values in foreign keys?
My second question is whether the intercept update conflicts?

Coordinator
Feb 18, 2011 at 12:28 AM

I want to ask whether it is possible to add a new record for both parent and child and to fill correct values in foreign keys?

It looks like IQToolkit, which LINQ to VFP is merely a provider for, doesn't handle updating related objects as you would expect.  I'll try to see if this is something that I can fix in the LINQ to VFP source code. 


My second question is whether the intercept update conflicts?

I'm not sure what you are asking...?  I'm guessing this is a WCF RIA Service issue which I'm not that familiar with... but if you explain the issue, I can research it for you.