Open discussion about choosing how to implement your data access tier

This is an open discussion about how you go about choosing a technology to implement your data access requirements. I would like to hear your comments on the choices that are available today and what factors drive your decisions.