NestJS - Database with TypeORMWhy does NestJS recommend using the transaction method on DataSource instead of manually managing query runners for transactions?ADataSource.transaction disables all logging for performanceBManual query runners are deprecated and unsupportedCIt automatically handles connection release and rollback on errorsDManual query runners cannot execute multiple queriesCheck Answer
Step-by-Step SolutionSolution:Step 1: Understand DataSource.transaction benefitsIt abstracts transaction management, ensuring connections are released and rollbacks happen on errors automatically.Step 2: Evaluate other optionsManual query runners are supported but require more code. The other options are incorrect.Final Answer:It automatically handles connection release and rollback on errors -> Option CQuick Check:DataSource.transaction simplifies transaction management [OK]Quick Trick: Use DataSource.transaction for safe, automatic transaction handling [OK]Common Mistakes:Believing manual query runners are deprecatedThinking DataSource.transaction disables loggingAssuming manual query runners can't run multiple queries
Master "Database with TypeORM" in NestJS9 interactive learning modes - each teaches the same concept differentlyLearnWhyDeepVisualTryChallengeProjectRecallPerf
More NestJS Quizzes Authentication - Protected routes with guards - Quiz 14medium Database with Prisma - Why Prisma offers type-safe database access - Quiz 4medium Database with Prisma - CRUD with Prisma - Quiz 12easy Database with TypeORM - Migrations - Quiz 2easy Database with TypeORM - Relations (OneToMany, ManyToOne, ManyToMany) - Quiz 2easy Guards - Guard binding levels - Quiz 11easy Interceptors - Interceptor interface - Quiz 13medium Interceptors - Response transformation - Quiz 11easy Interceptors - Timeout interceptor - Quiz 1easy Middleware - Third-party middleware (cors, helmet) - Quiz 1easy