I am using a SQL Server 2016 instance with the WideWorldImporters (WWI) database, SQL Server Management Studio 2016 (SSMS), and Visual Studio Community 2015 (VS) with SQL Server Data Tools (SSDT). It will also show how to update the database in Visual Studio if changes are made to the underlying database structure. This article will demonstrate how to set up unit tests using an existing database and using new, custom SQL scripts. An existing database can be imported into Visual Studio or new SQL script files defining schemas, tables and procedures can be written and imported into the solution. Visual Studio with SQL Server Data Tools can be used to perform unit testing against stored procedures to test expected output and behavior.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |