fun getUsers(): List<Users> { val db = this.writableDatabase val list = ArrayList<Users>() val cusrsor: Cursor cusrsor = db.rawQuery("SELECT * FROM USER", null) if (cusrsor != null) { if (cusrsor.count > 0) { cusrsor.moveToFirst() do { val userID = cusrsor.getInt(cusrsor.getColumnIndex("userID")) val userName = cusrsor.getString(cusrsor.getColumnIndex("userName")) val userAge = cusrsor.getInt(cusrsor.getColumnIndex("userAge")) val user = Users(userID, userName, userAge) list.add(user) } while (cusrsor.moveToNext()) } } return list } @Dedy Kurniawan Please try like this. Replace rawquery, object and dto with yours.