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

Question

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!

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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.

Answer 5

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/