CData Upsert の設定

The action type is UPSERT and an UPSERT query is not specified. The key column [Id] is present and will be determined using an automatically generated UPSERT query.
SELECT COUNT(*) AS [count] FROM [Orders] WHERE [Id] = @Id; @Id='123'

The key column Id was not specified, INSERT will be executed.
The action type is UPSERT or an UPSERT query is specified. The key column is not present. Record will be INSERTED.

SELECT [Id] FROM [Orders] WHERE [OrderId] = @OrderId; @OrderId='12345'

SELECT [Id] FROM [Orders] WHERE [OrderId] = @OrderId; @OrderId=NULL

SELECT [Id] FROM [Orders] WHERE [OrderId] = @OrderId AND Status = 'Active'

<Items>
    <Orders table="`Orders`" action="insert">

<Items>
    <Orders table="`Orders`" action="update">