Blogged : Yet another ORM - Code snippet 1 The old-school mapping query results to POCO.

CategoryDAO.cs

using (IDataReader reader = command.ExecuteReader())
{
    List<Category> cats = new List<Category>();
    while (reader.Read())
    {
        int idOrdinal = reader.GetOrdinal("cid");
        int nameOrdinal = reader.GetOrdinal("name");

        if (!reader.IsDBNull(idOrdinal))
        {
            Category category = new Category
            {
                Id = reader.GetInt32(idOrdinal),
                Name = reader.GetString(nameOrdinal)
            };
            cats.Add(category);
        }
    }
    return cats;
}