title: Data-Tier Projects and Linked Servers
body: <p>I'm trying to use a Data-Tier application involving a linked server and running into an odd problem.</p>
  
  <p>Here's what I have:</p>
  
  <p>1) A VS2010 solution which includes a Data-Tier project.</p>
  
  <p>2) The Data-Tier project targets an SQL 2008 R2 server.</p>
  
  <p>3) The SQL server has a working linked server connection to an Oracle database.</p>
  
  <p>4) Views within the Data-Tier project reference the linked server using OPENQUERY</p>
  
  <p>The linked server connection is valid, running queries against it on the server work fine, and creating the views directly on the server works fine as well. </p>
  
  <p>However, whenever I attempt to build my Data-Tier application I get the following error:</p>
  
  <pre><code>SQL03006: View: [dbo].[vwMyExampleView] has an unresolved reference to object [MyExampleLinkedServer].
  </code></pre>