Scenario: I need to insert Data into Multiple SQL Tables with Keys…
I am using WCF-SQL Adapter i need insert the muliple records received from source in to SQL in a single transaction.
How is the foreign key relation handled with WCF-SQL.
I have created the Composite Operation schema. Can i achieve all this in single Map or please give suggestions ASAP.
Hi,Using WCF-SQL Adapter inserting multiple records in single transaction, see discussion in this
If your target database is SQL 2008 I would use the multiple tables passed into a single stored proc as discussed in this blog entry: