C#•2y ago

✅ is there any way to delete items from the database and return the deleted list in one request?

is there any way to delete items from the database and return the deleted list in one request?

I can do something like this:

DbContext.T.Where(entity => ..).ExecuteDelete()

DbContext.T.Where(entity => ..).ExecuteDelete()

, but my business logic assumes that I will return items that were deleted

I can do this:

var deleted = DbContext.T.Where(entity => ..)

var deleted = DbContext.T.Where(entity => ..)

DbContext.RemoveRange(deleted)

DbContext.RemoveRange(deleted)

but these are already two requests to database

douchebag•7/16/24, 1:32 PM

i dont think so

douchebag•7/16/24, 2:04 PM

base on your code you have 2 queries

Anton•7/16/24, 2:23 PM

I don't think you can do that with EFCore

Anton•7/16/24, 2:23 PM

You can with linq2db

Anton•7/16/24, 2:24 PM

for sure

Anton•7/16/24, 2:25 PM

Anton•7/16/24, 2:28 PM

btw only do two queries if you're in a transaction

SWEETPONYOP•7/16/24, 10:59 PM

I think row sql is the best option here -

SWEETPONYOP•7/16/24, 10:59 PM

with

DbContext.T.Where(entity => ..).ExecuteDelete()

DbContext.T.Where(entity => ..).ExecuteDelete()

I can only delete but I need to return deleted items too

Henkypenky•7/17/24, 3:18 AM

it's important to understand what happens behind the scenes. If you retrieve the range ef core tracks them, so when you proceed to delete them efcore already knows where they are and what state they are in, so the deletion is already optmized. It's not a question of using less commands but a question of understanding why using 2 is fine

SSWEETPONY I think row sql is the best option here - `delete from x where x.a = 1 returnin...

Henkypenky•7/17/24, 3:24 AM

might as well not use EFCore...

SSWEETPONY I think row sql is the best option here - `delete from x where x.a = 1 returnin...

Anton•7/17/24, 4:10 AM

A good option is generating a query with info from and running a raw query

SWEETPONYOP•7/18/24, 2:29 PM

thanks for helping