Hi guys
Recently i had a discussion with someone about the proper way to develop a database driven (SQL Server) application.
In his opinion i should design also the database inside the application.
At this moment i design the database in SQL Managaement tool and use a custom class to connect to this database (or the one of the client) in my application.
I could do this also in VS but i'll lose immediatly the flexibility of this approach.
What are the cons and pro's of using the VS database designer inside my IDE?

Thanxxx