How to structure DB access in ASPNET MVC

Question

I am new to ASPNET MVC and I'm trying to understand which is the best way to work with it; I have a DB structure and I'm using EF4 that generates the DbModel.edmx.

I could invoke Entities directly from the Controller but I've read somewhere that it could be better to embed all DB calls to a Repository Class and consume it from Controllers. Is it the right way to work in ASPNET MVC3?

How can DataValidation be handled with this structure?

...better to embed all DB calls to a Repository Class and consume it from Controllers That's the best practice. — Alex R.
– Alex R., Commented Jul 26, 2011 at 8:09

Cyril Gandon · Accepted Answer · 2011-08-11 13:17:36Z

2

You may want to check NerdDinner which is done by high profile programmers and there is a step-by-step book as well. It also uses patterns such as Repository, ViewModel, DataValidation, etc.

Source code: http://nerddinner.codeplex.com/
Free book: http://www.wrox.com/WileyCDA/Section/id-321793.html

There is a branch for ASP.Net MVC 3 in the source code of NerdDinner. :)

edited Aug 11, 2011 at 13:17

Cyril Gandon

17.1k15 gold badges84 silver badges124 bronze badges

answered Jul 26, 2011 at 8:32

Soe Moe

3,4381 gold badge25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to structure DB access in ASPNET MVC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related