How to Assert Database State?

Today, we'll discuss a question that relates to my Unit Testing book: how to assert the state of the database? Before we dive into the question itself, I need to make a preface. Otherwise, it wouldn't be clear what the question is about.