Retrieving Data from the Database

Listing 3.

SqlCeCommand cmd = new SqlCeCommand();
cmd.Connection = _connection;
cmd.CommandText = "SELECT ID, [Title], Author, ISBN, Rating FROM Books";
SqlCeResultSet resultSet = cmd.ExecuteResultSet(ResultSetOptions.Scrollable | ResultSetOptions.Updatable);