[Solved] How can you perform a transaction in NestJS Prisma to update two related records atomically? — Ans: Use prisma.$transaction() with an array of update calls | NestJS

NestJS - Database with Prisma

How can you perform a transaction in NestJS Prisma to update two related records atomically?

AWrap updates in a try-catch block only

BUse prisma.$transaction() with an array of update calls

CUse prisma.transaction.update() method

DCall update() twice sequentially without transaction

Step-by-Step Solution

Solution:

Step 1: Understand Prisma transactions
Prisma provides $transaction() to run multiple queries atomically.
Step 2: Confirm correct usage
Passing an array of update calls to $transaction() ensures atomicity.
Step 3: Evaluate incorrect options
Sequential updates without transaction risk partial updates; prisma.transaction.update() does not exist.
Final Answer:
Use prisma.$transaction() with an array of update calls -> Option B
Quick Check:
Atomic updates use prisma.$transaction() [OK]

Quick Trick: Use $transaction() to run multiple queries atomically [OK]

Common Mistakes:

Master "Database with Prisma" in NestJS

9 interactive learning modes - each teaches the same concept differently

More NestJS Quizzes

How can you perform a transaction in NestJS Prisma to update two related records atomically?