Great tool to use is subsonic it will take a database schema for all your tables ,data and stored procedures
SubSonic: All Your Database Are Belong To Us SubSonic All Your Database Are Belong To Us, Data Access, .NET, ASP.NET ... SubSonic is a toolset that helps a website build itself . Get your project from idea to prototype..
http://www.subsonicproject.com