Can anyone recommend a tool for generating a simple C# ASP.Net Web Application for a SQL Server database?

I have a SQL Server 2005 database which holds a fairly basic schema.

I'm fine with accessing it through Management Studio, but I need to be able to provide read-write access to other internal staff so they can modify the contents of certain tables.

Can anyone recommend a tool (preferably free) that can look at a SQL Server database and generate a very basic C# ASP.Net Web Application with CRUD operations?

Everything is internal, so I don't care at this point about security or foreign key constraints. I just want a trivial interface without having to write all the plumbing and UI code myself.

Thanks!

From stackoverflow

• Take a look at Dynamic Data solutions from Microsoft ASP.net.

  Damovisa : Thanks for that - checked it out and it's exactly what I needed.

• What you're looking for is a scaffolding tool.

  See this question here: http://stackoverflow.com/questions/377538/quickest-way-to-get-scaffold-code-created-with-c-asp-net

  Damovisa : Ahh, thanks for that - I knew there'd be a word for it but I couldn't for the life of me think of it.

  IainMH : Very welcome sir.

• you can use ASP.Net Maker from HKVStore, it so simple (this is not a promotional)

• Perhaps still too much work in this case but ASP.NET MVC since the RC has a very quick way of doing CRUD interfaces, Guy Burstein did a great tutorial on this.

• Subsonic hands down has the simplest scaffold I've ever seen. Also comes with some ASP.Net user controls to make things really easy, point it at a table and you have crud sorted. e.g.

  <cc1:Scaffold ID="Scaffold1" runat="server"
  TableName="Products" />
  

  Check out more detail here http://subsonicproject.com/web-forms-controls/the-scaffold/