Listing 2

// Sample showing use of serach object
#include <iostream>
#include <dti/database.h>
using namespace dti::db;

struct Person
{
    std::string name_;
    int         age_;
    BEGIN_DB_BINDING  
        DB_BIND_COLUMN_NAME(name_, "Name")
        DB_BIND_COLUMN_NAME(age_,  "Age")
    END_DB_BINDING
};
int main()
{
   try
   {
      database db("MyLife", "sa", "");
      search<Person> s(db, "Select Name, Age from Persons");
      search<Person> end_s;
      for (;s != end_s; ++s)
        std::cout << s->name_ << " " << s->age_ << std::endl;   
   }
   catch(db_error & e)
   {
      std::cerr << e.what() << std::endl;
   }
}