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

tags:

views:

68

answers:

1

+1 Q:

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 schemas (e.g. [Account], [Customer], [Product], [Category], [Vendor], etc).

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

A:

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.

RedFilter 2010-09-30 17:05:52

Sure, why not? With this project I am open to doing things in ways I haven't done before. I'm watching Scott Hanselman's video on it now.

David Murdoch 2010-09-30 17:55:43

Hrm, are you talking about creating a new "Controller" which allows you to select if you want it to create the the CRUD methods?

David Murdoch 2010-09-30 19:45:51

Yes, that is it. When you create a controller, you can tell it to *Add action methods for Create, Update, Delete, and Details scenarios*. Once that is done, you can right-click in each action to create its view, telling it what Model object to use as the data type, and which CRUD action that view is for. At that point, most of the HTML coding is done for you, and some of the controller code as well.

RedFilter 2010-09-30 20:09:04

Eh. I'm scrapping the MCV route for now. I just don't have time to learn it at the moment.

David Murdoch 2010-10-01 22:39:01

You might be interested in this: http://www.screencast.com/users/RPawson/folders/MVC/media/1624e6e1-0586-4f7c-97e0-ad56868fe24e

RedFilter 2010-10-08 17:22:07

ansaurus

tags:

views:

answers:

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

related questions