Time for action – querying a dynamic index

We will query the World database and retrieve all Countries for which the Area field is greater than or equal to 1000000. Before creating this query, you will import the Countries.csv file into the World database. After that, you will visualize how RavenDB will perform this task and you will look at the RavenDB logs in the prompt window.

1. In Management Studio, import the Countries.csv file into the World database.

2. Create a new Visual Studio project, name it RavenDB_Ch04.

3. Add a new class, name it City and complete it as follows:

   

4. Add a new class named Country and make it look as follows:

   

5. Add the RavenDB DocumentStore initialization to the Main() method using the following code snippet:

   

   Note

   The World database has been created in Chapter 2, RavenDB Management Studio.

6. Add this query to the Main() method in the Program class using the following code snippet:

   

7. Save all the files and build the solution.

8. Open the RavenDB installation folder and launch RavenDB server...