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!
-
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/
0 comments:
Post a Comment