Hi Markham,
In short, SelfServicing is about the paradigm that object persistence is something about the objects being persisted, so an entity object should know how to persist itself. SelfServicing's code is generated for one database type (e.g. Sqlserver / Oracle.
So Adapter TemplateSet is recommended when the project targets multiple database types or would be able to do that in the future.