Welcome aboard and thank you for making the first post.
1). If you try the "crud" command with yiic, you will find that the generated code already uses CPagination. Please follow the description in "Creating First Application" in the Guide to see how to use yiic crud command.
2). Yii comes with DAO and Active Record as Prado does. Both are completely rewritten and made cleaner and more efficient. SQLMap is not in Yii due to the fact that it is overly complicated. In fact, we are thinking about a way to unify Active Record and SQLMap, which may be realized in v1.1 release. The code snippet you gave is about using DAO, which is available in both Yii and PRADO.
3). As a matter of fact, AR does not really require relationship definition in DBMS except for MANY_MANY relationship. Currently, AR needs DBMS relationship mainly for sanity checking purpose, i.e., if you do not declare relation in AR class correctly, it will tell you where the error is.
Thanks, the code that was generated from the example application answered a lot of my questions - although there seemed to have been an issue about the login page not being found (http://localhost/testdrive/index.php?r=user/login) - But I was able to work through by commenting access control out in the controller …
I think I see the problem, The UserController generated by the web application shell gets replaced when you generate the CRUD for the "user" table because it also generates a UserController … (It does warn you first before overwriting it.)