If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Is my MVC application 1-Tier or 2-Tier?

Brussels Sprout · 2012-07-12 11:11:07

I have created a simple ASP.NET MVC 3 application that interacts with an Oracle Database. All of the SQL queries are hard coded into the relevant action methods of the Controller class in the MVC. I had initally assumed that this was a 2-Tier system but now I'm not so sure since I don't have a separate data access Tier.

Options

12-07-2012 12:11pm

#1

Brussels Sprout

Registered Users Posts: 7,110 ✭✭✭

Join Date: January 2010

Posts: 6866

I have created a simple ASP.NET MVC 3 application that interacts with an Oracle Database. All of the SQL queries are hard coded into the relevant action methods of the Controller class in the MVC. I had initally assumed that this was a 2-Tier system but now I'm not so sure since I don't have a separate data access Tier.

0

Comments

Options
#2 12-07-2012 12:49pm
srsly78

Registered Users Posts: 7,157 ✭✭✭

Join Date: October 2010

Posts: 7095

Just call it N-tier and you're golden.

0
Options
#3 12-07-2012 1:09pm
Giblet

Registered Users Posts: 11,979 ✭✭✭✭

Join Date: October 2001

Posts: 11370

1 Tier. Your controllers should be as light as possible, 1 or 2 lines in most cases. You need to encapsulate your dataaccess in a library or else you will need to rewrite controllers every time you need a db change.

0