[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

[Clemens Ladisch]

Chris Prakoso wrote:
> My question is whether anybody had successfully implemented multiple
> rows Insert/Update.

This is possible in SQL:

INSERT INTO MyTable(ID, Value)
VALUES (1, 'hello'),
       (2, 'world');

UPDATE MyTable
SET Value = 'the same value'
WHERE ID IN (1, 2);

-- rather verbose; better use two simple UPDATEs:
UPDATE MyTable
SET Value = CASE ID
            WHEN 1 THEN 'new A'
            WHEN 2 THEN 'new B'
            END
WHERE ID IN (1, 2);


Regards,
Clemens