dispose method

@override Future<void> dispose()

Close the connection and clean up resources

Implementation

@override
Future<void> dispose() async {
  await _database.close();
}