Code Coverage 0.0% for TSQL Projects(Contains Stored Procedures, Tables, Scripts etc)

Question

Code Coverage 0.0% for TSQL Projects(Contains Stored Procedures, Tables, Scripts etc)

Supravat Samanta 21

We have used MSTest as testing framework for writing all Stored Procedures unit test case for TSQL projects.
Its showing now 0.0% coverage for all Stored Procedures though all are having the valid Unit Test cases. Is it possible to do code coverage for TSQL projects?
The code coverage is working fine for .NET web projects.

Any help will be appreciated.

Accepted answer

0 additional answers

Your answer

Answer 1

Tianyu Sun-MSFT 34,436 Microsoft External Staff

Hello @Supravat Samanta ,

Welcome to Microsoft Q&A forum.

Indeed, MSTest works well with .NET, but for TSQL, did you refer to(follow) this document: How to: Create a Test Project for SQL Server Database Unit Testing? It is a little different from MSTest (.NET).

Best Regards,
Tianyu

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Supravat Samanta 21 Reputation points

2021-07-09T07:59:52.653+00:00

Thank you for the update.

We have followed and created the Unit test case as per the link mentioned by you. But the code coverage is not working as expected like .NET projects and its showing 0.0%.

Any specific URL/solution to make the code coverage 100 % for TSQL projects.
Tianyu Sun-MSFT 34,436 Reputation points Microsoft External Staff

2021-07-09T09:08:15.793+00:00

Hi @Supravat Samanta , thank you for the reply. After checking this document: Troubleshoot code coverage, I think code coverage is not support for T-SQL, as the document mentioned The code coverage analysis tool in Visual Studio collects data for native and managed assemblies (.dll or .exe files).
Supravat Samanta 21 Reputation points

2021-08-27T13:01:35.677+00:00

Thank you so much for the update.
I have similar question related to SSIS Unit Testing code coverage.

We are trying to use external tools like SentryOne, SSISUnit, BizUnit etc for generating automated Unit Test case for our existing SSIS solution projects.

But its not supporting the code coverage(Test/Analyze Test Coverage).

Is it possible to generate the code coverage for SSIS components. And also any specific tool we can use for SSIS Unit Testing which will be supporting code coverage. Any help you could provide would be much appreciated.

Share via

Code Coverage 0.0% for TSQL Projects(Contains Stored Procedures, Tables, Scripts etc)

0 additional answers

Your answer