title: In a visual studio database project, after I add new foreign keys to the project how do I stop it from checking the data against those keys?
body: <p>I added a bunch of foreign keys to the database project when previously there weren't any. In the generated sql file (sql/debug/$projectname.sql) I see a part that starts with</p>
  
  <pre><code>PRINT N'Checking existing data against newly created constraints';
  GO
  USE [$(DatabaseName)];
  
  
  GO
  ALTER TABLE [dbo].[table1] WITH CHECK CHECK CONSTRAINT [FK_1];
  
  ALTER TABLE [dbo].[table1] WITH CHECK CHECK CONSTRAINT [FK_2];
  </code></pre>
  
  <p>and on it goes.</p>
  
  <p>How can I stop the database project from generating this section that checks the data against the new constraints? I tried creating the foreign keys using</p>
  
  <pre><code>ALTER TABLE dbo.table1 WITH NOCHECK
  ADD CONSTRAINT [FK_1]
  FOREIGN KEY (blah)
  REFERENCES Table2 (blah2)
  </code></pre>
  
  <p>but no dice. Any suggestions?</p>