Also, is there an Object first design paradim that you can do. I understand why all of these demos reverse engineer a db... but, can I create an object model first and then have in create my schema for me?
There is an open source project you can check out called
NBusiness that focuses on generating business objects that you design. It is primarily concerned with an object first design paradigm. Well actually it's more like an Entity first than object first. You design your entities then it generates the objects
and the database / stored procedures.
Of course you don't have to use the generated sql you can use it with existing databases by creating the necessary stored procedures for working with the existing database. It's also completely template driven and therefor the generated code is completely customizable
and integrated into visual studio.