Unit Testing for SQL Server in Visual Studio 2013

added by kalyanms1
1/10/2014 8:09:21 PM


Unit Testing is commonly leveraged in application development and this can applied to database development as well, In Visual Studio 2013 integrated database testing can run directly against the database.It can even be configured automatically in the team build scenario. This post outlines how to create database unit testing in Visual Studio 2013. Create a new SQL Server database project in Visual Studio 2013, to do the unit testing of a stored procedure go to SQL Server object explorer and under the projects node you will see the database that you are trying to write the unit test case, off course it is a logical view of your database