i am developing a application using n tier architecture. i wanted to unit test my data access layer(DAL) which cointain stored procedure. can anybody give me any link for article,video tutorial, podcasts, webinars that will be very helpfull.
If you have Visual Studio Premium or Ultimate, Database Testing is part of Visual Studio. You can test functions, stored procedures, and triggers. Here is the Visual Studio Database Testing page: http://msdn.microsoft.com/en-us/library/aa833169.aspx
If you don't have VS Premium/Ultimate, you can create your own test harnesses and run them from a command line application. That is the approach taken in this MSDN Magazine article: http://msdn.microsoft.com/en-us/magazine/cc163925.aspx
bijay87
Member
6 Points
5 Posts
unit testing n tier application
Feb 14, 2012 08:23 AM|LINK
hi,
i am developing a application using n tier architecture. i wanted to unit test my data access layer(DAL) which cointain stored procedure. can anybody give me any link for article,video tutorial, podcasts, webinars that will be very helpfull.
thanks in advance
DarrellNorto...
All-Star
86795 Points
9644 Posts
Moderator
MVP
Re: unit testing n tier application
Feb 14, 2012 09:24 AM|LINK
If you have Visual Studio Premium or Ultimate, Database Testing is part of Visual Studio. You can test functions, stored procedures, and triggers. Here is the Visual Studio Database Testing page: http://msdn.microsoft.com/en-us/library/aa833169.aspx
Here is a blog post of a developer showing how he used VS Database Testing: http://blog.coryfoy.com/2007/07/test-driving-stored-procedures-in-sql-server-in-vs2008/
If you don't have VS Premium/Ultimate, you can create your own test harnesses and run them from a command line application. That is the approach taken in this MSDN Magazine article: http://msdn.microsoft.com/en-us/magazine/cc163925.aspx
If you are into the xUnit style of frameworks (NUnit, JUnit, MbUnit, etc.), then try TSQLUnit: http://sourceforge.net/apps/trac/tsqlunit/ Here is a getting started link: http://sourceforge.net/apps/trac/tsqlunit/wiki/CookBook
Darrell Norton's Blog
Please click "Mark as Answer" if this helped you.