Olivier Van Steenlandt provides an overview of adding tSQLt to a Visual Studio database project:
As a first step in the process, we’re going to create a new Database Project, in my case, I will be calling my Database Project AdventureWorksDW_UnitTesting and my solution AdventureWorks.
If you are not sure how to set up a Database Project in Visual Studio from scratch, don’t worry, you can follow the step-by-step data recipe I released a while ago, Getting Started with Database Projects and Version Control
Read on to learn more about how to add the tSQLt objects and eliminate cross-database reference issues.