Going from SQL database to CRUD (and getting there quickly)

I'm running VS2010, IIS7 w/ SQL Server 2008; programming a web application in C#.

So, I've got my database with all relationships carefully mapped; it has about 25 tables with 6 different sch开发者_JS百科emas (e.g. [Account], [Customer], [Product], [Category], [Vendor], etc).

What tools, methods, and architectures are commonly used to quickly go from database to CRUD?

Are you using ASP.NET MVC? It provides some scaffolding to create a CRUD interface. You still have to do some of the wiring, but it gets you more than halfway there.