CODEWITHSUNDEEP
asp.net-mvc
Cameron
Cameron

Reputation: 28853

ASP.NET MVC Database Views

Quick question about database views. Am I right in assuming that I can create a database of view of various tables and connect them how I want etc and then when I do queries, add, edit delete etc then MVC will figure it all out for me without needing to do any complex SQL in the controller or repository?

Odd question but just wanted to make sure my assumption was valid. Cheers

Upvotes: 1

Views: 3182

Answers (3)

Jason Yost
Jason Yost

Reputation: 4947

A database view is read-only so you will not be able to perform write operations on the view. You can however create a model from a view and display your data as defined from the view. If you are using an ORM solution such as ADO.NET Entities you can instantiate an object and add the child objects to it and be able to save the final result in a single transaction as well.

Upvotes: 0

JTew
JTew

Reputation: 3189

What you are looking for is Scaffolding. In .net MVC I can't think of any tools which do this for you directly against the database. They all require either as Russ said an ORM i.e. Linq To SQL or Entity Framework (EF).

http://msdn.microsoft.com/en-us/library/cc488540.aspx

The closest you could get would be to use Database First model generation and then put the necessary MVC templates/views/code on top.

Upvotes: 1

Russ Cam
Russ Cam

Reputation: 125538

Unfortunately, MVC will not figure it all out for you, you'll still need to write the SQL code (or use an ORM framework) to communicate with the database.

What MVC gives you with it's architecture is a clear separation of responsibilities:

  • Views are responsible for displaying data and should be as simple as possible (i.e. little to no logic in them)

  • Model(s) contain the business logic and rules

  • Controllers are responsible for passing data between the Model and the Views.

Upvotes: 1

Related Questions