How to Insert Multiple rows in a single db transaction in Android Room Database? | Android | Room DB

 

To insert multiple rows into a Room database in Android, you can follow these steps:

1. Set up Room Database:

First, make sure you have set up your Room database correctly in your Android project. Define your Entity class, create a Database class that extends RoomDatabase, and set up your DAO (Data Access Object) interface.

2. Create Entity Class:

Define an Entity class that represents the data you want to insert into the database. For example:

1 2 3 4 5 6 7 8 9

@Entity(tableName = "my_table") public class MyEntity { @PrimaryKey(autoGenerate = true) public int id; public String name; public int age; // Add other fields and getters/setters as needed }

Create DAO:

Create a DAO interface with a method to insert multiple rows. For example:

1 2 3 4 5

@Dao public interface MyEntityDao { @Insert void insertAll(List<MyEntity> entities); }

Initialise Database and DAO:

In your application code, create an instance of your Room database and get an instance of the DAO:

1 2	MyDatabase database = Room.databaseBuilder(context, MyDatabase.class, "my_database").build(); MyEntityDao dao = database.myEntityDao();

Insert Multiple Rows:

You can insert multiple rows into the database by calling the insertAll method on the DAO with a list of MyEntity objects. For example:

1 2 3 4 5 6

List<MyEntity> entities = new ArrayList<>(); entities.add(new MyEntity("John", 25)); entities.add(new MyEntity("Alice", 30)); entities.add(new MyEntity("Bob", 28)); dao.insertAll(entities);

Make sure to wrap the database operations in a background thread or use Kotlin coroutines or RxJava to perform them asynchronously to avoid blocking the main UI thread.

That's it! You have inserted multiple rows into a Room database in Android. Remember to handle database transactions and error handling as needed for your application.