ASP.NET n-tier application unit testing

Question

4.00/5 (1 vote)

See more:

Hey,

I've posted about this application before and had some good responses, so hopefully you guys can help again.

I'm currently undertaking my final year of a Computer Science degree in the UK, and building an ASP.NET Web Forms CMS with an E-Commerce module as my final project.

I'm using N-Tier architecture, and used a few tutorials from here to create an Entities Layer, Data Access Layer, Business Logic Layer and Presentation Layer.

I'm looking in to unit testing the BLL to start with, but didn't use an ORM for the DAL, so I'm having trouble trying to cut out the database dependencies with a mocking framework.

An example flow of information through my App:

->Presentation calls the BLL GetProducts() method.

->BLL calls the DAL GetProducts() method which returns a list of product entities.

->DAL GetProducts method creates a list of product entities from the GetProductList() stored procedure in the database.

How would you go about unit testing the BLL, and integration testing the DAL? I'd rather not switch out to using an ORM such as EF or NHibernate as I produced a lot of documentation on the architecture that is being used so far, and any major changes would mean a lot more documentation to be written.

The majority of online information seems to be combining Moq with EF and MVC4.

Thanks in advance,
Stu.

Posted 3-Feb-13 7:07am

stuuz

Add a Solution

Comments

Kishor Deshpande 3-Feb-13 21:49pm

So, basically you are trying to build a n-layer application in which you have DAL, BAL and Presentation layers separated.

n- tier means you have your presentation at a separate server probably a web server, Database at another and Web Services deployed on separate machine.

2 solutions

Solution 1

For unit testing the BLL, you can always consider using the Microsoft Visual Studio Testing Framework or a third party like Nunint.
For a mocking framework, you can consider using Moles[^].

Posted 3-Feb-13 7:10am

Abhinav S

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kishor Deshpande · Accepted Answer · 2013-02-03T15:59:00

Hi,
MSTest comes with Visual studio which is testing framework.
Now, when you think about isolation framework to remove external dependencies, most of the developers use Rhino Mocks.
If you really want to learn how you can write Unit tests for your BAL code without changing it to OR/M,
The best reference book is: The Art of Unit Testing
with Examples in .NET by Roy Osherove