All geek questions in one place

How to stop a database project

I use the VS2010 premium and I have a database project in my solution. I use this only to store SP scripts and functions so that I can store them in TFS and execute them against our Dev DB.

So, I edited the solution configuration so as not to build a project that works as the output of the assembly:

------ Skipped Rebuild All: Project: SocratesApplicationDB, Configuration: Debug Any CPU ------ Project not selected to build for this solution configuration ========== Rebuild All: 15 succeeded, 0 failed, 1 skipped ==========

But, since I do not have tables with links, etc., I still get SQL03118 and SQL04151 overhead errors, which makes it difficult to find any "real" errors / warnings.

Does anyone know how to get VS to completely ignore my database project and not try to validate anything (other than to drop it from my solution)?

+4
source share
2 answers

If you right-click the project file in the solution explorer and click "Unload project" (it is located at the bottom), it will leave the project as a link in the solution, but it will no longer try to create it or link any errors / warnings / messages from the project .

In addition, many warnings, as a rule, come from files opened on the tabs of the visual studio (they tried to compile them using intellisense, etc.), so try right-clicking on the current tab of the file and “close everything except this " This is not necessary after you unload the project, because it will close everything anyway.

To return the project to your solution, simply click on the "Update Project" button when you are ready.

+3
source

Edit - just re-read the OP and realized that he did it (disabled in Configuration Manager) and still saw the messages. Therefore my proposal is controversial

0
source

Source: https://habr.com/ru/post/1369074/

More articles:


All Articles