Best way to connect database for asp.net mvc

Question

I want to know different options available when we are connecting asp.net mvc application to database.

What are pros and cons of each method and what is best method to choose.

In Traditional asp.net web form application i am using DAL approach, which seems to be very useful to me so far even while dealing in shared hosting environment. I want solution which i can apply in shared hosting environment.

Thank you everyone :)

Answer 1

On the website Mikesdotnetting.com, there is an article titled ASP.NET MVC is not all about Linq to SQL. Basically what the article talks about is taking a standard ASP.NET web forms n-layered application and moving it into the world of MVC. The only things that are changed are the actual web forms into views. He leaves much of the application as is, the data access layer, the entity objects, the business rules, etc. From reading the article and seeing what you're asking, I think you can easily use what you know (your DAL) and combine that with MVC.

Good luck on your project, and hope this helps some.

Original Web form based application article:

Building Layered Web Applications with Microsoft ASP.NET 2.0