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 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?

+3  A: 

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).

Jon Limjap

IMHO getting started with 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, there are scott guthrie's introductory blog posts on, 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 server controls, you can use html helpers that are part of mvc, Good examples of data retrieval with LINQ2SQL are outlined also on scottgu's blog.

Dragan Panjkov
+5  A: 

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:

Rob Conery
+1  A: 

How about you try to use a scaffold generator just like Rails? It is available at

then you can skip from step 1 to 3.

Hope this helps

+1  A: 

Did you look at Evolutility CRUD framework?