You have to create two methods if you need both sync and async behaviour
- return
LiveData<List<Pin>>
for async - return
List<Pin>
for sync
interface PinDao : BaseDao<Pin> { @Query("SELECT * FROM pin WHERE is_active = 1 ORDER BY created DESC") fun fetchAll(): LiveData<List<Pin>> @Query("SELECT * FROM pin WHERE is_active = 1 ORDER BY created DESC") fun fetchAllSync(): List<Pin>}