How we work:
At Headspring Systems, we approach greenfield projects with a Domain-Driven Design mindset of creating objects and not database schemas. We do use MS SQL 2005 and interact with the MS SQL by way of NHibernate, but each table created corresponds to an object and each column therein to one of the object's attributes. This approach empowers our own developers to think in terms of objects instead of trying to translate client concepts to a different and arbitrary set of business rules (which would add the extra layer of obtuse complexity that causes the demise of many projects undertaken outside of DDD).