Where does my CRUD LINQ Code Go? ASP.NET MVC

Question

I am currently using the ASP.NET MVC framework on a project (pretty much my first time)

I am using Linq2SQL as my data model..

Where should i have this kind of code:

var entries = from e in db.sometable select e;

I currently have this kinda code in the controller and pass the data i get into the view..

is this ok?

if not how do i entend my linq2sql datamodel to include this kindof code?

Thanks

Daniel

Answer 1

It's common to use the Repository pattern for MVC. Typically, you define an interface, for instance, IProducts, and then, you implement this interface, calling you linq2sql code. Your controller will accept this interface as a parameter for the constructor, so that it depends on this interface, and not on a concrete class. Using a dependency injector, such as Ninject, will allow you to supply a concrete interface implementation to the constructor. This enables Unit Testing on you web app, and also adds flexibility.

There's a really nice book, Pro ASP.NET MVC 2 Framework, that explains all that. I'm currently reading it, and I just love it.