ERWin is one tool that can be used for modeling, reverse enigineer schema, forward engineer schema (make change scripts). It doesn't integrate into VS (that I'm aware of). It has it's own quirks in the interface and is kinda pricey, but once you get past that I've been happy with it.

HTH,

Rob