Sign in to confirm you’re not a bot
This helps protect our community. Learn more

.NET Data Community Standup - New EF Core 7.0 APIs (Bulk Update)

dotnet
325K subscribers
<__slot-el>
<__slot-el>
19K views Streamed 2 years ago
EF Core 7.0 introduces the ExecuteUpdate and ExecuteDelete APIs, which allow you to easily use LINQ to express a database update or delete operation. These APIs can be far more efficient for applying changes to multiple rows based on a condition, e.g. “delete rows which have InActive set to true” (AKA bulk update scenarios). But in some scenarios, they also allow you to express changes over a single row in a much more succinct and simple way, simplifying your code. ExecuteUpdate and ExecuteDelete completely bypass EF’s change tracking and execute immediately, as opposed to when SaveChanges is called. Tune in to learn more and to explore the new possibilities that these new APIs bring! Featuring: Arthur Vickers (@ajcvickers), Shay Rojansky (@shayrojansky) ...more
...more

Rc2 of Ef7

4:17

Rc2 Is Feature Complete

4:24

New Documentation

5:34

Community Content

5:56

Execute Update and Execute Delete

8:24

Save Changes

15:33

The Memory Diagnoser

39:29

When To Use Safe Changes

42:44

Query Pipeline

43:19

Optimizing the Query Pipeline

43:38

Deadlock Avoidance

48:13

When To Use save Changes and When Not

51:40

Transaction

54:15

Postgres

1:00:37

Can You Change Several Fields at Once

1:01:44

Avoid over Fetching

1:08:01

Will ef Core Make Use of Green Threads

1:19:58

Is It Possible To Get the Query Text from an Ef Query

1:23:29
.NET Data Community Standup - New EF Core 7.0 APIs (Bulk Update)
EF Core 7.0 introduces the ExecuteUpdate and ExecuteDelete APIs, which allow you to easily use LINQ to express a database update or delete operation. These APIs can be far more efficient for applying changes to multiple rows based on a condition, e.g. “delete rows which have InActive set to true” (AKA bulk update scenarios). But in some scenarios, they also allow you to express changes over a single row in a much more succinct and simple way, simplifying your code. ExecuteUpdate and ExecuteDelete completely bypass EF’s change tracking and execute immediately, as opposed to when SaveChanges is called. Tune in to learn more and to explore the new possibilities that these new APIs bring! Featuring: Arthur Vickers (@ajcvickers), Shay Rojansky (@shayrojansky)

Follow along using the transcript.

dotnet

325K subscribers