This tutorial will teach you the basics of building an ASP.NET MVC Web application using Microsoft Visual Web Developer 2010 Express Service Pack 1, which is a free version of Microsoft Visual Studio.
Should I be adding the tables relevant to the view to the @Elyasin I saw this as more of a conceptual question.
If the statement does exist in memory, Oracle Database can reuse it and skip the task of parsing and optimizing the statement.
Using bind variables makes the statement reusable with different input values.
While I need to retrieve data from all of the tables to build my DTO often, in my update/delete methods, I only need to work with a subset of those tables (none of the lookup tables, for example, and only those tables that the user changed).
In other words, my Get and Delete/Post methods look very different, anyway.