Have you used transactions when working with ORM to ensure data integrity?

Yes, when working with ORM (for example, Sequelize in Node.js), using transactions is a standard practice to ensure data integrity. Transactions allow grouping multiple database operations into a single atomic unit: either all operations succeed, or in case of an error, all changes are rolled back.

Example of using a transaction with Sequelize:

const { sequelize } = require('./models');

async function updateData() {
  const t = await sequelize.transaction();
  try {
    await ModelA.create({ /* data */ }, { transaction: t });
    await ModelB.update({ /* data */ }, { where: { id: 1 }, transaction: t });
    await t.commit();
  } catch (error) {
    await t.rollback();
    throw error;
  }
}

This approach guarantees that data remains in a consistent state even if errors occur during operations.