ASP.NET MVC "CRUD" Database Sample

Question

I'm trying to get my head around ASP.NET MVC coming from a LAMP development environment. This isn't for anything production or mission-critical, just a guy trying to learn. I've looked at all I can on http://asp.net/mvc but a lot of those videos and tutorials seem to assume you know ASP.NET WebForms (which I don't) although I am quite handy with VB.NET.

My question boils down to, does anyone know of a small tutorial or even have one they made themselves whilst exploring ASP.NET MVC, that literally just shows you how to create, read, update and delete records in an MS SQL database?

Answer 1

This question is a little tricky.

Most Microsoft data access tutorials you will see on the net involve controls that will require you to drag datasource objects into an ASP.NET page, and I'm not sure (actually I seriously doubt) that those things work on ASP.NET MVC.

That being said, Rob Conery has a great tutorial series on setting up an ASP.NET MVC Storefront application, and this is a really great resource on putting up an ASP.NET MVC application, including but not limited to data access (he used LINQ to SQL).

Answer 2

IMHO getting started with asp.net mvc from LAMP background should not be so difficult, if you have some experience with java. if you need intro tutorials, beside scott hanselman's intro videos on www.asp.net/mvc, there are scott guthrie's introductory blog posts on weblogs.asp.net/scottgu, although they're bit outdated.

you can create basic mvc web app and then see common ui patterns from that example. you don't need to use (almost) any of asp.net server controls, you can use html helpers that are part of asp.net mvc, Good examples of data retrieval with LINQ2SQL are outlined also on scottgu's blog.

Answer 3

I just created a scaffolder that will generate this code for you in a nice testable way - my stab at "how it should be done" in a CRUD fashion. Have a look:

http://blog.wekeroad.com/blog/subsonic-mvc-scaffold-addin/

Answer 4

How about you try to use a scaffold generator just like Rails? It is available at http://www.twinforms.com/aspmvc-home.htm

then you can skip from step 1 to 3.

Hope this helps

Answer 5

Did you look at Evolutility CRUD framework?

http://www.evolutility.org