Linq2db: More freedom on merge actions configuration

Created on 5 Feb 2016  路  4Comments  路  Source: linq2db/linq2db

Currently merge supports
WHEN MATCHED THEN UPDATE
WHEN NOT MATCHED BY TARGET THEN INSERT
WHEN NOT MATCHED BY SOURCE THEN DELETE

It will be more usefull, if type of operation could be specified by user.
E.g. in combination with #336 I would like to perform delete of matched records (by primary key and additional field, added as extra predicate).
Another example:
delete by match on composite primary key (no custom predicates required)

linq feature

Most helpful comment

Not right now, but yes, I have it in plans for summer (design proposal for merge API and then implementation).

All 4 comments

What about PR? :)

Not right now, but yes, I have it in plans for summer (design proposal for merge API and then implementation).

Guys, I've started my work on this task and created some documentation. Feel free to add your comments/ideas:
https://github.com/MaceWindu/linq2db/wiki/MERGE-INTO-Command

That's really cool.
I do have nothing to add :)
Awaiting for PR's )))

Was this page helpful?
0 / 5 - 0 ratings

Related issues

SergeyA picture SergeyA  路  4Comments

pebezo picture pebezo  路  4Comments

Scratch-net picture Scratch-net  路  6Comments

CrazyAlex25 picture CrazyAlex25  路  5Comments

jges42 picture jges42  路  5Comments