I finally got around to updating the tSQLt test adapter for visual studio, you can download it from:
https://marketplace.visualstudio.com/items?itemName=vs-publisher-263684.GoEddietSQLt2019
or the search in visual studio extensions thingy finds it as well.
For details on what this is and how it works see the original post:
https://the.agilesql.club/2016/08/tsqlt-visual-studio-test-adapter/