CODEWITHSUNDEEP
sql-serverasp.net-mvcdatabase
Another Dev on the List
Another Dev on the List

Reputation: 83

Best way to connect database for asp.net mvc

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

Upvotes: 3

Views: 5074

Answers (3)

kishan djn
kishan djn

Reputation: 1

There are different Ways to Connect to Databases for ASP.NET MVC web application using ENTITY FRAMEWORK :

  • Code-First
  • Db-First
  • Model-First

Code First approach lets you generate databases and datasets automatically . Use it if you are developing a large Web application and expecting changes of the Models in Future. So you can alter a database after making changes in the Code Accordingly.

Db-First lets you generate models automatically giving good control over Databases. Make sure there is a Database Admin working in the application.

Model-First Approach is not good option as developer would not be having control over both Model and Database.

Upvotes: 0

Chris
Chris

Reputation: 6315

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

Upvotes: 1

adini
adini

Reputation: 23

I use the the following for the data access:

  • Entity Framework (Code First)
  • Windsor Container for dependency injection set up with the repository pattern to make my controllers testable without having a database.

Blog post using EF Code First with MVC

Explanation Repository Pattern

Blog post about using MVC3 and Castle Windsor

Upvotes: 0

Related Questions